dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Copy multiple worksheets to another Excel Workbook

  1. #1
    Robert Guest

    Copy multiple worksheets to another Excel Workbook


    Good day

    I would like to know how would one go about writing a VBA sub that will copy
    multiple workseets from one workbook to another.

    Thanks
    Robert



  2. #2
    Howard Kaikow Guest

    Re: Copy multiple worksheets to another Excel Workbook

    Be careful in copying worksheets to another workbook.
    If the original workbook has code in the ThisWorkbook object, you may need
    to bring that code along somehow.

    --
    http://www.standards.com/; Programming and support for Word macros,
    including converting from WordBasic to VBA; Technical reviewing; Standards;
    Product functional/design/specifications
    ------------------------------------------------
    "Robert" <robert@weathersa.co.za> wrote in message
    news:3e1ad005$1@tnews.web.devx.com...
    >
    > Good day
    >
    > I would like to know how would one go about writing a VBA sub that will

    copy
    > multiple workseets from one workbook to another.
    >
    > Thanks
    > Robert
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center