Suggestions for sFTP Handling
Attend Excelapalooza
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Suggestions for sFTP Handling

  1. #1
    New Member
    Join Date
    May 2015
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Suggestions for sFTP Handling

     
    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

  2. #2
    Board Regular
    Join Date
    Apr 2012
    Location
    Texas, USA
    Posts
    515
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Suggestions for sFTP Handling

    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.

  3. #3
    New Member
    Join Date
    May 2015
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Suggestions for sFTP Handling

    Quote Originally Posted by AFPathfinder View Post
    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

  4. #4
    Board Regular
    Join Date
    Apr 2012
    Location
    Texas, USA
    Posts
    515
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Suggestions for sFTP Handling

      
    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/...-i-e-120-secon

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com