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 ex****t the data to a range in the
worksheet similar to im****ting a range? For example, I want to ex****t
all of the data in Query 1 to Sheet 1 beginning with cell A2. Then, I
want to ex****t 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.
|
