Click here to Skip to main content
15,388,904 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Split string in a textbox Pin
phil.o24-Jan-20 23:05
mvephil.o24-Jan-20 23:05 
QuestionAttempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
CKinTX24-Jan-20 3:57
MemberCKinTX24-Jan-20 3:57 
AnswerRe: Attempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
Richard MacCutchan24-Jan-20 4:09
mveRichard MacCutchan24-Jan-20 4:09 
GeneralRe: Attempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
CKinTX24-Jan-20 5:47
MemberCKinTX24-Jan-20 5:47 
GeneralRe: Attempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
Richard MacCutchan24-Jan-20 6:01
mveRichard MacCutchan24-Jan-20 6:01 
GeneralRe: Attempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
CKinTX24-Jan-20 7:26
MemberCKinTX24-Jan-20 7:26 
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 
Based on results when I searched on how to utilize GetLastError, I found that it was not recommended because basic makes a lot of other API calls that will displace the error. So, the suggestion was to use Err.LastDllError.

I did that and got an error of 12002, Time out. So, that seems to verify my presumption that it's the port address setting.

Port 21 is failing, because the server isn't listening to that port - for security reasons - and I'm not successfully changing the port address to 22, the one it is listening to.

So, I guess my bottom line question is, how do I change the port address using InternetConnectionA in wininet.dll? The methods that I tried all failed, so I'm doing something wrong.
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 
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 

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.