Thread: pointer to sub
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
UKNewbie UKNewbie is offline
external usenet poster
 
Posts: 11
Default 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)