Formatting after export from Access

[BaudKarma]

Management has decided that they would like to see some of the data from my Access database exported to an Excel spreadsheet. I can handle the data export with no problem, but then I find myself opening up the spreadsheet and spending 15 minutes retitling the column heads, bolding and coloring some of the data, expanding columns to show all the data, etc.

Is there a way to save these layout changes and apply them automatically, or at least automate the process to some extent? My Excel skills aren't so hot, so I hope I'm missing something obvious.

 

[AnotherHiggins]

In Excel:

Go to Tools > Macro > Record New Macro. Save in Personal.xls.

If you need help tidying up the code that is produced, please post in forum707, VBA Visual Basic for Applications (Microsoft) Forum.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[KenWright]

What kind of analaysis are we talking about. You don't necessarily have to export to Excel, as you could always use a Pivot table perhaps and interrogate the Access file directly.

Or, take a complete data dump into Excel and Pivot from there.

The macro idea is certainly the way to go for a standard report template, unless of course the report is a summary like report, in which case why not just have it on one sheet in a file, pulling from another sheet in the same file (ie a sheet containing your export), and then just replace the source data each time. Your summary, if linked correctly, will then simply update, and you won't spend a second on redoing all that formatting.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------