2016년 9월 7일 수요일

Solution to Problem: Can I Run an Add-in with a macro?

Can I Run an Add-in with a macro?

I have a custom Add-in that uploads files to a database.
I do not have access to edit the add-in but it needs to be a part of the automated process.
Is there a way to run it with a macro?

Anwsers to the Problem Can I Run an Add-in with a macro?

Download Error Fixer (Free)

Hi,
 
When you use the References dialog box to directly reference another workbook, add-in, or object library file, you can run a macro contained in the referenced file using the Call statement and the macro name, or only the macro name. 

Open the add-in file (either before you run the macro, or as a command in the macro), and then use the Run method of the Application object to run the macro as in the following example:

Application.Run("ADDIN.XLA!Macro_Name")

http://support.microsoft.com/kb/115208
 
 
By default, Office sets macro security to High.
This setting prevents Visual Basic for Applications (VBA) sub procedures and add-ins that have not been digitally signed from running.
To work around this issue, you can refer to this KB article
http://support.microsoft.com/kb/285514
 
 
Best regards
William Zhou
--------------------------------------------------------------------------------
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Make Sure that your Computer Meets the System Requirements

This error can be due to some configuration requirements for you system. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing:

Microsoft Windows Requirements :

  • 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
  • 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

Another Safe way to Repair the Problem: Can I Run an Add-in with a macro?:

How to Fix Can I Run an Add-in with a macro? with SmartPCFixer?

1. Download Error Fixer. Install it on your computer.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed


Related: Where to Download Toshiba Satellite A205-S5819 Intel Wi-Fi PROSET Utility v.11.1.0.0.5 driver,How to Update & Download Toshiba Satellite C660D Realtek Card Reader Driver v.6.1.7600.30123,Best Way to Download Toshiba Satellite L655-S5112WH Media Controller v.1.0.87.5 driver,[Solved] Download Toshiba Satellite L845D-SP4213KL BookPlace v.3.0.9490 driver,Method to Update & Download Toshiba Satellite R845-ST6N02 Atheros Wireless Lan Driver v.8.15.10.2255,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver,Can I create a homegroup network between Windows XP and Windows 7?,Calling data from specific row on another worksheet,Can I connect to wifi using an old version of XP pro?,can a vlookup fetch data from a seperate excel spreadsheet?,Can I add my Window7 laptop top to printer on XP network

댓글 없음:

댓글 쓰기