Opening Excel files from ftp site
Opening Excel files from ftp site
(OP)
I am trying to automate retrieving data from Excel file located on ftp site to the master Excel file. The goal is to open the file without typing user name and password every time. I use the following VBA code in master file:
Workbooks.Open Filename:=_
"ftp://user:myname password:mypassword @nontech.com/Proj041202.xls"
Excel continue asking me for a password the first time I run macro, maybe there's a syntax error. Help is greatly appreciated.
Workbooks.Open Filename:=_
"ftp://user:myname password:mypassword @nontech.com/Proj041202.xls"
Excel continue asking me for a password the first time I run macro, maybe there's a syntax error. Help is greatly appreciated.





RE: Opening Excel files from ftp site
password@nontech.com/Proj041202.xls"" TARGET="_new">ftp://username:password@nontech.com/Proj041202.xls"
This is how I log in using the Internet Transfer Control in VB.
RE: Opening Excel files from ftp site
Thanks a lot, it worked! Meanwile I was accessing ftp files using window scripting, which is different for Win98, 2000 and XP.
RE: Opening Excel files from ftp site