Posted to microsoft.public.excel.programming

external usenet poster

Posts: 27

VBProj.VBComponents

Using http://www.cpearson.com/excel/vbe.aspx
The line Set VBComp = VBProj.VBComponents(module)
expects a module name such as "sheet1" or "sheet2", which is nice if you
know which sheet it is. Can we reference the VBComponents by the sheet name
instead? Such as for sheet2(MySheet) I want to use MySheet, since it is not
always sheet2.
Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Security and working with VBComponents	Keithlo	Excel Programming	2	October 10th 06 10:13 PM
VBComponents question	Frederick Chow	Excel Programming	2	March 20th 06 07:18 PM
Links between VBComponents and Sheets 3	Paul	Excel Programming	1	August 5th 04 04:38 PM
Links between VBComponents and Sheets 2	Paul	Excel Programming	1	August 5th 04 04:59 AM
Links between VBcomponents and Sheets	Bernie Deitrick	Excel Programming	1	August 4th 04 07:19 PM

All times are GMT +1. The time now is 07:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us