Solved: Files names in to the sheets.

[Pinokkio]

http://vbaexpress.com/kb/getarticle.php?kb_id=221
I have this macro but is this posible to at a macro that gif all the names from the files in to de tabsheets?


C: \ Invoices\ANTONIO's-2009-28-09-192110.xls
C: \ Invoices\ANDALUUS BV-2009-27-09-215241.xls...

thanks

[parttime_guy]

I have used various codes available on vbaexpress.com to come up with a customised tool.

The attached file combines all the files in the folder into a single file as different sheets then does some formatting changes to all the sheets available in the Master file.

Your problem is getting the sheets in the Master file to be renamed as the original file name. I have tried sorting this problem by keeping a common unique cell in all the files to be replaced as the sheet name in the Master file.

In this case the unique cell in all the files is A2.

Try this code…. Hope you find it usefull.
Best regards

[Pinokkio]

This is exactly what I want.

Thanks

Jean Pierre

[parttime_guy]

Glad to be of help