Accessing values form Excel Cells

[Simon]

Hi

I want to write a macro that gets information from a
specific Excel sheet from certain cells, and from names
within the excel document.

ie. From document ("C:\price\price.xls"), sheet "PTable",
Cell "F14" into a variable in a VB script. And also form
name "car".

I then want to place this information in a word document,
with text relating to the values from the Excel sheet.
ie. If value>10 then
typetext "To expensive"
else
typetext "ok"
end if

Can someone tell me how to get the variables out of the
excel document.

Thanks in advance Simon

 

[Doug Robbins - Word MVP]

Hi Simon,

See the article "Control Excel from Word" at:

http://www.mvps.org/word/FAQs/InterDev/ControlXLFromWord.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP