acFormatXLS issue (1 Viewer)

All,

I am hoping one of your guys may be able to help me with a problem I am experiencing with the acFormatXLS option in my database.

Basically I have a form in my database that has a command button which output a queries results to an e-mail attachement in Excel format using the acFormatXLS command.

This is working fine except the columns and rows of the spreadsheet do not maximise automatically to fit in all of the data.

Obviously this is a simple task to correct once the spreadsheet is opened, however my users (being lazy people) want this to be an automatic process.

i.e I output the spreadsheet as an attachment to an e-mail, with the columns and rows automatically maximised.

Any ideas?

Cheers guys

Well if you search the forum you can find some samples on how you can open excel from Access and then manipulate the excel sheet in anyway you want (i.e. adjust columns and add colors etc)