Call a Command file via VBA 1

[MichM3]

Dear,

I have a BO deski report with some VBA functionality.

At the end of the code I'd like to execute a .com file. What's the syntax to perform this?

Right now, I try with Shell(<path+filename>) but it generates an error in BO's Broadcast Agent => "(0) Cannot get script from document..."

Doing something wrong?

regards,

Mich

 

[oharab]

Try the technique here

http://www.mvps.org/access/general/gen0015.htm,

If that doesn't work, try

http://www.mvps.org/access/api/api0018.htm

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.

 

[MichM3]

thanks !!