View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] gw.boswell@gmail.com is offline
external usenet poster
 
Posts: 16
Default stop excel updating from word

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