Results 1 to 3 of 3
  1. #1
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Macro Error (MSO 2003)

    I ported the file from my 2000 macros over to 2003. I mean to say that I copied the text from the file, and pasted it into a new VBAProject.otm file, the text contents of which is below.

    I tried to execute the call to wopr.com, but I got an error that the file could not be found.

    Why?

    Regards,
    Chuck Billow




    **********
    Sub PSACards()
    Shell ("C:WinAppsInfoPSA Cardscards.exe"), vbNormalFocus
    End Sub
    Sub TenKey()
    Shell ("C:Windowscalc.exe"), vbNormalFocus
    End Sub
    Sub Google()
    Shell ("C:WinAppsCommInternetGoogleGGSearchToolggsearch. exe"), vbNormalFocus
    End Sub
    Sub WOPR()
    Shell ("http://www.wopr.com"), vbNormalFocus
    End Sub
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macro Error (MSO 2003)

    Shell starts an executable file (i.e. a program or batch file), and http://www.wopr.com, unlike the other examples, is not an executable file. I don't think it would work in ANY version of VB/VBA. You might use

    <code>Shell """crogram filesinternet exploreriexplore.exe"" http://www.wopr.com", vbNormalFocus</code>

  3. #3
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Macro Error (MSO 2003)

    Hans:

    Great...thanks.

    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •