Error When Exporting Reports using TransferSpreadsheet in Macro

[Guest]

Hi,
I'm trying to export 5 Reports Using macro with the TRANSFERSPREADSHEET, but
I keep getting error "The Microsoft jet database engine could not find the
object "report name" make sure object exist etc. But I'm able to save
manually by right click the report. Also I did a test for one report using
OUTPUTTO and that works. So any ideas how I can make this to work? Or
Is there a way to use the OUTPUT TO and put those 5 reports into same file
different sheets?

Please advise any help
thanks,
juan

 

[Guest]

TransferSpreadsheet is for importing and exporting either Excel or Louts
spreadsheets. You will not get it to work with a report. the OutputTo
method, unfortunately does not support a range that will allow you to put the
reports in different sheets.
What you really need to do is use queries instead of reports, then use the
TransferSpreadsheet to export the results of the query to a spreadsheet.
With this method, the range arguement will allow you to specifiy a sheet
withing the workbook. Ignore the fact the Help says the range does not work