Trying to save a copy of a master excel on C: to Google G drive with a new name

Hello,

I am not fluent in VBA code, but I know a little. I am trying to make a macro that will save a master excel file in a different drive (G) and let the user plug in a new name. I have gotten very close, but it always saves it in my current (C) drive. It saves just fine in (G) if I wanted to use the same file name, but I want the user to put in a new one. I have tried using the * for the file name, but it doesn't like it.

I have also used the ChDir command, but it evidently forgets when I try and save the file. Any help you can give is appreciated.

See below:

Please Login or Register  to view this content.

(This won't open in G drive to save)

I have also tried this:

Please Login or Register  to view this content.

I am not very familiar with the DIM commands, but I am wondering if that is what I need. Thank you for any help you can give.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer