View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SueK SueK is offline
external usenet poster
 
Posts: 29
Default Update Excel from Word

Hi!

I need to create an Excel file that would update from multiple Word documents.
Ex. In Word, I have a table with a cell that has the person responsible for
a project. If the person responsible changes, I'd like cell B2 in Excel to
automatically update with the name change. Is this possible? I tried to
copy, paste special, paste link, Microsoft Office Word Document Object to my
Excel file but anytime I update the Word document, it gives me a message
saying cannot start the source application for this object. Can anyone help?
Is there a way to do this rather than changing all those Word documents to
Excel files?