Shell()

[SteveC24]

Hello all,

I use Shell() to open an external program - this works absolutely fine on Windows XP - but I believe it is causing a problem on 2000.

I am using the following code:

Shell """C:\Program Files\Lindenhouse Software Ltd\InvuFirst\InvuFirst"" FirstOffice C:\billingtemp.xls", vbNormalFocus

I get an invalid procedure call on the 2000 machine?

Any ideas?

 

[boblarson]

You might try removing the ",vbNormalFocus" part and see if that works.

 

[ghudson]

I prefer to use the ShellExecute method to open a file. It does not have the problems that the Shell() function does [as you have discovered].

I have a working example in my Browse [Find a directory or file] sample.