Hi Guy
I have in the past month created a complex (for me) userform on Word's VBA.
Now that I am all but done I seem to be unable to open an Excel WorkBook
by using the workbooks.add. It gives me an error 424 object required.
I taught that would work like the Word command Documents.add.
Do I need to declare anything?

Do any of you know how I should proceed.

Thanks

It is - sort of - like the Word command Documents.Add.

However, as you have found out, you need an object to do so. An Excel application object. This can be early or late binding. If you do NOT need to worry about version issues, use early binding.

To use early binding you need to first set a Reference to the Excel libraries - this is done in the References menu item in the VBE.

Then you must declare your object variables.

Then you must SET your object variables.

There are lots and lots of examples to be found.

Dim oExcel As Excel.Application
Dim oWB As Workbooks
Set oExcel = New Excel.Application

Set oWB = oExcel.Workbooks.Open("c:\test\Classeur1.xls")

however I get an error 13
at first I used variable to provide the path but since it says type mismatch I changed it to a short location. I even changed from .xlsx to .xls just to be safe but it's still not working. Any suggestion?

This is wrong:
Dim oWB As Workbooks
It should be:
Dim oWB As Workbook

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for the help guys.