garyj
02-27-2024, 12:02 AM
Hello.. I appreciate any help on this.
My Excel workbook keeps crashing, and I have removed all the Active X controls. The code is working - and the VBA / Debug / Compile VBAProject shows no more issues. But still, it crashes... and almost always while opening. Any crashes during operation seem to have been due to an endless loop I caught after it was set off.
The error report offered does not help... it says this...
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error236160_01.xml</logFileName><summary>Errors were detected in file 'https://d.docs.live.net/4fb14f8dba7dfda8/Documents/Gary/MyDispatchCode/MyDispatch.xlsm'</summary><removedFeatures><removedFeature>Removed Feature: Object from /xl/workbook.xml part (Workbook)</removedFeature></removedFeatures></recoveryLog>
This time I went into a recovered file, that had been repaired after the unknown "removed feature" and pasted a copy just in case. Then I changed the copy into a zip file, opened the zip, and wen to the /xl/workbook.xml portion. Then I opened the original file the same way, and compared the xml. The differences outlined by GoTranscript.com. The program showed a lot of text with only a few differences. It gave back one file, with all the same text as one text, and the old removed text (shown in red and crossed out), and then the new text (shown after in green), much the same as one can edit data in Word and show the changes before they are accepted. The only differences are shown in the jpg file. See the red compared to the green.
31371
But now the question. What was wrong with the red? Why was it removed? I am fairly certain that the item in red both stopped me from opening the program, and caused it to crash. Advice on what to fix?
Thanks,
Gary
My Excel workbook keeps crashing, and I have removed all the Active X controls. The code is working - and the VBA / Debug / Compile VBAProject shows no more issues. But still, it crashes... and almost always while opening. Any crashes during operation seem to have been due to an endless loop I caught after it was set off.
The error report offered does not help... it says this...
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error236160_01.xml</logFileName><summary>Errors were detected in file 'https://d.docs.live.net/4fb14f8dba7dfda8/Documents/Gary/MyDispatchCode/MyDispatch.xlsm'</summary><removedFeatures><removedFeature>Removed Feature: Object from /xl/workbook.xml part (Workbook)</removedFeature></removedFeatures></recoveryLog>
This time I went into a recovered file, that had been repaired after the unknown "removed feature" and pasted a copy just in case. Then I changed the copy into a zip file, opened the zip, and wen to the /xl/workbook.xml portion. Then I opened the original file the same way, and compared the xml. The differences outlined by GoTranscript.com. The program showed a lot of text with only a few differences. It gave back one file, with all the same text as one text, and the old removed text (shown in red and crossed out), and then the new text (shown after in green), much the same as one can edit data in Word and show the changes before they are accepted. The only differences are shown in the jpg file. See the red compared to the green.
31371
But now the question. What was wrong with the red? Why was it removed? I am fairly certain that the item in red both stopped me from opening the program, and caused it to crash. Advice on what to fix?
Thanks,
Gary