Works on some systems with Excel 2003 and not on others
 

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.VBComp onents(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

Works on some systems with Excel 2003 and not on others
 

Is Microsoft Visual Basic For Applications Extensibility 5.3 an active
reference on all your machines?
--
Gary''s Student - gsnu200825


"Barb Reinhardt" wrote:

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.VBComp onents(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

Works on some systems with Excel 2003 and not on others
 

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

"Gary''s Student" wrote:

Is Microsoft Visual Basic For Applications Extensibility 5.3 an active
reference on all your machines?
--
Gary''s Student - gsnu200825


"Barb Reinhardt" wrote:

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.VBComp onents(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

Works on some systems with Excel 2003 and not on others
 

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" wrote:

Is Microsoft Visual Basic For Applications Extensibility 5.3 an active
reference on all your machines?
--
Gary''s Student - gsnu200825


"Barb Reinhardt" wrote:

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.VBComp onents(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

Works on some systems with Excel 2003 and not on others
 

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 - gsnu200825


"Barb Reinhardt" wrote:

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" wrote:

Is Microsoft Visual Basic For Applications Extensibility 5.3 an active
reference on all your machines?
--
Gary''s Student - gsnu200825


"Barb Reinhardt" wrote:

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.VBComp onents(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

Works on some systems with Excel 2003 and not on others
 

I found something that may help:

http://groups.google.com/group/micro...6?q=gsnu2007xx
--
Gary''s Student - gsnu200825


"Barb Reinhardt" wrote:

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" wrote:

Is Microsoft Visual Basic For Applications Extensibility 5.3 an active
reference on all your machines?
--
Gary''s Student - gsnu200825


"Barb Reinhardt" wrote:

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.VBComp onents(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