Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Function in Add-in
In a VBA Sub, I issue this command:
Dim IsItOpen As Variant IsItOpen = Application.Run("personal.xla!IsOpenWB", "chart of accounts.xlsx") And the function in personal.xla is: Public Function isopenwb(ByVal WBname As String) As Boolean 'returns true if workbook is open Dim objWorkbook As Object On Error Resume Next isopenwb = False Set objWorkbook = Workbooks(WBname) If Err = 0 Then isopenwb = True End Function But I get an error, "The Macro 'personal.xla!IsOpenWB' cannot be found. Ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling a function in my SQL-DB from VBA | Excel Discussion (Misc queries) | |||
Calling a function | Excel Programming | |||
Calling VBA Function | Excel Programming | |||
Calling Function | Excel Programming | |||
calling a function | Excel Programming |