Accessing Excel data from within Word

[AcousticalConsultant]

Hi,

I'm trying to automate a report in Word based on data entered in an Excel spreadsheet. So far everything's working, I just need Word to look at a specific cell in excel and write a sentence based on what it finds. For example, I know this is wrong, but this is what I tried:

If (Excel.Range("A1&quot = 0) Then
.
.
.
End If

Both Word and Excel are opened, and the documents in question are also open. All I need to do is verify that cell.

Thanks!

 

[ide]

here are some xcel object:
sub sdf()
Dim xlExcel, xlBook, xlSheet As Object
Set xlExcel = GetObject(, "Excel.Application&quot
Set xlBook = xlExcel.activeworkbook
Set xlSheet = xlBook.ActiveSheet
MsgBox xlSheet.Range("A1&quot.Value
end sub

if your xl application runs, it displays the value of A1 range of the activesheet
ide