Search code examples
excelvbasftpwinscp

Automating Macros for an excel file in SFTP location

I have an excel file in an SFTP location with inbuilt macros in it. I want to do an automation such that the macro runs at a certain time daily in the SFTP server. Initially I did it using task scheduler, but now that the file is not available locally and since it is residing in the SFTP Location I am unsure on what to do. Help.

Solution

  • You can't. The SFTP server is a file store, not an application server.

    So, download the file in question to a local folder, run your macro using this local file, and - when done - upload it to the SFTP server overwriting the old file.