access-database-training - Macros

The UK's most regular instructor-led training courses.
Training information: access-database-training · Access course microsoft training · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Macros

Sinéad has attended:
Access Intermediate course
Access Advanced course
Access VBA course

by - delegate Sinéad [15 posts] (2007 Jul 27 Fri, 09:58) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Bayswater	0	FULL
2003	2008 Sep 3 Wed	Southwark	3	book now	£224	£235
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	8	book now	£110	£224
Full Schedule: See all 55 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Macros

by - trainer Andrew gold contributer [398 posts] (2007 Aug 13 Mon, 14:11) Reply

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

· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Take an Access Course to Learn About Relational Databases
· Material covered on a Microsoft Access Course

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips