Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default prompting user for the directory to save an excel file to

Can I design a macro in excel that asks the user for the filename and
directory path?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default prompting user for the directory to save an excel file to

Take a look at VBA's help for application.getsaveasfilename



kiwiwulf wrote:

Can I design a macro in excel that asks the user for the filename and
directory path?


--

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 without prompting in Excel Macro [email protected] Excel Programming 2 November 16th 06 04:01 PM
File closes without prompting to save freyabeads Excel Discussion (Misc queries) 0 March 1st 06 01:00 PM
Close Excel file without prompting user to save JDay01 Excel Programming 8 May 10th 05 09:14 PM
Save CSV File without prompting Chris Excel Programming 3 September 23rd 04 04:33 PM
Save file without prompting andym Excel Programming 1 February 20th 04 02:11 PM


All times are GMT +1. The time now is 01:28 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"