how to specify a file save path to a save macro

**Solidstan** · 10-04-2013, 11:30 AM

I have a working macro which save to documents folder, I have tryed without success to modify this to save to a desktop folder or even a "C:\" drive folder.

working VBA Code

Please Login or Register  to view this content.

Failing code

Please Login or Register  to view this content.

Any help please!

**Richard Buttrey** · 10-04-2013, 12:19 PM

Hi,

What does Range("DriverName") equate to?

And are you sure it's failing on the 'FileName = ' line or does it fail on the following line?

I ask since I had exactly this problem earlier this week - see thread

http://www.excelforum.com/excel-prog...ml#post3425557

which may help you.

**Solidstan** · 10-04-2013, 12:26 PM

Range("DriverName") is a cell containing a drivers name.
when I add "C:\" & to the FileName= line, the following line fails, but the following line of course does point to the file name.

thanks.

**Solidstan** · 10-04-2013, 12:35 PM

I think my confusion is between the FILE PATH and FILE NAME.

Im not sure how to set a FILE PATH into my code. I think im trying to add "C:\" into the file name, which of course wont work.

Any help with this please..

**Richard Buttrey** · 10-04-2013, 12:39 PM

...but as I said, what is the Range("DriverName") evaluating to in VBA?

i.e. what do you see when you hover over it?

There's nothing wrong with adding any string before it, but if the range also contains the string "C:\" then obviously the code won't understand "C:\C:\"

**Solidstan** · 10-04-2013, 02:46 PM

Range("driver name"), is D.stanley or r.jones ect.
This also. fails with string "rota/" &

**Richard Buttrey** · 10-04-2013, 02:58 PM

Hi,

Time to upload the workbook so that we can see your problem in context.

**Solidstan** · 10-04-2013, 03:27 PM

If anyone could make this attached macro work, I would be SOO grateful.

'Remove "rota\" & and this run good, or just even remove the \ and it runs.

Thanks!

**Richard Buttrey** · 10-04-2013, 05:33 PM

Hi

FileName = "C:\" & Range("DriverName") & " " & " 29th September 2013"

works just fine for me.

Are you sure you actually have a "C:\" drive path?

how to specify a file save path to a save macro

LinkBack

Thread Tools

Rate This Thread

Display

how to specify a file save path to a save macro

Re: how to specify a file save path to a save macro

Re: how to specify a file save path to a save macro

Re: how to specify a file save path to a save macro

Re: how to specify a file save path to a save macro

Re: how to specify a file save path to a save macro

Re: how to specify a file save path to a save macro

Re: how to specify a file save path to a save macro

Re: how to specify a file save path to a save macro

Thread Information

Users Browsing this Thread

Similar Threads

Macro to Save As a Copy of the File, Save the Original File, & Overwrite Previous Versions

[SOLVED] VBA for file save as macro enabled to a specifi path and folders

Macro to save sheet as CSV using a dynamic file name and file path

Macro to save workbook by referencing cell in another workbook for file name and file path

Save As in a certain file path

Bookmarks

Bookmarks

Posting Permissions