Greetings,
For several years, I have been using Access 2007 to generate a report and export it to Excel. I have done this primarily from two computers. One of those computers recent crashed, so I had to prepare a replacement.
Unfortunately, I'm now getting a runtime 2282 error when I try to run the report: "The format in which you are attempting to output the current object is not available". When I click debug, this is the highlighted line:
DoCmd.OutputTo acOutputReport, "Best Seller", acFormatXLS, "(my document)"
NOTE: The line says XLS. I understand that Access cannot export as xlsx.
The strange thing is, the report still works fine from the other computer that can run it. Both computers have Access 2007 and Excel 2010, but one of them is flagging this 'format not available' error. I'm guessing there is an issue with my settings for Access, but I'm not sure where to look.
Any advice would be much appreciated. Thank you for your time!