OPEN Excel file WITH VB !?

[desprits]

When I do that : IT's OK
MsgBox "monExcel.Workbooks.Add PathExcel"
monExcel.Workbooks.Add PathExcel
monExcel.Application.Visible = True

But when I do that : It's cause FATAL error
MsgBox "monExcel.Workbooks.Open PathExcel"
monExcel.Workbooks.Open PathExcel ' HERE ERROR FATAL
monExcel.Application.Visible = True

Why ? Please

 

[UKmedia]

If you do this
Dim PathExcel As String

PathExcel = App.Path & "\spreadsheet1.xls"

monExcel.Workbooks.Open PathExcel
monExcel.Application.Visible = True

OR

monExcel.Workbooks.Open App.Path & "\SpreadSheet1.xls"
monExcel.Application.Visible = True

U are not telling it what to open.

UKmedia productions

http://www.uk-media.com