[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7
• New Files 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___