Call program outside Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am generating a report from an outside application. I then use
Docuanalyzer to clean the report into a readable text file that I import into
Access. I have a script that runs from a desktop shortcut that automates the
Docuanalyzer process.

Can anyone show me how to activate that shortcut to run the script from
inside Access? Thanks
 
Try

Application.FollowHyperlink "PathAndFileName"

Application.FollowHyperlink "C:\FileName.txt"
 
Hey Ofer Thanks, I am intending to put this line in the on open event of my
startup form in the access tool I am using, any modifications? I will try
this shortly when I get in.
 
Here is what I am trying to get to run, the target for the shortcut I created
is as follows:

"C:\Full Path\Autoscrp.exe" "C:\Full Path\File.bat"

This runs fine from the desktop.

Application.FollowHyperlink "c:\full path\shortcut" won't run.

I then tried: Application.FollowHyperlink "C:\Full Path\Autoscrp.exe",
"C:\Full Path\File.bat"

This opens autoscrp and requires me to manually point to the file "C:\Full
Path\File.bat", which then executes.

It appears there is syntax I am not getting to correctly declare a
"subAddress as string". Any suggestions to get this running without all the
warnings and file selections?




The
 
Try

Application.FollowHyperlink """C:\Full Path\Autoscrp.exe"" ""C:\Full
Path\File.bat"""

The "" is necessary to ensure that you get " inside the string: """C:\Full
Path\Autoscrp.exe"" ""C:\Full Path\File.bat""" will result in

"C:\Full Path\Autoscrp.exe" "C:\Full Path\File.bat"
 
This is a bugger.

I get the open hyperlink warning designating:

""C:\Full Path\Autoscrp.exe" "C:\Full Path\File.bat""

as the file I want to open but it does not run and opens the debugger which
I find strange since without the extra " at least the autoscrp.exe opened
 
Back
Top