Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I am saving a table to excel file on local machine by running a macro and now I need to upload that file to FTP server.
Please guide me how to write a batch file to copy file from local to FTP server , what is the required command or path syntax.
Or if there is way we can directly pass the path in the macro ?
Thanks in advance!
Believe you are looking in the wrong place on this one! You would need to allow EXECUTE in the load script for starters:
Once that is enabled you would need to run command line most likely which would be something like c:\cmd.exe -c and then your .bat/.cmd file with your FTP commands. The -c on the cmd.exe tells things to close everything up once the .bat/.cmd completes. For specifics on the FTP command, you are likely better off doing a Google search on the FTP server being used to get the correct syntax etc. Hopefully this gives you a way to move this one forward.
Regards,
Brett