If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Saving to "open" directory
I need to create a "save file" command in my macro which allows the file to save to the current directory to prevent "run errors" if the end user has a different directory tree. E.g. I may be using a default c:\ directory, but the spreadsheet user may be on say h:\ directory on a network. The save command needs to be able to save to the open directory. Any advice appreciated! -- 9119 ------------------------------------------------------------------------ 9119's Profile: http://www.excelforum.com/member.php...o&userid=30593 View this thread: http://www.excelforum.com/showthread...hreadid=502418 |
#2
|
|||
|
|||
Saving to "open" directory
You could try in VBA: ActiveWorkbook.SaveAs CurDir & "filename" Not sure if this is what your after -- nickysquawkes ------------------------------------------------------------------------ nickysquawkes's Profile: http://www.excelforum.com/member.php...o&userid=30630 View this thread: http://www.excelforum.com/showthread...hreadid=502418 |
#3
|
|||
|
|||
Saving to "open" directory
Thanks Nicky... that works fine for my purposes. -- 9119 ------------------------------------------------------------------------ 9119's Profile: http://www.excelforum.com/member.php...o&userid=30593 View this thread: http://www.excelforum.com/showthread...hreadid=502418 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Edit Hyperlink Default Directory | Souljah38 | General Discussion | 2 | December 20th, 2005 09:46 PM |
View full directory path when saving a document | Julian McEvoy | General Discussions | 0 | November 28th, 2005 12:38 PM |
Find People Directory Service Outlook 2000 | Randall | Installation & Setup | 0 | November 4th, 2005 03:48 PM |
Slow Open directory read | Lee Harwell | General Discussion | 0 | August 19th, 2005 04:52 PM |
Directory starting witht the Current Directory | Neeraja | Worksheet Functions | 1 | September 18th, 2003 05:40 AM |