exporting spreadsheet

[okschlaps]

Hi
I'm trying a very simple (I thought) export to excel. Here's my code:
DoCmd.TransferSpreadsheet acExport, , "TestTable", "D:\Roxanne\Test.xls", True
It runs, but there's no data in the spreadsheet. What am I missing?
Thanks for your help.

 

[OfficeDev18 via AccessMonster.com]

Are you checking all the sheets in the new workbook? When exporting, Access
makes a new worksheet, in this case called "TestTable" and that's where the
data resides.

Sam

 

[okschlaps]

Well, I'll be! There they are. Thank you, Sam!

Are you checking all the sheets in the new workbook? When exporting, Access
makes a new worksheet, in this case called "TestTable" and that's where the
data resides.

Sam