HI guys,
I have written some codes in word(2003) VBA which accesses a excel(2003) worksheet by referring the Worksheet tab names. The problem arises when the users rename the Worksheet tabs. I want the code to funtion independent of the name of the worksheet tabs. I know that can be done by using code names of the worksheets.But i dont know how to do it from word(2003) VBA.
the sample codes are as shown below :
Can anyone help?Please Login or Register to view this content.
Thanks in advance..
Sam
Bookmarks