|
|
 |
| VB How-To Ask your "How do I do this with VB?" questions in this forum. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the VB How-To section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
 |
October 23rd, 2007, 07:08 AM
|
|
Registered User
|
|
Join Date: Oct 2007
Location: Hyderabad, Andhra Pradesh, India.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Working with excel sheets
Hi All,
I'm having three excel files, book1.xls, book2.xls, book3.xls and each having data in sheet1. I want to copy these three sheets to book4.xls as into sheet1, sheet2, sheet3. Please help me. How to code in VB6.
thanks in advance.
regards
ramsri
ramsri
__________________
ramsri
|
October 25th, 2007, 04:15 PM
|
|
Friend of Wrox
|
|
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 1 Time in 1 Post
|
|
I would open B4, and 1 at a time open B1 — B3.
Create a WorkSheet object, and set it, in turn, to S1 of B1 — B3.
Then use B4’s WorkSheets.Add method to add the current Sheet being held in the WorkSheet object.
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
