Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-17-2020, 11:31 AM
coffent coffent is offline How to call a function in VBAProject(PERSONAL.XLSB) Windows 10 How to call a function in VBAProject(PERSONAL.XLSB) Office 2019
Advanced Beginner
How to call a function in VBAProject(PERSONAL.XLSB)
 
Join Date: Dec 2019
Posts: 40
coffent is on a distinguished road
Default How to call a function in VBAProject(PERSONAL.XLSB)

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 X


X = Application.Run("PERSONAL.XLSB!fTest2(4)")
I 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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to call a function in VBAProject(PERSONAL.XLSB) Function not available from personal.xlsb slouw Excel Programming 1 04-04-2016 12:32 AM
How to call a function in VBAProject(PERSONAL.XLSB) 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft