Printing Excel files embedded in Excel

[richand1]

Hi all, I have searched and searched for a solution to this but I can't seem to find one anywhere.

I want to be able to embed any number of Excel files into an Excel worksheet and have the code run through each object, open it, print it and then close the object again. Sounds simples, but I have no idea how to do this.

Has anyone here got some code to at least start me off please?

Thanks all

 

[SkipVought]

Hi,

Just LIST the workbooks.

Use a loop to Open & Print & Close each one.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[richand1]

Thanks Skip.

I'll have a go and let you know how I get on.

Rich