Access VBA-Export to Excel file

washingtons

Registered User.
Local time
Today, 16:09
Joined
Jun 5, 2007
Messages
13
I'm trying to export my access database to excel without overwriting what was already on the file. My query is called Combined Data Query and I'd like it pasted on the first worksheet of an Excel file called Stoplightchart.xls Can anyone write the code for me or point me in the right direction--I have very limited knowledge of visual basic.

Thanks for your help!
 
search help for TransferDatabase

cheers

Dave
 
i dont think you can directly

if you use docmd.transferspreadsheet and fileopensave the dialog prompts you to overwrite the file if it exists

i don't do it, but there are lots of threads here to actually open and manage the spreadsheet in Excel directly and do it that way

have a search.
 

Users who are viewing this thread

Back
Top Bottom