Exporting from Access to Excel keeping EXCEL formatting

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

I have coded the process of 1. creating an Excel file via MS Access,
2. adding several tabs in the workbook each with different datasets on
each tab and 3. I manually update the formatting of the columns,
borders, etc. each time.

I run this routine weekly and I am growing tired of reformatting the
first row (column headings), column widths, etc. every time I run the
routine. Is there a way to export the data to a range in the
worksheet similar to importing a range? For example, I want to export
all of the data in Query 1 to Sheet 1 beginning with cell A2. Then, I
want to export Query 2's data to Sheet 2 beginning with cell A2, and
so on.

Hopefully, this makes sense. I can create a macro in Excel and
execute the macro each time but I wanted to see if there was another
way to skin this cat...managing the macro from workbook to workbook
could be a bear after a while.

Thanks.
 
Thank you VERY much for the assistance. Fortunately, this is what I
was looking for. UNFORTUNATELY, you've opened my eyes to whole
boatload of more potential I had not thought about...lol. Thanks for
the extra work ;-) Take care.
 
Back
Top