Re: Using Shell Command

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It's more likely that the short cut has its Start in property set to the
folder. If that's not done, then you really can't be sure where the program
is going to look for the file.

Easiest will probably be:

Test = Shell("C:\Directory\File.EXE C:\Directory\Config1.XXX")


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Klatuu" <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DB026447-0747-414B-B27D-59E328A349F6@xxxxxxxxxxxxxxxx
> Look at the command line in your short cut to see if there are any command
> line options included. If there are, you will have to add them to your
> shell
> statement. What does this File program do, anyway?
>
> "Gibson" wrote:
>
>> Using a Access2003 database in WinXP I am trying to shell over to a third
>> party software to run it. I am using the code line.
>> Dim Test
>> Test = Shell("C:\Directory\File.EXE Config1.XXX")
>>
>> The 3rd party software is installed in the same directory as the
>> database.
>> The problem is when the File.Exe runs it looks for other files to load
>> and
>> claims it can't find them. It claims it can't find file Config1.XXX when
>> it
>> is there. Apparently File.exe thinks it is running somewhere else than in
>> its directory. When I create a shortcut on the desktop to run the
>> File.EXE
>> it works fine. Is there a way to shell to a desktop shortcut? I'd rather
>> not have my clients have to alt-tab out of the database to the desktop to
>> run this program
>>
>> Thanks
>>
>>
>>


.

Relevant Pages

  • Re: Using Shell Command
    ... >>> Using a Access2003 database in WinXP I am trying to shell over to a ... >>> The 3rd party software is installed in the same directory as the ... >>> database. ... Is there a way to shell to a desktop shortcut? ...
    (microsoft.public.access.externaldata)
  • Re: Problems with Shell Method
    ... the .exe file and tried to shell to it with no luck. ... for Shell or a means to Shell to a shortcut located on the Desktop. ... ..exe file works great from a desktop shortcut. ... >> database. ...
    (microsoft.public.access.formscoding)
  • Re: Problems with Shell Method
    ... > The 3rd party software is installed in the same directory as the database. ... Is there a way to shell to a desktop shortcut? ...
    (microsoft.public.access.formscoding)
  • Using Shell Command
    ... Using a Access2003 database in WinXP I am trying to shell over to a third ... The 3rd party software is installed in the same directory as the database. ... Is there a way to shell to a desktop shortcut? ...
    (microsoft.public.access.externaldata)
  • Problems with Shell Method
    ... Using a Access2003 database in WinXP I am trying to shell over to a third ... The 3rd party software is installed in the same directory as the database. ... Is there a way to shell to a desktop shortcut? ...
    (microsoft.public.access.formscoding)