Click here to Skip to main content
15,881,381 members
Home / Discussions / Visual Basic
   

Visual Basic

 
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 
Good morning, all -

I'm trying to write some code in an Excel macro to allow me to rename files on an SFTP site before downloading them using wininet.dll.

I've managed to get a simple block written that works well against a test server, but it fails when I try to access the actual server I need.

I suspect that it's because this server uses Port 22, not the standard Port 21. But, I can't see how to change that Port address to what I need.

In InternetOpenA, I've tried setting dwAccessType to INTERNET_OPEN_TYPE_PROXY (3) and lpszProxy to ftp=ftp://Proxy1:22 (with my specifics replacing the placeholders). But, no good. InternetConnectA refuses to connect. InternetOpenA works fine and returns a valid handle, but I just can't get a connection.

So, since this code worked on the test server using the defaults, I figure I'm not modifying the Port properly for use on my specific server.

All that being said, my question, I think, is; how do I change the port address in the InternetOpenA function?

Oh, an afterthought - would that this is an SFTP, not FTP, be an issue?

Thanx in advance for any assistance!
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 
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
CKinTX24-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
CKinTX28-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
professionalphil.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
CKinTX24-Jan-20 5:58 
Questionhow to deal with active directory Pin
IbrahimOkasha14-Jan-20 23:24
IbrahimOkasha14-Jan-20 23:24 
AnswerRe: how to deal with active directory Pin
phil.o14-Jan-20 23:53
professionalphil.o14-Jan-20 23:53 
Questioncode for calculation of mark for agroup quiz Pin
Member 147079695-Jan-20 20:54
Member 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 

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.