![]() |
|
#1
|
|||
|
|||
|
I have a simple test function fTest2 in VBAProject(PERSONAL.XLSB). I can run it from a spreadsheet by inserting "=PERSONAL.XLSB!fTest2(4)" into a cell. However if I try to do the same thing in VBA using
Dim XI find X = "Error 2015". What am I doing wrong? Solved the problem: It should be: X = Application.Run("PERSONAL.XLSB!fTest2", 4) Last edited by coffent; 05-17-2020 at 07:08 PM. Reason: Solved the problem |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Function not available from personal.xlsb
|
slouw | Excel Programming | 1 | 04-04-2016 12:32 AM |
Error message opening xlsb file in Excel 2008 for Mac
|
Bryce | Excel | 1 | 07-27-2014 09:35 AM |
| Visibility of macros in PERSONAL.XLSB | Dougiel | Excel | 0 | 05-24-2012 12:32 AM |
| How to call an object of opened appointment? | NIBARIM | Outlook | 0 | 05-23-2012 07:06 AM |
| Call Excel from Word | donlincolnmsof | Word | 0 | 10-14-2011 05:02 PM |