dz2k7
Not only User
- Local time
- Yesterday, 23:37
- Joined
- Apr 19, 2007
- Messages
- 104
Hi Champions,
Here is another challenge.
My Access DB generates about 200 separated Excel files using Export.
Each of Excel files has 3 tabs. If some data is missing, some tabs might be not generated and sometimes if there is no data for all 3 tabs - then the whole file might be not generated.
Then another VBA module automatically sends generated Excel files to recipients.
Here is the problem.
When Access creates the new Excel file it does not have any formatting.
When data gets exported it looks like raw material.
No formatting at all.
The question.
Is there any way to format Excel file while exporting using the same Access module.
No details, just a main idea.
Thanks a lot.
Here is another challenge.
My Access DB generates about 200 separated Excel files using Export.
Each of Excel files has 3 tabs. If some data is missing, some tabs might be not generated and sometimes if there is no data for all 3 tabs - then the whole file might be not generated.
Then another VBA module automatically sends generated Excel files to recipients.
Here is the problem.
When Access creates the new Excel file it does not have any formatting.
When data gets exported it looks like raw material.
No formatting at all.
The question.
Is there any way to format Excel file while exporting using the same Access module.
No details, just a main idea.
Thanks a lot.
