CODEWITHSUNDEEP
excelvbasftpwinscp
Anakha
Anakha

Reputation: 3

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.

Upvotes: 0

Views: 555

Answers (1)

Gustav
Gustav

Reputation: 55806

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.

Upvotes: 1

Related Questions