Access to Excel query dump auto format in Excel

[Babyhueyvfr]

Ok I am sure this is simple to do in a complex way. I am working on a Access Data Base that tracks rent amounts for leases, and have several reports and queries that get dumped to excel by several users. These dumps don’t seem to look great when they are opened in excel, row and column widths and header formatting not what we want. I have coded a single macro that corrects all these formatting issues in all cases, in my Personal.XLS workbook. I can distribute that module out to the other users. My issue is I would like to make it transparent to them that it’s running. My thought is an macro in the personal.xls file that autoruns (need help with that as I have been unable to get it to run) that tests the file name (controlling that in Access) and if the test passes run the formatting code(modual 1) if not then it does nothing.

Can anyone help me down this path, or tell me my idea sucks and there is a very simple way to do this.

Thank you,

 

[BrianB]

In the absence of other replies - I think the best way would be to simply have a button for them to click.