What is the structure of the workbook you are opening? How many worksheets are there? If it's just one, you can use Sheets(1) without needing to refer to the sheet name or sheet code name. If there's more than one, you can loop through them checking the sheet name, or part of the sheet name. What does the sheet name look like? Is there any part uniquely identifiable?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Perfect! Thanks for the solution and the assistance TMS, works well.Originally Posted by TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
rjnc 
Register To Reply
Bookmarks