Extra pulling data from excel9?

[pseudoman]

I was wondering if anyone could do me a favor and post a example of code written in extra which pulls data from excels cells, and if possible an example of extra populating a excel sheet?

thx in advance...

I thought this was the correct syntax for excel but it fails to work, given the object has already been created...

Dim Claim As Integer
Claim = objWorkBook.WorkSheets.Cells(4,2).Value
Msgbox Claim

 

[calculus]

If the object is properly created this should work.

If you are creatign an object = objWorkBook, I don't think you've specified which sheet to look at.

Try this:
Claim = objWorkBook.WorkSheets(1).Cells(4,2).Value

Where (1) represents the first sheet. You can also use sheet names.

I've not tested this, but it should work.

calculus

 

[pseudoman]

thank again calc your a guru, When I grow up I want to be just like you