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
Failing code
Please Login or Register to view this content.
Any help please!Please Login or Register to view this content.
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.
Last edited by Richard Buttrey; 10-04-2013 at 12:21 PM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
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.
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..
...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:\"
Range("driver name"), is D.stanley or r.jones ect.
This also. fails with string "rota/" &
Hi,
Time to upload the workbook so that we can see your problem in context.
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!
Hi
FileName = "C:\" & Range("DriverName") & " " & " 29th September 2013"
works just fine for me.
Are you sure you actually have a "C:\" drive path?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks