Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Staying it its own directory. | Excel Worksheet Functions | |||
Slow opening directory structure in Excel 2002 | Excel Discussion (Misc queries) | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
Saving into new directory | Excel Discussion (Misc queries) | |||
How do I insert the directory path in my Excel file? | Excel Worksheet Functions |