Bypassing Excel's FTP login/password dialog
Hi all,
Currently, I am using
to connect to a ftp server to download files that will generate my
Please Login or Register to view this content.
data.
The script works great, the only problem is that it brings up a FTP
login screen, prompting for the username and password.
This script needs to be automated, so I cannot have a login dialog
box.
As shown above, I have put the username and password details within
the ftp link, but the dialog box is still displayed.
Any ideas?
many thanks in advance
Last edited by royUK; 01-31-2008 at 03:49 AM.
hi there,
I have never used ftp through VBA, but maybe the info on the following link is of any help to you: http://www.ozgrid.com/forum/showthread.php?t=47625
J.
Hi jevni1974,
That code is doing something a little different from what I need.
I need to download files from a FTP site to populate data on my Excel sheet, not upload any files.
I am also required to use the "Workbooks.OpenText" function to actually grab the file...or something very similar.
thanks for the tip though
tmant, please use Code tags when posting VBA.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks