How to open an excel file (7.0) from access 97 1

[Fortisdragon]

Hello,

I'm new here and I'm starting to "play" with VBA Access.
Despite the Microsoft Tips, I'm able to open a new instance of excel (like an activeX object) but obviously the same command cannot open an xlfiles on a server.

Is someone can help me?

Thanks a lot,
Emmanuël

 

[Baggie]

FortisDragon

Try this:

Dim appUserFile As New Excel.Application

appUserFile.Workbooks.Open ("C:\YourExcelFilename")
appUserFile.Visible = True
Set appUserFile = Nothing

HTH

 

[Fortisdragon]

Thanks a lot Baggie!

In fact the answer was between both solutions...
because Access 97 doesn't recognize "New" in your first Line

But... I've wrote the following and it works pretty well!

Dim MyXls As Object
Set MyXls = CreateObject("excel.application&quot
MyXls.Visible = True
MyXls.Workbooks.Open ("C:\YourExcelFilename&quot
.../...

So it's still an activeX object and I'm able to control Excel via Access.

Bye and thanks again,
Emmanuël