Re: running a perl script via Shell() in MS-Access

Grygonos,
It has been a while since I have played with shell in Access, but I tend to remember there being a problem with spaces in the command being ran. I do not remember exactly how it had to be quoted or what not, but I remember for convenience I ended up writing a batch file that did what I wanted and then calling the batch file (no spaces) with the shell'd button.

Cheers - L~R

Comment on Re: running a perl script via Shell() in MS-Access

Replies are listed 'Best First'.
Re: Re: running a perl script via Shell() in MS-Access by Grygonos (Chaplain) on Jul 07, 2003 at 12:50 UTC
here's what finally worked. For those of you using windows perl, or windows in general. this cmd /c start diddy, opens the file with its associated program, so kinda handy thing to know if you're confined to windows. forgive me for posting this crappy vb code. but if you're interested I hope it helps you out. The most idiotic part as you can see is its quoting... having to use ansi chr(x) to represent double quotes while using double quotes in the same string... bad form...... tisk tisk... `Dim command As String Dim file As String file = "X:\xxx.pl" command = "CMD /C START " & Chr(34) & Chr(34) & " " & Chr(34) & file & + Chr(34) Shell command` [download]	[reply] [d/l]

Replies are listed 'Best First'.

Re: Re: running a perl script via Shell() in MS-Access
by Grygonos (Chaplain) on Jul 07, 2003 at 12:50 UTC

Dim command As String
Dim file As String

file = "X:\xxx.pl"
command = "CMD /C START " & Chr(34) & Chr(34) & " " & Chr(34) & file &
+ Chr(34)

Shell command
[download]

[reply]
[d/l]