Copy filename of source workbook to specific cell in specific tab in destination workbook.

HI Guys,

Thanks to mikeTRON, I've got a macro to copy all the tabs in from another workbook which is achieved by navigating to that workbook (see below). However, I forgot to ask for a code that does the will take the filename of the source workbook (without the extension) and put it into cell C2 of the "Welcome" tab in the destination workbook.

Can anyone help please?

Thanks

Please Login or Register  to view this content.

Just the ticket!! Thank you