pointer to sub
Morning all (GMT),
Just wondering if it is possible to create a flexible pointer to call other
subs within a loop. Example code below: -
For i = 3 To counter - 1
Workbooks.Open wsTD.Cells(i, 2), _
updatelinks:=False, writerespassword:=wsTD.Cells(i, 3)
Set wb2 = ActiveWorkbook
SubWB = Replace(Left(wb2.Name, Len(wb2.Name) - 4), " ", "_", 1)
Call SubWB
wb2.Close savechanges:=True
Next i
Can use pointers within C++ but can't figure out a similar method within VBA.
Any help, as always, much appreciated.
Thanks in advance,
Mike
(Win2k sp4, Office2k sp3)
|