Shell() (1 Viewer)

S

SteveClarkson

Registered User.

Local time

Today, 09:29

Joined

Feb 1, 2003

Messages

439

• Feb 10, 2006

• #1

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:

Code:Copy to clipboard

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

Smeghead

Local time

Today, 01:29

Joined

Jan 12, 2001

Messages

32,059

• Feb 11, 2006

• #2

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

 

ghudson

Registered User.

Local time

Today, 04:29

Joined

Jun 8, 2002

Messages

6,195

• Feb 11, 2006

• #3

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.