Help Needed with Opening Excel Spreadsheet from Access

[dpimental]

I need to be able to open Excel Spreadsheets from access. While I have been able to find and implement code that can do this, I get inconsistent results on different machines with different versions of msexcel.

Can anyone help me with a simple method of opening a spreadsheet in access when the machine could have different versions of msexcel on it?

David Pimental
(US, Oh)

 

[PHV]

I get inconsistent results
Doing WHAT ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dpimental]

With the following code.

Dim oApp As Object, strPath As String
Dim excelPath As String
strPath = CurrentProject.Path & "\in_data\"
strFile = strPath & strFile

Set oApp = CreateObject("Excel.Application")

oApp.Workbooks.Open strFile
oApp.Visible = True

David Pimental
(US, Oh)

 

[PHV]

And what are the inconsistencies ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dpimental]

On some machines, it just doesn't work. It can't find excel or some such error. I will try to get you the specific error.



David Pimental
(US, Oh)

 

[dpimental]

THere error I am getting on some machines is this ...

ActiveX component can't create object



David Pimental
(US, Oh)

 

[Tigerlili3]

This may not fix your current problem, but you also want to make sure that you release the Excel object when you're through with it. If you don't, it will definitely cause problems. You'll need to add this at the end of your code:

Set oApp = Nothing

 

[dpimental]

Thanks. I did it. Let me know if you have any other ideas.

David Pimental
(US, Oh)

 

[stix4t2]

If you are not automating Excel you may consider an API call. If not, I have seen this error before and it had to do with multiple version of MS Office installed on the computer.

If you surf microsofts site you will find API code for the apiShellExecute(). And before you say, oh no not API, keep this in mind. You can cut and paste the code right into a module within your Access DB and gain great power. One advantage is the system will launch which ever version of Excel is currently available. Second if you can use this code to directly open or print any file type supported on the host computer. Third is experience with API alls will bring further capability when you want to use them to Open Files or select directories. And fourth is that any problems or question you have can be addressed right here.

 

[dpimental]

Thanks. I did an initial test. I got the code actually from The Access Web and it appears to work fine. I will test it Saturday on my problem pcs. Thanks for the help. I will let you know how it goes.

David Pimental
(US, Oh)

 

[ProCatHerder]

I am having the same problem. Could you post the code you got from The Access Web?

Thanks

Kim