Can I run batch-files by VBA ?

[bobvanhouten]

Hi,


I really want to know whether it's possible to run batch-files with VBA or not.
Second question: How do I do that ?

The situation is as follows (pretty simple actually):
I'm running an App (let's say Excel or Access 2000).
While running this program I want to run a batch-file (.bat) which executes a photo-resizing and renaming-program.

I did find the AppActivate- and Shell-functions, and they seem to work (çause I don't get an errormessage), but it doesn't seem to execute the command-lines in the batch-file.

Hope some good-hearted VBA-freak can help me out here !
Thanks in advance.

[Clothahump]

Build your command line in a string, then use the shell command:

dim sCmd as string
 
'  code to build sCmd here
 
Shell sCmd