Hi guys!
Can you tell me the index of the VBProj.VBComponents("ThisWorkbook") component?
I need to refer to that component but not by its name because the file I use, goes to some users that have MS Excel installed with another language and their Excel translate the component's name in that language so VBProj.VBComponents("ThisWorkbook") should be VBProj.VBComponents("[that-language-translation]")
Thank you!
.. and don't forget to have fun!
Bogdan.
mark SOLVED andAdd Reputation if my answer pleases you
Nevermind guys, i've found out by myself. The indexnumber of ThisWorkbook is always 1, the indexnumber of the first worksheet is 2.
this is how i found out:
Please Login or Register to view this content.
Last edited by bulina2k; 02-12-2014 at 06:59 AM. Reason: add code
I think that ThisWorkbook may always be used as Object in code and so ThisWorkbook.Codename will return the name in current language?
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
i'm not sure but that worth a try...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks