How to move files from Unix server FTP (Tectia) to Local machine?

[nikunjgattani]

Hi,

We got several files every month on first few days.

Currently, I am copying those files from FTP to local machine then again copying them toed some other shared location manually.

I want to automate this process by using either SAS code or VB Script or Excel VBA code.

So, that each day I will run that code and the code copies latest uploaded files on FTP Server (Tectia) to local machine.

Regards,
Nikunj

[LinusH]

If this is a process that any other users/system depend on, it souls rather be a push from the central server. Or, perhaps most preferred, a scheduled job.
So in short, start with the file owner system, and any centrally managed scheduling tool.