Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Keep Formatting - Access to Excel

Discussion in 'Information Technology' started by hank755_ca@yahoo.ca, Jul 28, 2006.

  1. hank755_ca@yahoo.ca

    hank755_ca@yahoo.ca
    Expand Collapse
    Guest

    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
     
  2. Loading...

    Similar Threads Forum Date
    Ashdoc's Movie Review---The Zookeeper's Wife Theatre, Movies & Cinema Thursday at 5:50 PM
    Sikh News Sikh Seva Volunteers Keep The Food Service Drive For The Needy Going After Passing Away Of Breaking News Jul 29, 2016
    Sikh News Sikh Captain Says Keeping Beard And Turban Lets Him Serve U.S. And Faith Breaking News Apr 2, 2016
    World Sikh Gurdwaras in France keep doors open; Sikhs step up through #PorteOuverte Breaking News Nov 17, 2015
    Why Sikhs Keep KESH ? Blogs Oct 21, 2015

  3. OP
    Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    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 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. OP
    Craig Hornish

    Craig Hornish
    Expand Collapse
    Guest

    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
    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/pfx/forum.aspx?webtag=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" <sligojoe_Spamno@hotmail.com> 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
    > 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
    >
     
  5. OP
    Smartin

    Smartin
    Expand Collapse
    Guest

    Craig Hornish wrote:
    > 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
    > 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
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page