Formating Excel via Access

[Kevin]

I have exported a table from Access to Excel and would like to set some
formatting to the new spreadsheet. Specifically, I would like to set the
column width of columns A - F, and bold the header row (row 1). Ideally, I
would like to have it AutoFilter, but I think that is a bit overzealous at
this point!

Thanks in advance,
Kevin

 

[Kevin]

Please see my other post under this same sbuject. For some reason the
message board said it could not process my post, so I posted the same
question again.

Sorry for the trouble!

 

[PC Datasheet]

Go into Excel and start Record Macro. Go through the processes you mention
here; set the column width of columns A - F, and bold the header row (row 1)
and set AutoFilter. Stop Record Macro. Go to edit macro and you will see the
code needed to do these things. Copy and add the code to your Access code;
you will need to edit it some to apply the code to the Excel model.

 

[Kevin]

Great tip- thanks!

Go into Excel and start Record Macro. Go through the processes you mention
here; set the column width of columns A - F, and bold the header row (row 1)
and set AutoFilter. Stop Record Macro. Go to edit macro and you will see the
code needed to do these things. Copy and add the code to your Access code;
you will need to edit it some to apply the code to the Excel model.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com