Combine Excel Files VBA Code - Need to Set destination workbook as active workbook.

**seenai** · 06-28-2020, 05:02 AM

Hi,

I have the below code. It combines multiples files into ONE NEW file.

Request your help to modify the code.
Requirement : The sheets to be added in ACTIVE workbook, instead of new book.

HTML Code:

**Andy Pope** · 06-28-2020, 06:45 AM

If by Activeworkbook you mean the workbook with the code in it you can use Thisworkbook object

**seenai** · 06-28-2020, 08:33 AM

Originally Posted by Andy Pope

If by Activeworkbook you mean the workbook with the code in it you can use Thisworkbook object

Hi,

Thanks for your guidance.

Final Code

HTML Code:

**Mumps1** · 06-28-2020, 09:05 AM

Try:

Please Login or Register  to view this content.

Combine Excel Files VBA Code - Need to Set destination workbook as active workbook.

LinkBack

Thread Tools

Rate This Thread

Display

Combine Excel Files VBA Code - Need to Set destination workbook as active workbook.

Re: Combine Excel Files VBA Code - Need to Set destination workbook as active workbook.

Re: Combine Excel Files VBA Code - Need to Set destination workbook as active workbook.

Re: Combine Excel Files VBA Code - Need to Set destination workbook as active workbook.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] vba code to copy a specific sheet from a closed workbook to the active workbook

[SOLVED] VBA - Excel code to copy and paste from several Sharepoint workbook files to one workbook

How to combine a pool of excel files into one workbook?

[SOLVED] Code to detect previous active workbook instead of current active workbook

Macro to combine many excel files into one workbook/worksheet

[SOLVED] Edit code to close all workbooks except active workbook and other specific workbook

[SOLVED] Combine CSV files into 1 Excel Workbook as sheets

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions