BlueFraggle
Registered User.
- Local time
- Today, 21:02
- Joined
- Jul 25, 2007
- Messages
- 10
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
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