Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Merging Excel files

Status
Not open for further replies.
DKL01

DKL01

Programmer
Sep 14, 2000
233
US
Hi,

Is there any way we can merge (programatically ) excel sheets from several excel files into a single excel file ?

Thanks
 
Sort by date Sort by votes
Hi,

Here it is...
Code: 
    Dim objThis As Workbook
    Set objThis = ActiveWorkbook
    For Each Workbook In Workbooks
        If Workbook.Name <> objThis.Name Then
            Workbook.Worksheets.Copy _
                Before:=objThis.Sheets(1)
            
        End If
    Next
hope this helps.. :) Skip,
metzgsk@voughtaircraft.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
588
remeng
remeng
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
347
huiettcm
huiettcm
remeng
  • Locked
  • Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
2K
dhookom
dhookom
feipezi
  • Locked
  • Question
How to find a string from multiple Word files, which are listed on an Excel spreadsheet? 3
Replies
17
Views
387
Andrzejek
Andrzejek
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
305
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top