Macros

  • Thread starter Thread starter TYE
  • Start date Start date
T

TYE

Hi,

I've got a macro that gets the information from the file,
runs all the queries BUT then i want the information to be
exported into a an Excel format save it.

Can you please help.

Thanks
 
TYE,

Use a TransferSpreadsheet action at the end of your macro. See Access help
on TransferSpreadsheet.

HTH,
Nikos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Can Data from a Table Field be Used to Create Queries Automaticall 1
Word to Excel: Export comments with text and line number 0
Export Format not avaiable 1
Macros / Scripts in Word and Excel 1
Excel On Error Resume Next 2
export access report into excel 3
Formatting date gives bad results in query 2

Back
Top