2010 Excel stops working when running macros
I have a macro that I have been running for years. It simply opens several work sheets that are password protected fills in the password. I have been running this for years. Today when I tried to run it Excel keeps crashing. Nothing has changed since Friday when I last ran it. Any ideas on why this is happening and what I can do to fix the problem?
Are the worksheets on seperate drives and have any permisions been changed?
Edit: Have you tried accessing everything manually to check it isn't a curupted file?
also try F8ing through the macro to see where it falls over.
Last edited by Leon V (AW); 12-23-2013 at 01:19 PM.
Sub Reputation() Dim Problem as Variant Dim Reputation as Integer For Each Problem in Forum.Threads If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1 Next Problem End Sub
They are all on the same drive. As far as I know nothing changed. Our IT department did maintenance work this weekend but said they changes no permission. If I type in the first few lines of the macro in a blank sheet it seems to work fine, but there are a lot of lines to the macro.
Workbooks.Open Filename:= _
"s:\everyone\budget & Forecast\budgets\revenue & cogs - DataVoice.xlsx", UpdateLinks:=0, Password:="XXXXX"
There are 17 files it opens. It is a very simple macro.
I eliminate the first file opening in the macro and the macro works just fine. There must be something about the first file in the macro that causes the problem but I cannot figure out what that is because as soon as I open that file and enable the content it crashes excel.
It appears that the file was corrupt and once I eliminate the one file form the macro it works fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks