Log In
Register
Home
August 25, 2017
Offline
I just purchased a new computer and added Office Professional Plus 2016. When I tried opening my Microsoft Excel macro file, I received the error code 400 and it shutdown. The file was originally created with the 2007 version and later saved in the 2013 version. Do you know what caused the problem and how to fix the issue? I contacted Microsoft and one particular team could not fix it.
Any assistance is greatly appreciated.
Trusted Members
Moderators
November 1, 2018
Offline
Can you post the file?
August 25, 2017
Offline
it is a huge file 100,000mg with many macros
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Seems likely to be some macro code that causes this. Did a search and found this topic in a different forum. Perhaps it can help you forward in finding the culprit.
Trusted Members
Moderators
November 1, 2018
Offline
Do you have code that runs automatically when the workbook opens? If so, please post it, otherwise it's all going to be random guesswork.
August 25, 2017
Offline
Velouria,
No I have to activate each macro. A similar issue occurred with a different file and our field support tech fixed the problem, but he is no longer with us. I don't know what the tech did and notes were not saved in the work order. I will take a look at the website that Anders provided and see if it helps.
Thanks
August 25, 2017
Offline
As the macro was running, it highlighted in yellow "tmp_Frequency = FrequencyArrray(j)
This is the code. Do you see a problem with the code?
'sort the arrays with by bubble sort, sorting Actuals
i = 0
j = 0
For i = 0 To colCount - 1
For j = 0 To (colCount - 1 - i)
If (ActualArray (j + 1) > ActualArray(j)) Then
tmp_Actual = ActualArray(j)
tmp_Frequency = Frenquencyarray(j)
tmp_FrequencyFormula = FrequencyFormulaArray(j)
ActualArray(j) = ActualArray (j + 1)
FrequencyArray(j) = FrequencyArray(j+1)
FrequencyFormulaArray(j) = FrequencyFormulaArray(j+1)
ActualArray (j+1)= tmp_Actual
FrequencyArray(j+1) = tmp_Frequency
FrequencyFormulaArray(j+1) = tmp_FrequencyFormula
End If
Next j
Next i
1 Guest(s)
