Click here to Skip to main content
15,390,901 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Attempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
Richard MacCutchan24-Jan-20 9:05
mveRichard MacCutchan24-Jan-20 9:05 
GeneralRe: Attempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
CKinTX24-Jan-20 10:00
MemberCKinTX24-Jan-20 10:00 
GeneralRe: Attempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
Richard MacCutchan24-Jan-20 10:21
mveRichard MacCutchan24-Jan-20 10:21 
GeneralRe: Attempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
CKinTX24-Jan-20 10:39
MemberCKinTX24-Jan-20 10:39 
GeneralRe: Attempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
Richard MacCutchan24-Jan-20 11:26
mveRichard MacCutchan24-Jan-20 11:26 
GeneralRe: Attempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
CKinTX28-Jan-20 4:49
MemberCKinTX28-Jan-20 4:49 
AnswerRe: Attempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
phil.o24-Jan-20 4:10
mvephil.o24-Jan-20 4:10 
GeneralRe: Attempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
CKinTX24-Jan-20 5:58
MemberCKinTX24-Jan-20 5:58 
Thanx, but that's not a solution.

The problem is that we receive files from a client covering a weeklong window of daily files. Unfortunately, whatever automation routine they use saves each daily file with the same name, so each successive file has '_X' where 'X' is an incremental values for each new file past the first appended to the name. That means, I have to manually rename the files, substituting the file's creation date in place of the '_X', download them and then move the originals to an archive folder on the SFTP site.

At the moment, I'm doing it manually with FileZilla, but I'm wanting to automate my end to cut down on manual manipulation. I want to expand on a current Excel macro that is already part of the process to take on this task.

For me, the putty solution might work - looking at the link, I don't see where I define the port address, unless it's just by appending ':22' to pHost. But, I have to make this code accessible to everyone, in case I am out and my backup has to do my task. I don't always know who that would be and they may not have the rights to add putty to their system.

But, thanx again for the response.
Questionhow to deal with active directory Pin
IbrahimOkasha14-Jan-20 23:24
MemberIbrahimOkasha14-Jan-20 23:24 
AnswerRe: how to deal with active directory Pin
phil.o14-Jan-20 23:53
mvephil.o14-Jan-20 23:53 
Questioncode for calculation of mark for agroup quiz Pin
Member 147079695-Jan-20 20:54
MemberMember 147079695-Jan-20 20:54 
AnswerRe: code for calculation of mark for agroup quiz Pin
OriginalGriff5-Jan-20 20:56
mveOriginalGriff5-Jan-20 20:56 
AnswerRe: code for calculation of mark for agroup quiz Pin
Richard MacCutchan5-Jan-20 22:07
mveRichard MacCutchan5-Jan-20 22:07 
AnswerRe: code for calculation of mark for agroup quiz Pin
Patrice T13-Jan-20 15:32
mvePatrice T13-Jan-20 15:32 
Questionvisual basic 6.0 Pin
Member 1469850023-Dec-19 20:26
MemberMember 1469850023-Dec-19 20:26 
AnswerRe: visual basic 6.0 Pin
Richard MacCutchan23-Dec-19 21:36
mveRichard MacCutchan23-Dec-19 21:36 
AnswerRe: visual basic 6.0 Pin
Dave Kreskowiak25-Dec-19 8:34
mveDave Kreskowiak25-Dec-19 8:34 
QuestionExcel Data Export Pin
RajaMohammed.A19-Dec-19 23:56
MemberRajaMohammed.A19-Dec-19 23:56 
QuestionRe: Excel Data Export Pin
Richard MacCutchan20-Dec-19 0:25
mveRichard MacCutchan20-Dec-19 0:25 
AnswerRe: Excel Data Export Pin
Johan Hakkesteegt27-Jan-20 21:54
MemberJohan Hakkesteegt27-Jan-20 21:54 
Questionhow to use a variable for sequencer Pin
nrdroque12-Dec-19 4:17
Membernrdroque12-Dec-19 4:17 
AnswerRe: how to use a variable for sequencer Pin
dan!sh 12-Dec-19 5:04
professional dan!sh 12-Dec-19 5:04 
GeneralRe: how to use a variable for sequencer Pin
nrdroque12-Dec-19 5:18
Membernrdroque12-Dec-19 5:18 
QuestionCount duplicates in a large richtextbox (1000+ lines) Pin
VBwolf11-Dec-19 9:23
MemberVBwolf11-Dec-19 9:23 
AnswerRe: Count duplicates in a large richtextbox (1000+ lines) Pin
Dave Kreskowiak11-Dec-19 12:16
mveDave Kreskowiak11-Dec-19 12:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.