Export to Excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to specify my export to Excel 2000 within the DoCmd coding a command button, is this possible

I used the OutputTo Macro at first, but instead of exporting each table into a different sheet within excel (which happens when I export each table manually into Excel 2000) it put all the tables into one sheet

Thanks!
--Emily V
 
Ok, now I'm looking at the coding for the TransferSpreadsheet

Here's my code right now.

Private Sub Export_Click()
DoCmd.TransferSpreadsheet acExport, acspreadsheettypeexcel2000, [Industrial]
DoCmd.TransferSpreadsheet acExport, acspreadsheettypeexcel2000, [Office]
DoCmd.TransferSpreadsheet acExport, acspreadsheettypeexcel2000, [Land]
DoCmd.TransferSpreadsheet acExport, acspreadsheettypeexcel2000, [Retail]
DoCmd.TransferSpreadsheet acExport, acspreadsheettypeexcel2000, [Investment]

End Sub


Is this anywhere near where i need to be?
THANK YOU!
 
Back
Top