Microsoft Office Forums

Microsoft Office Forums (https://www.msofficeforums.com/)
-   Excel Programming (https://www.msofficeforums.com/excel-programming/)
-   -   424 Error within a simple application.run procedure (https://www.msofficeforums.com/excel-programming/24419-424-error-within-simple-application-run-procedure.html)

grexcelman 01-21-2015 08:33 AM

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

grexcelman 01-21-2015 08:36 AM

Looks like my quotations fell off my code within the parenthesis.


All times are GMT -7. The time now is 04:02 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft