Keep Formatting - Access to Excel

#1 (**permalink**) 28-Jul-2006, 08:35 AM

Hello,

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"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13203-keep-formatting-access-to-excel.html
command but the formatting is totally lost.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13203

Is there a way I can save as much of the formatting as I can? Are their

third party software that can do this?

Thanks in advance

*

#2 (**permalink**) 28-Jul-2006, 08:35 AM

hank755_ca@yahoo.ca wrote:
> Hello,
>
> 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"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13203
> command but the formatting is totally lost.
>
>
> Is there a way I can save as much of the formatting as I can? Are
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13203
> their
>
> 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 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

#3 (**permalink**) 28-Jul-2006, 08:35 AM

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 things
Reference:: 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
developing.
--
Craig Hornish
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
issue"

"Joseph Meehan" wrote in message
news:Jhxtg.25659$vl5.2499@tornado.ohiordc.rr.com.. .
> hank755_ca@yahoo.ca wrote:
>> Hello,
>>
>> 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
>> their
>>
>> 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
>

#4 (**permalink**) 28-Jul-2006, 08:35 AM

Craig Hornish wrote:
> See my quote

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13203
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13203
>
> 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 things
> 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
> developing.

Hi Craig. I would be interested to learn more about what you are doing
with Access-->Excel automation.

Kind Regards,
--
Smartin