Works on some systems with Excel 2003 and not on others

[Barb Reinhardt]

I have this line of code to find worksheets and it works on some systems and
not on others.

Set FindWorksheet =
myXLBook.Worksheets(CStr(myXLBook.VBProject.VBComponents(myWSCodename).Properties("Name")))

I know that it won't work if the project is password protected, but in this
case, it's not.

Thanks,
Barb Reinhardt

 

[Gary''s Student]

Is Microsoft Visual Basic For Applications Extensibility 5.3 an active
reference on all your machines?

 

[Barb Reinhardt]

On the machine with the issue, that reference is available, yes. Any other
ideas?
Thanks,
Barb Reinhardt

 

[Barb Reinhardt]

Let me clarify my previous response.

It works on my machine without the reference selected within the VBE.
On the machine with an issue, it doesn't work, unless the reference is
selected within the VBE.

What next? I don't really want to have to give everyone specific
instructions on how to select the reference and sending another version with
the reference selected will be a PITA.

Thanks,
Barb Reinhardt

 

[Gary''s Student]

I had a similar problem with Solver and VBA. People ignored my instructions
to add Solver as a VBA reference.

Someone told me how to set the reference programmatically, but I can't find
the post.

 

[Gary''s Student]

I found something that may help:

http://groups.google.com/group/micr...e_thread/thread/a38d859c231fb626?q=gsnu2007xx