Hi,

I have a macro that runs a batch file to upload data to an ftp location.

The code currently works fine when I have the file transfer.scp on a local or network drive, the line of code usually looks like this:

HTML Code: 
The transfer.scp file needs to be in the Data folder one level down from the excel document calling the code.

I now have a problem when I've moved the whole Production Tool folder to our intranet so users can get to it.

I tried replacing the shell line of code with (have confirmed this is the correct location):

HTML Code: 
When I do this, the cmd window opens but it says it can't run this file.

Any ideas how to fix it?