By using File > Save As the saving process is done in background by default.
But with macro it seems that it's not possible, ActiveDocument.SaveAs command always freeze the whole program if the document is quite big.
Is there any way we can use multi thread for saving process with macro? In VBA or VB.NET?
Can anyone help? My project relies heavily on this.
Why 'Save as...'?Do you want to save it always under a different name?Especially if I'm aware that my output will become huge, I'm splitting my projects in two parts: One small, handy document with the VBA-Code and one document for the expected output.Almost all of my projects have an Init-Part where I assign the document with the VBA to a variable like :Public PrgDoc as DocumentSub Init...Set PrgDoc = ThisDocument...End SubThen I have a procedure which does roughly the following:It checks, if the document had been saved more than 5 minutes ago and - if his is the case - it saves the PrgDoc.It contains a line like:If Now() - FileDateTime(PrgDoc.FullFileName) > TimeSerial(0, 5, 0) Then PrgDoc.SaveThis procedure I'm starting after the Init at the beginning of each program code starting a new Macro-Block.This causes that I'm saving my document from time to timeMaybe this workaround helps you too ...