Excel not opening up with shell function (A2K runtime)

[jancheta]

Hi.

Any ideas where EXCEL will not open up with the shell function?
Here's my code:
dim s_file as string, retval as variant
s_file="c:\test\excel file.xls"
retval = Shell("EXCEL " & Chr(34) & s_file & Chr(34), 3)

When I run this on A2K full version or AccessXP, it works fine. On the users PC which has the A2K run-time version, nothing happens even though they have Excel 2000.

Or is there another way of opening a workbook from within access?

TIA!

Jason

 

[jancheta]

Just saw reply to thread705-511927:

How do I open a Word/Excel/Picture/Any Other File from Access?

http://www.tek-tips.com/faqs.cfm?spid=705&sfid=1971

I'll try it.

 

[jancheta]

I couldn't get the code to run, ByRef error.

The next worked fine:
VBScript & Excel

http://www.greggriffiths.org/webdev/both/excel/activex.html

Thanks all!

Jason