Running a batch file from a macro?

P

paulcrigh

New member

Local time

Yesterday, 19:45

Joined

Jan 26, 2010

Messages

8

• Jan 27, 2010

• #1

Hi Guys,

This surely cant be as difficult as I am finding it

I have a batch file that works perfectly, which FTP's files from my local machine to one of my servers. All I want to do is have a step in my Microsoft Access Macro which runs this batch file

Is there a way of doing this?

Thanks

Paul

 

boblarson

Smeghead

Local time

Yesterday, 19:45

Joined

Jan 12, 2001

Messages

32,059

• Jan 27, 2010

• #2

Use the RunApp macro action and put the entire path to the .cmd/.bat that you want to run in the Command Line box that comes up when you select RunApp from the Actions list.

 

P

paulcrigh

New member

Local time

Yesterday, 19:45

Joined

Jan 26, 2010

Messages

8

• Jan 27, 2010

• #3

Hi Boblarson - I was hoping to use RunApp but it isnt one of the Action items in the drop down list......now forgive me If I am being stupid but I am not a great user of Access - is this normally not available within Access 2007 as that is the version I am using?

 

P

paulcrigh

New member

Local time

Yesterday, 19:45

Joined

Jan 26, 2010

Messages

8

• Jan 27, 2010

• #4

FOUND IT - I HAD TO CLICK ON "SHOW ALL ACTIONS" HA HA!

Paul

 

V

vivek90

New member

Local time

Today, 09:15

Joined

Dec 6, 2012

Messages

1

• Dec 6, 2012

• #5

Hi Paul,

You said you have a batch file that will automatically transfers the file from our local drive to the client server through the FTP server..
Could you please share that batch file to me, as i need it to one of my process..
It will be helpful to me to create a batch file that will do the automatic transfer( when we double click and open an batch file, it has to automatically open the particulara FTP server and download the recent dated file).
Thank you in advance..

~Vivek