Hi,
Can anyone help me on how to change it to wildcard text in order to activate workbook.
the code below not working
Please Login or Register to view this content.
Hi,
Can anyone help me on how to change it to wildcard text in order to activate workbook.
the code below not working
Please Login or Register to view this content.
Last edited by Faridwahidi; 11-03-2014 at 12:45 AM.
Assign Full Name of workbook
remove * from name and then try.
Please Login or Register to view this content.
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Hello Faridwahidi,
You can find the first workbook in the current directory by using the Dir method.
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 Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi, Farid,
if the workbook is open loop through the workbooks of the instance and use InStr or Like to compare the part of the name and assign a variable to the workbook, if you open the workbook set a variable to it by opening. I doubt that you should be able to activate a certain sheet in a different workbook in a one-liner code.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi Holger,
Thanks for a very good advise. I have resolved it.
@ Leith,Please Login or Register to view this content.
Thanks a lot
Last edited by Faridwahidi; 11-03-2014 at 02:40 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks