LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Macro works in 2000 but not in 2003 - HELP! [email protected] Excel Programming 1 March 14th 08 01:15 PM
chart works in excel 2007, not 2003 [email protected] Excel Programming 2 August 27th 07 05:13 PM
Converter from MS Works 4.5 spreadsheet to MS Excel 2003 John Excel Discussion (Misc queries) 0 January 14th 06 12:10 AM
Works 4.0(wks) needs to be converted to Excel 2003 BJB Excel Discussion (Misc queries) 2 July 15th 05 03:49 PM
VS.NET 2003 .DLL used in Excel - works on my machine, no one else's Yacobs Excel Programming 3 November 17th 04 03:43 PM


All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"