Suggestions for sFTP Handling

[Andy2016]

Hey all,

I was just looking for some advice/suggestions on handling a VBA-sFTP relationship.

Presently I have an upload of a CSV file via sFTP to a third party. The third party response file can take up to 1 hour to be returned.

Therefore I was wondering if anyone could suggest any more eloquent solutions other than a DO EVENTS LOOP waiting for the response file to appear.

Cheers

Andy

 

[AFPathfinder]

Is there a unique event that occurs to Excel when the third party response is received? I'm thinking you could just have a second macro that runs on event.

 

[Andy2016]

Is there a unique event that occurs to Excel when the third party response is received? I'm thinking you could just have a second macro that runs on event.

Hi AFPathfinder,

Thanks for the response. I like your suggestion of using an event handler, however the third party response is simply populating the /OUT folder of their FTP portal, so no interaction with Excel on that level.

Andy

 

[AFPathfinder]

I'd think the simple fix is to split the macro into a second macro on a button and the user just clicks it when the FTP file is received.

It is possible to have Excel check the folder periodically for changes, though. I've never done this myself, but I did run across this example:
https://stackoverflow.com/questions...ode-every-set-number-of-seconds-i-e-120-secon