Trouble with Shell using XP 
Author Message
 Trouble with Shell using XP

When I used the following line of VBA code in WIN98 and WIN ME it opened my
Dial Up Dialog box:

    RetVal = Shell("C:\start.exe C:\ERDCL.lnk", 0)

Now that I'm using WIN XP it doesn't work.

Could some one please provide me a solution.

Thanks in advance...
--

Chuck Miller



Thu, 08 Jul 2004 13:05:54 GMT  
 Trouble with Shell using XP
Take a look in the .misc group for a thread titled:

"Dialing via modem in Excel 2002"

If you look in google, you can also look for author:  Cone

(It started Thursday.)

Quote:

> When I used the following line of VBA code in WIN98 and WIN ME it opened my
> Dial Up Dialog box:

>     RetVal = Shell("C:\start.exe C:\ERDCL.lnk", 0)

> Now that I'm using WIN XP it doesn't work.

> Could some one please provide me a solution.

> Thanks in advance...
> --

> Chuck Miller

--

Dave Peterson



Thu, 08 Jul 2004 22:51:37 GMT  
 Trouble with Shell using XP
Thanks for the thread but I was looking for a simple replacement to the
single line of code I used to use.  While reading through the reference
:Windows XP Inside-Out", I found a BAT command string that fit me to a T.

All that is necessary is to use NotePad and create a BAT file that uses a
command string of:

rasdial "Dial-Up Connection Name" UserID Password {The Dial-Up Connection
Name is placed in quotes if it is not contiguous.}

Then in the Excel Macro all that is necessary is to use the statement:
RetVal = Shell("path\BAT File Name", 0)

It works as slick as PAM on a doorknob.

CHUCK MILLER


Quote:
> Take a look in the .misc group for a thread titled:

> "Dialing via modem in Excel 2002"

> If you look in google, you can also look for author:  Cone

> (It started Thursday.)


> > When I used the following line of VBA code in WIN98 and WIN ME it opened
my
> > Dial Up Dialog box:

> >     RetVal = Shell("C:\start.exe C:\ERDCL.lnk", 0)

> > Now that I'm using WIN XP it doesn't work.

> > Could some one please provide me a solution.

> > Thanks in advance...
> > --

> > Chuck Miller

> --

> Dave Peterson




Sat, 10 Jul 2004 14:03:43 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. On XP workstations, my access app get hung up using shell cmd to swap to Word

2. Trouble Using SSL Ports with Outlook XP

3. Trouble naming document in Word 97 using Windows XP

4. Trouble with Shell function in Excel VB

5. Trouble with Shell command

6. HP Driver 7.1.0.0 has trouble with Publisher XP on Windows XP

7. Shell, Print, Shell, Print, etc

8. Call Shell() vs. var = Shell()

9. Trouble using the EURO symbol with Word 7.0 using Win95 or Win98

10. Shell start not working in XP


 
Powered by phpBB® Forum Software © phpBB Group