By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,254 Members | 2,418 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,254 IT Pros & Developers. It's quick & easy.

VBA Code to Open Save File or Save As Dialog Box

P: 77
Hi,

In my VBA code I am saving an excel spreadsheet with data from a table.
I would like to prompt the Save File or Save As Dialog box with a default File Name, after opening the spreadsheet.

Please help me with the code.

Thanks
Jan 28 '08 #1
Share this Question
Share on Google+
2 Replies


P: 77
Someone please help, its very urgent, need to finish by tomorrow.

Thanks
Jan 29 '08 #2

P: 32
you can try this link http://www.meadinkent.co.uk/aopendlg.htm

other wise the "write to excel sheet" that was posted ealier is the easiest way to do it and then the users can save as when they are done.

Someone please help, its very urgent, need to finish by tomorrow.

Thanks
Jan 29 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.