| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
launch macro in other workbook
hi all !!
i have this but it gives error for each "wb"... For Each wb In Workbooks If (left(wb.name,1) )= "_" Then Call mymacro End if Next wb ....it is inside a sub that starts like this... Dim aWB As Workbook Dim aWS As Worksheet Set aWB = ThisWorkbook Set aWS = aWB.Worksheets("Sheet1") can anybody help pls !! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
launch macro in other workbook
Hi
You have to use the parent object as reference: For Each wb In Application.Workbooks Regards, Per On 8 Maj, 13:08, pls123 wrote: hi all !! *i have this but it gives error for each "wb"... For Each wb In Workbooks If (left(wb.name,1) )= "_" Then * *Call mymacro *End if *Next wb ...it is inside a sub that starts like this... Dim aWB As Workbook Dim aWS As Worksheet Set aWB = ThisWorkbook Set aWS = aWB.Worksheets("Sheet1") can *anybody help pls !! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
launch macro in other workbook
For Each wb In Workbooks If (left(wb.name,1) )= "_" Then application.run wb.name &"!" & mymacro Next wb |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
launch macro in other workbook
thx all !! i will test in the weekend !!
"Przemek" wrote: For Each wb In Workbooks If (left(wb.name,1) )= "_" Then application.run wb.name &"!" & mymacro Next wb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDF won't launch macro | Excel Programming | |||
| How to launch an Excel Workbook quickier, by ... | Excel Programming | |||
| VBA - Launch VBA Macro From VB | Excel Programming | |||
| Macro launch - Button vs Manual launch , has different results. | Excel Programming | |||
| Launch Macro in Access via Macro running in Excel??? | Excel Programming | |||
Linear Mode
