Hi there,
I have a template workbook into which I need to import sheets from different excel files.
All files are in the same folder/location as the template.
The macro below works fine if the full name of the sheet is known.
The problem I have is, the sheet name sometimes is not exactly 'Start', but it could be 'Start SEP 22', 'Start October 2022', etc.
The sheet name always starts with 'Start'.
Ideally it would be as simple as looking for 'Start*', but I was not able to make wildcards work when looking for sheet names.
Was also thinking about Left(sh.name,"Start",5) or something like that, but can't get it working.
Any help, pointers for the code with copying any sheet starting with 'Start' would be much appreciated.
Thanks
Please Login or Register to view this content.
Bookmarks