Re: Problems with Shell Method

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



Try this:

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


--
Paul Overway
Logico Solutions
http://www.logico-solutions.com


"Gibson" <imexllc@xxxxxxxxxxx> wrote in message
news:u3pVidOTFHA.3840@xxxxxxxxxxxxxxxxxxxxxxx
> 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 third ... >> The 3rd party software is installed in the same directory as the ... Is there a way to shell to a desktop shortcut? ...
    (microsoft.public.access.externaldata)
  • 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)
  • 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)