Can you use a Macro to auto format a MS Access Report (exported to Excel)?

Hello All,

I'm new to the site as well as macros and was hoping someone could help.

Every month I'm asked to run a report out of MS Access, when I run the report I then export the data to MS Excel. Using an Excel file from the previous month I format it to look identical to the prior months spreadsheet. The formatting I perform are deleting rows, cutting and inserting columns in different orders, formatting cells (such as dates,numbers, and alignment). And that is pretty much it. I would like to know if there is a way for me to record what I am doing using a macro, so that when it is time for me to run a report from MS Access I could run a macro so that all the formatting is done automatically. Basically I would like to avoid having to manually do all the necessary formatting every month. I attempted to record the macro today, but when I ran it, it errors out. Can someone help me figure out what I may be doing wrong. Id really appreciate it. Thank you!

Hello Arlu1201,

Thanks to the help of other forum members, this posting was solved on the following thread:

http://www.excelforum.com/excel-prog...html?p=3224969

Originally Posted by arlu1201

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.