stop excel updating from word
second argument of the workbook.open method
workbooks.open "C:\Myfiles\MyFile.xls", false
the argument is actually numeric, so you can use 0 instead of false.
--
Regards,
Tom Ogilvy
" wrote:
I have a Word macro that opens a spreadsheet, imports a text file,
does some minipulations, saves some values to another spreadsheet,
then closes the first spreadsheet. It does this iteratively several
hundred times. I would like to speed up the process by not having the
excel spreadsheets updated until the end. Is there a way to use the
application.update=false type of code in the Word macro and have it
apply to the excel spreadsheets?
TIA
Garry
|