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

TransferSpreadsheet Method

P: 38
Hi All,
How can I accomplish the following 3 options when using TransferSpreadsheet to export to Excel:
1. prompt user for file location
2. prompt to overwrite if file exists
3. have the same formatting in the spreadsheet that you get when using OutputTo

Thanks
Sep 14 '07 #1
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
Hi All,
How can I accomplish the following 3 options when using TransferSpreadsheet to export to Excel:
1. prompt user for file location
2. prompt to overwrite if file exists
3. have the same formatting in the spreadsheet that you get when using OutputTo

Thanks

this link will take you to a common dialog. it will prompt your user to select a file or location.

http://www.mvps.org/access/api/api0001.htm

Overwrite is automatic...unless the file is open already..then you're SOL.

Formatting...create a template that formats using an internal macro from within excel itself...you can trigger it for the on open of excel.

J
Sep 15 '07 #2

Post your reply

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