I am trying to switch between two workbooks with vba
Can I use a wildcard to activate the other workbook?
The following does not work
![]()
Please Login or Register to view this content.
I am trying to switch between two workbooks with vba
Can I use a wildcard to activate the other workbook?
The following does not work
![]()
Please Login or Register to view this content.
You can't use a wildcard like that, you need to specify the full name.
If you need to find a workbook based on a partial string you would probably need some sort of loop.
What is it you are trying to do anyway?
Last edited by Norie; 01-24-2013 at 04:58 PM.
If posting code please use code tags, see here.
Hello petreli,
You can do it like this...
![]()
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks