View Single Post
 
Old 01-21-2015, 08:33 AM
grexcelman grexcelman is offline Windows 7 32bit Office 2003
Novice
 
Join Date: Dec 2014
Posts: 21
grexcelman is on a distinguished road
Question 424 Error within a simple application.run procedure

I'm simply just trying to run a macro which applies a list of macros from another workbook. Thought this code worked already when I applied it a couple weeks ago but something changed I think.
I clicked a button which runs the CALLMacros macro from the local workbook.

Here's my code:
Sub CALLMacros()
Application.Run (MacroBooks.xlsm!DIRECTCOMPTRD)
Application.Run (MacroBooks.xlsm!DIRECTNONCOMPTRD)
Application.Run (MacroBooks.xlsm!NONCOMP2)
Application.Run (MacroBooks.xlsm!NONCOMPTRD)
Application.Run (MacroBooks.xlsm!TOTALDIRECTEXPTRD)
End Sub
Reply With Quote