| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stop excel updating from word
See a possible answer in response to your second posting of the question.
-- 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't stop Excel 2007 from updating links | Excel Discussion (Misc queries) | |||
| Updating tables from Excel in Word | Excel Discussion (Misc queries) | |||
| Stop Excel from updating external links when copying in VBA | Excel Programming | |||
| Stop Excel Updating formulas when cells are deleted? | Excel Programming | |||
| Updating Word Excel Links | Excel Programming | |||
Linear Mode
