Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-08-2022, 12:09 PM
VBAadvocate VBAadvocate is offline Application.Run with args fails Windows 10 Application.Run with args fails Office 2019
Novice
Application.Run with args fails
 
Join Date: Feb 2022
Posts: 12
VBAadvocate is on a distinguished road
Default Application.Run with args fails

After adding a template file to the Addins collection and installing the addin I can successfully run subs in the template that do not require any arguments.

However, if the sub requires an argument, it fails with the following error:
"Run-time error '438': Object doesn't support this property or method"

I am using the following line of code:

Application.Run strAddinFilename & "!SubName", strText

Where:
strAddinFileName - filename of the template with extension (not a full path)
SubName - name of a Sub
strText - name variable being passed as an argument to Sub.

I've modified the template sub using byVal and byRef for its arguments and various hacks using parens, the Call keyword and other junky ideas without any success.

According to the "About Word" on the Account page in Microsoft Word, I have:


Version 2112 (Build 14729.20322 Click-to-Run)

Hoping there's help, VBAadvocate
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Typing to cell fails DickVeitch Excel 6 11-20-2017 10:34 AM
SaveAs or Export to PDF fails Optiker Publisher 0 11-12-2017 12:17 PM
Application.Run with args fails MS Forms 2.0 library for 32 bit fails on x64 serge1p Excel Programming 1 09-21-2017 02:28 AM
Application.Run with args fails MS OneNote update repeated fails jlumbtx Office 1 01-07-2015 10:00 AM
Application.Run with args fails Office 2003 SP3 installation fails Mystified1 Office 4 02-07-2011 01:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:58 PM.


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