Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 184
Default Save File to specific place`

Hi everyone, is there a way I can save a file to a path that is
specified in Sheet1 Cell A1? Thanks!

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Save File to specific place`

with activeworkbook
.saveas filename:=.worksheets("sheet1").range("a1").value & ".xls", _
fileformat:=xlworkbooknormal
end with

No validity checks at all!



Steve wrote:

Hi everyone, is there a way I can save a file to a path that is
specified in Sheet1 Cell A1? Thanks!


--

Dave Peterson
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
Save File at specific Time leerem Excel Discussion (Misc queries) 0 July 15th 09 02:14 PM
Save file with specific name Dr. Schwartz[_2_] Excel Discussion (Misc queries) 5 January 24th 08 03:48 PM
Save as file name and specific field annep[_8_] Excel Programming 1 January 10th 06 03:21 PM
How to save file to a specific folder? rko281 Excel Discussion (Misc queries) 1 January 25th 05 10:43 PM
Write cells fro one file to a specific place in another Savvo Excel Programming 0 July 7th 04 11:58 AM


All times are GMT +1. The time now is 09:33 AM.

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"