Problem with Excel!!!!!!!! COME ON!!

[Andreex]

What I am doing is this:

Set ObjWord = Word.Application
Dim i As Integer

For i = 1 To ObjWord.Documents.Count
lstabierto.AddItem ObjWord.Documents(i).Name
Next

In this way I am adding all the Word Documents that are currently open to a Listbox. When I tried to do the same with Excel:


Set objexcel = Excel.Application

For i = 1 To objexcel.Workbooks.Count
lstabierto.AddItem objexcel.Workbooks(i).Name
Next


Visual Baisc doesnt detect any Excel workbook open. (I do have excel opened)

ANY IDEAS????!!!?!?!?!?!?!?!?

[Emo]

You might wanna try the VB General Questions forum, not here...

-Emo

[billfaceuk]

Yeah we wanna chat not think. :p