Results 1 to 8 of 8
  1. #1
    drjabear
    Guest

    Appending A Worksheet to A Workbook

    Hi,
    I am attempting to export a table from access and append it to an existing workbook within Excel. I have no problem exporting to excel, but my problem comes when I try to append it to the existing workbook. It overwrites all sheets within the workbook instead of appending to it? What function or command can I use to append a worksheet to an existing workbook? Thanks for the help.

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Appending A Worksheet to A Workbook

    If you can copy the date to the clipboard, you can then paste it where you want it to go... does this help?
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  3. #3
    drjabear
    Guest

    Re: Appending A Worksheet to A Workbook

    I need to caveat my original statement. Why I am trying to do what was stated in a macro, therefore I need the macro to recognize it is appending to a workbook and not overwrite the remaining contents of the workbook. Let me know if this makes sense.

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Appending A Worksheet to A Workbook

    perhaps you can record a macro which exports the data, copy's to the clipboard, and pastes to the workbook?
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  5. #5
    New Lounger
    Join Date
    Dec 2000
    Location
    Indiana
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Appending A Worksheet to A Workbook

    Please clarify:

    Are you trying to add an access table as a new worksheet to an existing excel file?

    Or do you want to append an existing worksheet of an excel file with the data in an access table?

  6. #6
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Appending A Worksheet to A Workbook

    If you use the transferspreadsheet method to export your table all you have to do is change the name of your access table and export to your excel file. If the file you are exporting to does not exist a new workbook will be created, if it does exist a new sheet in the workbook will be created and named after your access table.

  7. #7
    drjabear
    Guest

    Re: Appending A Worksheet to A Workbook

    I will try that and see how it works.

    thanks

  8. #8
    drjabear
    Guest

    Re: Appending A Worksheet to A Workbook

    I am trying to add an Access table to an existing excel workbook without overwriting any of the worksheets within the workbook.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •