Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general
|
|||
|
|||
Word crashed after repeated XL macro use
I have an Excel macro that call a new instance of Word and creates a new
document, does some things in the doc, then closes the doc without saving changes and sets the doc and Word app objects to nothing using doc.Close SaveChanges:=wdDoNotSaveChanges appWD.Quit Set doc = Nothing Set appWD = Nothing I used the macro this morning repeatedly - perhaps 30 times in succession. (Each time had to be an individual call - there was no way to loop this.) After doing all that, I did not check to see if there were any open instances of Word left (there were none during testing, so I didn't think I should have to) or other issues. Then I tried to open a Word document with an AutoOpen macro, and Word crashed. Subsequent attempts produced further crashes. I wound up eventually having to rebuild Normal to get things moving again. Question: Could just repeatedly accessing the Word app have caused this? Is there a better way to avoid these issues in the future? Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove repeated email ids by macro? | Excel Discussion (Misc queries) | |||
Merging adjacent repeated columns with a macro | Excel Discussion (Misc queries) | |||
Printing text in a repeated cell/row that is longer than repeated | Excel Discussion (Misc queries) | |||
How do I change one repeated word in the spreadsheet to another? | Excel Worksheet Functions | |||
how do I count the number of times a word is repeated in a range? | Excel Discussion (Misc queries) |