What VBA Would I Use To Center A Heading Over Multiple Columns In An Access Report?

[ATTHECROSS]

Hello All -

I am setting up reports that I will export by a click button and I am trying to center the heading for the various reports over multiple columns. Does anyone know the VBA I would use to carry out this task?

Thanks for the help in advance!

[pbaldy]

I'm not clear on what you're doing. if you center them as desired in design view, they should keep that when exported to PDF.

[ATTHECROSS]

I am exporting the reports to excel by VBA, which will open a new excel workbook and a new tab for each report within that workbook. So I need to have the headings of each report tab to span column A to column M.

Hope this helps.

Thanks

[pbaldy]

In my experience, exporting a report to Excel results in a mess. A simple one might come out okay, but I gave up. I typically export the underlying query. If the headings are consistent, I'd use a template spreadsheet and export the data starting under the header. When I need to do the formatting as I export, I use Excel automation, which would let you do that centering. The template is probably simplest though.