Forum home » Delegate support and help forum » Microsoft Access Training and help » access-database-training - Macros
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access-database-training - Macros
Resolved · Low Priority · Version Standard
Reply Fri 27 Jul 2007, 09:58Delegate Sin said...
Sin has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Macros
I would ike to export a table in excel format and am creating a macro to do so. the problem is that I don't know how to give the user the option of choosing where to save the file to.
For upcoming training course dates see: Pricing & availability
RE: Macros
Hi Sinead
thanks for your question. Depending on how you want your macro to work you may find the following on the Microsoft Developer website helpful.
http://msdn2.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.saveas(VS.80).aspx
Do let us know if we can be of further assistance.
Kind regards,
Andrew
|