| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro works in 2000 but not in 2003 - HELP! | Excel Programming | |||
| chart works in excel 2007, not 2003 | Excel Programming | |||
| Converter from MS Works 4.5 spreadsheet to MS Excel 2003 | Excel Discussion (Misc queries) | |||
| Works 4.0(wks) needs to be converted to Excel 2003 | Excel Discussion (Misc queries) | |||
| VS.NET 2003 .DLL used in Excel - works on my machine, no one else's | Excel Programming | |||
Linear Mode
