Referring to CodeModule Sheet Name

T

tcb

When referring to:

With XLDestWB.VBProject.VBComponents("Sheet1").CodeModule

is it possible to refer to the code by Sheet1's tab name (e.g.
"TabOne") rather than "Sheet1"?

If not, how can I determine which Sheet number TabOne is (in VBA)?
 
D

Dave Peterson

With XLDestWB.VBProject.VBComponents(worksheets("tabone").codename).CodeModule

is one way.
 
D

Dave Peterson

And it would be better to qualify that worksheets reference, too:

With XLDestWB.VBProject.VBComponents(xldestwb.worksheets("tabone").codename) _
.CodeModule

or
with xldestwb
With .VBProject.VBComponents(.worksheets("tabone").codename).CodeModule
...
end with
end with
 
Top