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:
The transfer.scp file needs to be in the Data folder one level down from the excel document calling the code.HTML 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):
When I do this, the cmd window opens but it says it can't run this file.HTML Code:
Any ideas how to fix it?
Bookmarks