Click here to Skip to main content
15,900,629 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Excel VBA seems to read an old value from a cell Pin
ZurdoDev31-Jan-20 10:49
professionalZurdoDev31-Jan-20 10:49 
Questioncant get Ascii art to display after the RLE file Pin
Member 1472117930-Jan-20 0:57
Member 1472117930-Jan-20 0:57 
AnswerRe: cant get Ascii art to display after the RLE file Pin
phil.o30-Jan-20 1:10
professionalphil.o30-Jan-20 1:10 
GeneralRe: cant get Ascii art to display after the RLE file Pin
ZurdoDev30-Jan-20 1:24
professionalZurdoDev30-Jan-20 1:24 
GeneralRe: cant get Ascii art to display after the RLE file Pin
Member 1472117930-Jan-20 2:21
Member 1472117930-Jan-20 2:21 
GeneralRe: cant get Ascii art to display after the RLE file Pin
ZurdoDev30-Jan-20 2:24
professionalZurdoDev30-Jan-20 2:24 
GeneralRe: cant get Ascii art to display after the RLE file Pin
phil.o30-Jan-20 2:30
professionalphil.o30-Jan-20 2:30 
GeneralRe: cant get Ascii art to display after the RLE file Pin
Member 1472117930-Jan-20 2:19
Member 1472117930-Jan-20 2:19 
GeneralRe: cant get Ascii art to display after the RLE file Pin
Dave Kreskowiak30-Jan-20 2:22
mveDave Kreskowiak30-Jan-20 2:22 
GeneralRe: cant get Ascii art to display after the RLE file Pin
phil.o30-Jan-20 2:24
professionalphil.o30-Jan-20 2:24 
GeneralRe: cant get Ascii art to display after the RLE file Pin
CHill6030-Jan-20 2:24
mveCHill6030-Jan-20 2:24 
QuestionRe: cant get Ascii art to display after the RLE file Pin
ZurdoDev30-Jan-20 1:24
professionalZurdoDev30-Jan-20 1:24 
QuestionCreating custom BorderlessForm Pin
mo149229-Jan-20 6:57
mo149229-Jan-20 6:57 
QuestionInteractive QR Code in MS Word 2013 template Pin
Redha Ali29-Jan-20 6:03
Redha Ali29-Jan-20 6:03 
AnswerRe: Interactive QR Code in MS Word 2013 template Pin
Eddy Vluggen29-Jan-20 13:32
professionalEddy Vluggen29-Jan-20 13:32 
AnswerRe: Interactive QR Code in MS Word 2013 template Pin
Dave Kreskowiak29-Jan-20 16:25
mveDave Kreskowiak29-Jan-20 16:25 
QuestionSplit string in a textbox Pin
aginell12324-Jan-20 22:32
aginell12324-Jan-20 22:32 
AnswerRe: Split string in a textbox Pin
phil.o24-Jan-20 23:05
professionalphil.o24-Jan-20 23:05 
QuestionAttempting to Connect to an SFTP Server with an Excel Macro Using VBasic Pin
CKinTX24-Jan-20 3:57
CKinTX24-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
CKinTX24-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
CKinTX24-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
CKinTX24-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.

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.