Can i insert VBA code into an XLS exported from Access?

[simon_marklar]

Hi Guys,

I have some data in Access that needs to be formatted in excel. This happens twice a year, each time with a new dataset, so i'd like to automate it. I can use Access' "OutputTo" to output the data to an excel file, but i'd like to format it at the same time. I want to insert some vba code for the formatting that is run on the opening of the excel sheet. Is there a way to do this in Access' VBA or do i have to manually cut and paste the code into the newly exported spreadsheet?

thanks in advance
%simon

 

[ghudson]

You can easily format the Excel file from Access. Check this thread out on how I do it.

hiding excel manipulations and showing a progress bar

 

[simon_marklar]

HA! as always, i should learn to KISS

thanks for that
%simon