Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 202
Default how do i set file location path?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default how do i set file location path?

Do you mean the default:
Chdrive "D"
Chdir "D:\MyFolder"

or for a specific file

ActiveWorkbook.SaveAs "D:\MyFolder\" & ActiveWorkBook.Name

--
Regards,
Tom Ogilvy

"dennis" wrote in message
...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Bar show the location path file plus the formula Manos Excel Discussion (Misc queries) 1 June 25th 09 08:10 PM
Excel 2007 - File Path location Kevin Excel Discussion (Misc queries) 1 September 26th 08 06:15 PM
Formula too long - new file path is shorter than old file path - Excel 2003 Greg J Excel Worksheet Functions 1 November 22nd 06 05:16 PM
print file path and location in a footer be New Users to Excel 2 June 15th 05 03:56 PM
Activate file without path location? Subscript out of range. Pal Excel Programming 3 February 29th 04 06:00 PM


All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"