Referring to CodeModule Sheet Name

  • Thread starter Thread starter tcb
  • Start date Start date
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)?
 
With XLDestWB.VBProject.VBComponents(worksheets("tabone").codename).CodeModule

is one way.
 
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
 
Back
Top