Home

Run-time error 1004

%3CLINGO-SUB%20id%3D%22lingo-sub-693184%22%20slang%3D%22en-US%22%3ERun-time%20error%201004%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-693184%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20few%20macros%20running%20on%20our%20Excel%20system%20in%20our%20company%20which%20are%20very%20critical%20for%20us.%20Unfortunately%2C%20today%20all%20the%20macros%20stopped%20working.%20I%20am%20getting%20an%20error%20called%201004.%20I%20have%20all%20my%20macros%20enables%20and%20everything%20is%20the%20same%20as%20what%20we%60ve%20been%20having%20for%20the%20past%20few%20months.%20I%20don%60t%20know%20why%20they%20stopped%20working%20today.%20The%20error%20says%3A%3C%2FP%3E%3CP%3ECannot%20run%20the%20macro%20XXX.%20The%20macro%20may%20not%20be%20available%20in%20this%20workbook%20or%20all%20macros%20may%20be%20disabled.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20macros%20are%20on%20main%20a%20file%20on%20the%20server%20and%20they%20are%20being%20called%20from%20a%20local%20file%20on%20each%20computer%20in%20our%20company.%20We%20have%20had%20this%20for%20so%20long%20and%20it%60s%20been%20working%20properly.%20Not%20sure%20what%20happened%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPrivate%20Sub%20Setup_Data_Click()%3CBR%20%2F%3EApplication.Run%20(%22'Y%3A%5CMain.xlsm'!Data_SetupMacro%22)%3CBR%20%2F%3EWorkbooks(Dir(%22Y%3A%5CMain.xlsm%22)).Close%20Savechanges%3A%3DFalse%3CBR%20%2F%3EEnd%20Sub%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-693184%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Farid1
Occasional Visitor

Hi, 

 

We have a few macros running on our Excel system in our company which are very critical for us. Unfortunately, today all the macros stopped working. I am getting an error called 1004. I have all my macros enables and everything is the same as what we`ve been having for the past few months. I don`t know why they stopped working today. The error says:

Cannot run the macro XXX. The macro may not be available in this workbook or all macros may be disabled. 

The macros are on main a file on the server and they are being called from a local file on each computer in our company. We have had this for so long and it`s been working properly. Not sure what happened?

 

Private Sub Setup_Data_Click()
Application.Run ("'Y:\Main.xlsm'!Data_SetupMacro")
Workbooks(Dir("Y:\Main.xlsm")).Close Savechanges:=False
End Sub

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies