Error 1004 Cannot Run The Macro
Contents |
Solution If you receive the message, "Cannot run the macro "!Convert_XXXX_to_QB'. The macro may not
Excel Runtime Error 1004 Cannot Run The Macro
be available in this workbook or all macros may be cannot run the macro may not be available in this workbook disabled," it is due to the security settings on your computer. Solution: The StatementConverter.xla
Run Time Error 1004
add-in needs to be in an Excel "trusted location." You can either: (a) tell Excel that StatementConverter's current location is trustedHow to: In Excel, FILE > OPTIONS > TRUST CENTER > TRUSTED LOCATIONS > ADD > browse to the folder where StatementConverter.xla is.(b) move the program to an existing trusted locationHow to: In Excel, FILE > OPTIONS > TRUST CENTER > TRUSTED LOCATIONS. Several locations will be listed. Choose one that you wish to use and then move (copy and paste) the StatementConverter.xla file to that location. Then, re-install the add-in in Excel by following the simple directions here: How to ReinstallIf the .xla file is not where you expect it to be, Excel may have relocated it without telling you (for example, to a Microsoft folder located in Documents and Settings). Search your hard drive for it and then add its folder as a trusted location. After doing the above, you may also need to re-activate the Add-in. It's easy to do:Re-activate the Add-in. Now run the converter and it should be fine. Was this article helpful? yes / no Article details Article ID: 10 Category: Using the Converter Rating (Votes): (25) « Go back Powered by Help Desk Software HESK - brought to you by Help Desk Software SysAid
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only http://www.statementconverter.com/support/knowledgebase.php?article=10 takes a minute: Sign up Getting “1004 Cannot run the macro…” on analysis toolpak suddenly up vote 0 down vote favorite As of yesterday, I had a working macro that generated histograms using analysis toolpak (VBA). As you can see below, the analysis toolpak VBA add in is enabled, and I have set a reference in VBA. The file is http://stackoverflow.com/questions/31945128/getting-1004-cannot-run-the-macro-on-analysis-toolpak-suddenly saved as .xlsm (macro enabled) and I can produce histograms without a macro: But if I record a macro to make a histogram, I get this same error. This is happening for all functions within the analysis toolpak. What happened here? vba excel-vba share|improve this question edited Sep 6 '15 at 2:51 Yvette 12.5k93675 asked Aug 11 '15 at 14:52 KFichter 658213 What happens when click on Debug? –Siddharth Rout Aug 11 '15 at 14:54 Stepping through just stops at the first atpvbean function and throws that error. –KFichter Aug 11 '15 at 14:57 The most confusing part of this is that it was working yesterday. The only change I made was saving the file as a new filename, at which point I began working on the new file (and haven't touched this one). –KFichter Aug 11 '15 at 14:58 Have you verified that macros didn't get disabled? File -> options -> trust center -> trust center settings -> macro settings. –MatthewD Aug 11 '15 at 15:01 Does any o
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 08 Oct 2016 17:55:07 GMT by s_ac5 (squid/3.5.20)
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Excel VBA Run Time error 1004 cannot run macro may be unavailable Want to Advertise Here? Solved Excel VBA Run Time error 1004 cannot run macro may be unavailable Posted on 2011-08-14 MS Excel 1 Verified Solution 13 Comments 1,264 Views Last Modified: 2012-05-11 I am building an updating app which opens up numerous excel file to run a Public Sub. I have a list of files that the program needs to open. It opens up the first file and the macro runs. When it gets to the second file to open, I get the above error. If I ignore the first file and start with the second file, I get the same error. The macros are enabled, vba is trusted. The second file is in the same directory as the first. similar to the first and I can't spot the difference betwen the the file where the macro executes and the second file where the macro is unavailable. I tried a different "second" file and still get the same error Set wbTarget = Workbooks.Open(AFStr) ' open first workbook in list With wbTarget .Activate Set UPdateFlag = Range("updated") 'the update sub changes the value of this field in the active workbook to yes when finsished Application.Run ActiveWorkbook.Name & "!" & AM 'runs the macro in the list Select all Open in new window 0 Question by:BROOKLYN1950 Facebook Twitter LinkedIn Google LVL 85 Best Solution byRory Archibald I don't see how you can get an error if it runs. Does the workbook name have any spaces in it? If so, you need the syntax I posted. Go to Solution 13 Comments LVL 23 Overall: Level 23 MS Excel 16 Message Active 3 days ago Expert Comment by:Michael742011-08-14 Just a guess It is possible that because you have made the new workbook the active workbook that the macro is not avail