Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    England
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    application.run error (windowsXP officeXP pro 2002)

    help i have the following
    Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    Application.Run "Cocuments and SettingsMR.SIMMSDesktopcom056PLAY.xls!ADS1"

    End Sub

    all i get is error "Cocuments and SettingsMR.SIMMSDesktopcom056PLAY.xls!ADS1" Cannot Be found.

    i know its on my desk top and the macro i want to run is ADS1

    where am i going wrong???

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

    Re: application.run error (windowsXP officeXP pro 2002)

    The worksheet name should be enclosed in (single) quotes, since it contains spaces:

    <code>Application.Run "'Cocuments and SettingsMR.SIMMSDesktopcom056PLAY.xls'!ADS1"</code>

  3. #3
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    England
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: application.run error (windowsXP officeXP pro 2002)

    thank you for your quick reponse to my call for help
    either i've coppied the wrong files from work but sytill not working will try on friday---- on holiday until wednesday when i hope to reply further

Posting Permissions

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