+ Reply to Thread
Results 1 to 5 of 5

vba shell command doesn't work and end up with error

  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    brazed edsctru
    MS-Off Ver
    Israel
    Posts
    3

    Question vba shell command doesn't work and end up with error

    Hi everyone

    When I tried to execut an operation on VBA to open the Hydrus code by writing this commmand:

    Shell "C:\Program Files\PC-Progress\HYDRUS-1D 4.xx\Hydrus1D.exe", vbMaximizedFocus

    But... I got two error message:


    1) Error opening file PCINFOR.SYS

    2) The file PCINFO.SYS is missing or damaged! Reinstall program or the file PCPINFOR.SYS

    I must say that I followed the error message instructions but it doesn't seems to help.

    I will be grateful for any help
    Thanks,
    Tuvia

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: vba shell command doesn't work and end up with error

    Tuvia

    Can you run Hydrus1D.exe from the command line without error?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    04-29-2013
    Location
    brazed edsctru
    MS-Off Ver
    Israel
    Posts
    3

    Re: vba shell command doesn't work and end up with error

    Hi Norie
    Thanks for the quick replay.
    I'm not sure what you meant.
    I can manually operate HydrusD1. Moreover, I can create a Hyperlink in excel and manually operate hydrusD1 from excel. But any of my trials to operate HydrusD1 through VBA failed.
    Tuvia

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Shell is the equivalent of opening the command line interface entering the path and filename.

    When you try that do you have any problems?

    By the way, if you can use a hyperlink why are you trying to use Shell?

  5. #5
    Registered User
    Join Date
    04-29-2013
    Location
    brazed edsctru
    MS-Off Ver
    Israel
    Posts
    3

    Re: vba shell command doesn't work and end up with error

    Hi Norie

    My idea is to run multiple runnings with Hydrus (a computer code that numerically solves flow equations)

    Now, I have a bigger challenge, inside this code there is a command for runniong the numerical calculation and it works with MS Dos. But again I didn't succeed to operate the command with VBA. Maybe do you have any solution for me?
    Tuvia

+ 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