vba identify if workbook is open then set it activeworkbook
Posted on 2012-09-02
I have a few workbooks open at the same time while importing data - but I need to find if a specific workbook is open and set it as the activeworkbook.
The only issue is the one workbook has a variable name (after the 21st character).
I need my code to find if workbook:
If Left(IMPORT_BOOK.Name, 21) = "Daily Sales Store No." is open - then set it as my activeworkbook while I massage some data in it. If it does not exist - then it exits sub.
I am stuck on checking each open workbook.name but trim the name and still set it as active.
(If needed for coding - there is always 4 more characters left and it is in .xls format)
Any assistance would be awesome.