Hey guys! I have a problem with a macro that saves to a specific online server. The server is currently called Z:\. It however does not save to this directory (which you can find after ChDir) but to my local documents folder. Please help!
Please Login or Register to view this content.
Your FileName argument lacks Folder path.
You'll need to concatenate "Z:\docs\offertes\" & smystring & "\3. Calculatie en offerte\" & FnamePlease Login or Register to view this content.
By default, SaveAs without the path string will save to Excel's default save location (which is usually your documents folder).
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks