×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Opening Excel files from ftp site

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.

RE: Opening Excel files from ftp site

Try skimming it down to just:

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

(OP)
TejuKey,
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

Hi, I'm trying to enter in the "trimmed down" version of this, but I'm having difficulties making it work.  Are all the quotation marks in place in the example?  It looks like there are 5 quotation marks... does that make sense?  Thanks for the help!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources