Click here to Skip to main content
15,901,035 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 
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 

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.