Importing / exporting formats

[Cowichandave]

I am exporting the results of a query in Access to Excel using a macro to an existing file.

I would like the resulting excel file to have specific row sizes and column width and a specific background color.

This would be best if it could be accomplished with a single pushbutton action in Access which I have not figured out to set as a new user.

Alternatively is it possible for Excel to automatically handle an import and format the resulting table?

 

[Smitty]

Welcome to the Board!

Your best bet is to record a macro applying the format you want. If you need some help making it work with a dynamic range, just post the code you end up with and someone can tweak it for you.

 

[Cowichandave]

In Access 2007 macro recording is not available. I know I can create a macro in Excel to do this but I really would like this as a one step process in Access or can one set Excel so that whatever is exported to it is formatted automatically

 

[Smitty]

In Access 2007 macro recording is not available.

Not unless I'm missing something.

I know I can create a macro in Excel to do this but I really would like this as a one step process in Access or can one set Excel so that whatever is exported to it is formatted automatically

You might be better off posting this in the Access forum, but in my experience the two don't play well with eachother in terms of formatting.

And if you can get your formatting set up via code then it can be seamless to your end users anyway (hence automatic).