Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pointer and Cell | Excel Discussion (Misc queries) | |||
Pointer please | New Users to Excel | |||
pointer | Excel Discussion (Misc queries) | |||
Another pointer please | Excel Discussion (Misc queries) | |||
Pointer please | Excel Discussion (Misc queries) |