ACCESS FEED: RE: [MS_AccessPros] Using vb to export query data to excel

Kamis, 01 Maret 2012

RE: [MS_AccessPros] Using vb to export query data to excel

Connie-

When you do it in VBA, you are responsible for specifying the file location.
You can find sample code to prompt a user for a file name here:

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

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Boston, MA)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
Sent: Thursday, March 01, 2012 1:50 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Using vb to export query data to excel

I was previously exporting data to excel using a macro but need to add a bunch
of code beforehand so need to use vb. Is there a way to have a box open asking
where the info should be saved and what the name of the table should be? I
really liked the way that the macro did it.

What I have so far:
DoCmd.TransferSpreadsheet acExport, acSpreadSheetTypeExcel8, "qListingsRawData"

thanks!
Connie

------------------------------------

Yahoo! Groups Links