+ Reply to Thread
Results 1 to 6 of 6

how to open a program through VBA excel userform

  1. #1
    Forum Contributor
    Join Date
    09-08-2011
    Location
    Leicester, England
    MS-Off Ver
    Excel 2007
    Posts
    157

    how to open a program through VBA excel userform

    Currently having error problems with trying to open an MS project form from an excel userform.

    Please Login or Register  to view this content.
    Does anyone see any problems with this it keeps prompting me file error on the shell path line

    thanks in advance
    Last edited by kieranbop; 09-13-2011 at 05:46 AM.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: how to open a program through VBA excel userform

    Hi Keiran

    Don't you have to specify a program to open the file? i.e Project, your path only goes to the folder it is contained in

  3. #3
    Forum Contributor
    Join Date
    09-08-2011
    Location
    Leicester, England
    MS-Off Ver
    Excel 2007
    Posts
    157

    Re: how to open a program through VBA excel userform

    I assumed that path went to the program I'm using then the file went to the folder and name of the file being used? or am I completely wrong in what I'm thinking?

  4. #4
    Forum Contributor
    Join Date
    09-08-2011
    Location
    Leicester, England
    MS-Off Ver
    Excel 2007
    Posts
    157

    Re: how to open a program through VBA excel userform

    sorry im not completely awake yet

    Please Login or Register  to view this content.
    correct what you mentioned I think but now I'm prompted with Invalid procedure/call arguement on the shell line now

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: how to open a program through VBA excel userform

    tell me about it!!

    I think it has to be the actual program and not a shortcut?

  6. #6
    Forum Contributor
    Join Date
    09-08-2011
    Location
    Leicester, England
    MS-Off Ver
    Excel 2007
    Posts
    157

    Re: how to open a program through VBA excel userform

    different way approached to get it to work someone at work sent me, thought id post here for others possibly

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1