Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
callbyname in XL 2K and XL 2003
Hey there,
I have a sub called "test" in the ThisWorkbook module of an addin. In the Immediate window I enter: CallByName workbooks("fb tester.xla"), "test", VbMethod In XL 2003 the macro runs, but in XL 2k it does not. Can anybody tell me how to make this work in XL 2000? Thanks, Doug Glancy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
callbyname in XL 2K and XL 2003
The answer is that things work better when you compile - something I thought
I'd already learned! Thanks anyways, Doug "Doug Glancy" wrote in message ... Hey there, I have a sub called "test" in the ThisWorkbook module of an addin. In the Immediate window I enter: CallByName workbooks("fb tester.xla"), "test", VbMethod In XL 2003 the macro runs, but in XL 2k it does not. Can anybody tell me how to make this work in XL 2000? Thanks, Doug Glancy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing/linking data from an Access 2003 Query to an Excel 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Example for VBA function - CallByname! | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Using CallByName for conversion function | Excel Programming |