Numerous links to Excel in Word Report

[Lesa Richmond]

I have a 40 or so page Word report to which I've linked
about 25 charts, 10 tables (as pictures), and 75 or so
cell values, using the LINK field (ie. Paste Link
feature). Naturally, Word is working very hard to keep
all the fields automatically updated.

My question is, if I used VBA and figured out how to set
the Excel file as the source, created document variables
that held the values of the named ranges, then placed
DocVariable fields in the Word report, would that reduce
the stress on Word or would Word just have to "go
somewhere else" to handle the same workload? (I know
there's more required in VBA but I think this conveys the
general idea.)

Lesa

 

[Cindy M -WordMVP-]

Hi Lesa,

this should be less "stressful" for Word as all the
information would be stored locally. When Word updates an
Excel link it's actually using OLE and opening Excel to
update the data. It's all this opening/closing of Excel via
OLE that's keeping Word so busy.

I have a 40 or so page Word report to which I've linked
about 25 charts, 10 tables (as pictures), and 75 or so
cell values, using the LINK field (ie. Paste Link
feature). Naturally, Word is working very hard to keep
all the fields automatically updated.

My question is, if I used VBA and figured out how to set
the Excel file as the source, created document variables
that held the values of the named ranges, then placed
DocVariable fields in the Word report, would that reduce
the stress on Word or would Word just have to "go
somewhere else" to handle the same workload? (I know
there's more required in VBA but I think this conveys the
general idea.)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail