See my quote
The way I would do it would take time and effort but it is possible.
There may be a third part app to do this but I usually try to do thingsReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13203
myself so the
way I would do it is through "Automation". .
You would directly control the process of exporting the data to the
Excel sheet, and
creating the formating.
I won't go into a complete discusion
but basically you set a reference to the Excel Object Library and then can
use that to
Open a Workbook, Set cell values and format the cells.
If you decide to go this way I can show you an example of something I am
chornis at cap-associate.com
Visit weekly Access conferences
Tuesday, 11:00am-12:30pm (Eastern US)
Thursday, 3:30pm- 5:00pm (Eastern US) http://community.compuserve.com/n/pf...g=ws-msdevapps
"Think outside the box, because anything is possible."
"How long it will take or whether it requires divine intervention is another
"Joseph Meehan" wrote in message
> email@example.com wrote:
>> I have a report in Access which I want to export to Excel with the
>> formatting intact. The formatting is rather complex with several
>> headings and fields with borders. I have tried the "Analyze This"
>> command but the formatting is totally lost.
>> Is there a way I can save as much of the formatting as I can? Are
>> third party software that can do this?
>> Thanks in advance
> I don't think there is any way to do what you want, but I can think of
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13203
> a couple of ways that you might make it easier on the other end if you use
> the same format each time. Check over at the Excel NG.
> Joseph Meehan
> Dia duit