I'm trying to run a macro from my Personal.XLSB set of macros from another macro in there. I modified the code in macro 2 to execute the first macro, adding:
Application.Run ("'Personal.xlsb!Consecutive_Giving_Analysis'")
The first macro is named Consecutive_Giving_Analysis
I always get a 1004 error, saying "The Macro may not be available in this workbook or all macros may be disabled."
Any ideas here? What should I be doing to execute that macro from within another one?
Try
Is the Personal.xlsb file hidden? If so, it may not work.
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Tom: That gives me the same result:Originally Posted by gmr4evr1
Try
Is the Personal.xlsb file hidden? If so, it may not work.Please Login or Register to view this content.
2015-06-14_100007.jpg
The Personal.xlsb folder isn't hidden. I checked the attributes. Any other ideas? Thanks - Joel
Have you checked under options, trust center, macro settings to see if macros have been enabled there?
Yes:
2015-06-14_101836.jpg
Hmmmm.....Not sure where to go from here.
Does anyone else have any ideas?
Last edited by js0873; 06-22-2015 at 01:10 PM.
One thing I just found out is that I can invoke a different macro in my Personal.XLSB, just not this one. I have no idea what might make this one different, but it's not misspelled.
Just grasping at straws here, but, I noticed something in the screenshot in post #3. In the error message, at the end of the macro name if shows
Instead ofPlease Login or Register to view this content.
No double quote at the end of the name, it's a single. Not sure if this is an issue, but, cant hurt to check it out.Please Login or Register to view this content.
I wish it were that simple. Here's the 2 exact statements, back to back:
Application.Run "PERSONAL.XLSB!Find_Duplicates.Find_Duplicates"
Application.Run "PERSONAL.XLSB!Consecutive_Giving_Analysis"
The first runs fine. The second gives the attached error.
2015-06-22_130113.jpg
Hmmm, well, I'm out of ideas again. Will get back to you if something else pops into my head.
What happens if you click Debug when the error comes up?
It simply highlights the line in error in the VBA code:
2015-06-22_134408.jpg
Grrrr, ok, out of ideas again.
Are you by chance clicking a button to run the macro? If so, check that it is still assigned. I am helping another member with an issue an noticed that I get the same error message when I click on one of the buttons they have. The problem with theirs is that the macro is no longer assigned to that button.
No, I'm actually in the VBA code and using F5 to test it out, so I know it's running the actual macro.
I figured it wouldn't be something that simple, but had to ask.
OK, I think I finally found the problem. My module name is Consecutive_Giving_Analysis. I generally name the module the same name as the subroutine name within that module.
To successfully run the subroutine named Consecutive_Giving_Analysis within the module Consecutive_Giving_Analysis, I needed to do this:
Application.Run "PERSONAL.XLSB!Consecutive_Giving_Analysis.Consecutive_Giving_Analysis"
I had been doing this:
Application.Run "PERSONAL.XLSB!Consecutive_Giving_Analysis"
Dang it! I was going to ask you about that yesterday because I noticed in your sample from post #10 that the other macro had the name in it twice.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks