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
