无法解决，这个提示表示用的宏已经遭到破坏或已经不存在了。宏安全性设置成启用所有宏就可以了~你用的什么版本的excel?设置的地方不太一样~
I have an Excel file that contains macros—they all run perfectly - when I record a NEW macro it does not run when invoked - I get a loud tone , but no error message—please help preston99 Put the macro in a module and let it run through that. If the macro has an error, then ...
line287,in_ApplyTypes_result=self._oleobj_.InvokeTypes(*(dispid,LCID,wFlags,retType,argTypes)+args)com_error: (-2147352567,'Exception occurred.', (0,'Microsoft Excel',"Cannot run the macro ''test_macro.xlsm'!TestMacro'. The macro may not be available in this workbook...
I have an encrypted Excel file with macros. It's run fine on several computers over time. Tonight I just installed Office 2007 on a new Microsoft...
The macro in the file loads up imported data and saves a backup file in a different location. It runs with no problems when I run it manually in Excel. But when it runs as a task in the Windows 10 scheduler it gives me a runtime error 1004....
Execute the macro(s). macro_name = 'load_data_zsddxl'. CALL METHOD OF excel 'Run' = ole_run EXPORTING #1 = macro_name. FREE OBJECT ole_run. The automation trace gives me this message (sorry about the formatting): <26=Automation: CALL METHOD "Run" OF [#12/0x109B0C4C/101/E...
In Excel, you run a macro manually or automatically. A macro is an action or a set of actions that you can use to automate tasks. This topic shows you several ways to run macros manually or automatically.
Cannot run the macro <macro name >. The macro may not be available in this workbook or all macros may be disabled. Resolution Important This section, method, or task contains steps that tell you how to modify the regist...
For example, if you enter Shift+F, then pressing Ctrl+Shift+F will cause your macro to run. When assigning a shortcut key, make sure you don’t choose one that’s already used to perform a task. For example, since Ctrl+B applies bold font, you cannot assign that shortcut key to ...
The Run Macro in Excel command runs a macro in this application, making the sum of the values "1 + 2" and saving the result of the sum in cell A1. defVar --name example --type Excel defVar --name ID --type Numeric defVar --name officeApplication --type OfficeApplication /...