Exporting an Access Report to Excel

I'm afraid you're barking up the wrong tree here. PDFs are graphical objects with limited editing capabilities. Excel is a whole other kind of object.

I would advise against even trying to export reports to Excel like that. It's going to be a waste of time and energy.

Instead, rely on Excel to do the kinds of things it does best, and Acrobat to do the kinds of things it does best, and Access to do the kinds of things it does best.

Access manages data. Data can be formatted in a lot of ways, e.g. in reports. Reports are visual representations of that data. And, in turn, PDFs are visual representations (in a different format) of the visual representation of the data in the Access report.

In order to exploit Excel's strengths you have to figure out what it does best. It CAN be formatted into a visual representation of data, but it can not be coerced into duplicating the visual representation of the Access report or the PDF. So, what to do?

Let Access give the data over to Excel and let Excel format it in a close approximation of the visual representation. After all, your users are mostly interested in getting the right data and secondarily in how it looks. In fact, one would be tempted to wonder WHY they want it in Excel? Are they planning to perform additional summaries, additions or deletions on it once they get their hands on it? Is that a good thing, or a bad thing? Would allowing users to get the data in Excel, knowing that from there it can metamorphize into something else, be a desirable outcome? Only you and your users can decide that one.

What you can do, then, is create a template Excel with two worksheets. The first one, which I like to call a landing page, is where you export data from Access into the workbook. It lands in table format. The second one, which I refer to as the presentation page, is pre-formatted with the layout you want users to see. Link the cells in the presentation page to the data in the landing page. That way you can allow them to see something that looks a lot like the Access report or the pdf, but takes advantage of the features of Excel to do so.

I have a demo of this technique on my website.

Like Scott, I use Excel automation when users need the data in Excel. Whenever I've tried the export to Word or Excel the results were less than desirable.

Here's a simple example of the export process

https://www.devhut.net/ms-access-vba-export-records-to-excel/

The error you are getting indicates a problem with VBA code. When you have such a problem it helps use help you by showing the code you are using.

Whenever, a client asks for an export from a report to Excel, I do not try to export the report itself to Excel, instead I export the Recordsource of the report to Excel.