Embedded Excel File

vbakid

New Member
Joined
Sep 19, 2010
Messages
5
Hello,

I need some help with embedded excel files within my excel spreadsheet. I have one worksheet within my (master) workbook in which there are multiple (upto 20 Max, min 3) embedded excel files. What I want to do is open each embedded file from that sheet and copy the sheets from the embedded file where cell A1 = Yes into my master workbook.

I.e. Master workbook contains sheets:
Instructions
SheetWithEmbeddedFiles - Which contains the embedded xlsm files

Each embedded xlsm file is of the same format, just the contents will vary. If A1 = yes, then copy that sheet into my master so the master now contains:

Instructions
SheetWithEmbeddedFiles - Which contains the embedded xlsm files
SheetFromEmbedded1
SheetFromEmbedded2 etc etc

I was able to open one of the workbooks through this
Code:
Worksheets("SheetWithEmbeddedFiles").Shapes(1).OLEFormat.Activate
but then I'm at a loss on how to copy the sheets from it and move on to the next embedded file.

Can someone please help? This is the last thing I need to do for my program and it seems to be the biggest hurdle :mad:

All help would be much appreciated, thank you
 

Forum statistics

Threads
1,082,569
Messages
5,366,360
Members
400,886
Latest member
Fchel

Some videos you may like

This Week's Hot Topics

Top