• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 606
  • Last Modified:

VBA: How to download file to disk from site with authenticated login id and password

In VBA, I would like to be able to click on a button and have a file downloaded from a site to my harddrive.  The site where the file is located requires a login UserID and password.
I've successfully have this working with a WSH script, however, I need this to work from VBA.

I've tried the URLDownloadToFile API but it doesn't accomodate for username/password arguments.

Any thoughts?
0
wonda04
Asked:
wonda04
  • 2
1 Solution
 
nmcdermaidCommented:
Why don't you post the appropriate WSH code then we can convert it to VB.
0
 
Richie_SimonettiIT OperationsCommented:
should you pass this call in urldownloadtofile?


"http://username:password@www.domain.com/somefolder/somefile.xxx"
0
 
wonda04Author Commented:
Thanks Richie_Simonetti.  I obviously missed the obvious. = )
0
 
Richie_SimonettiIT OperationsCommented:
"I obviously missed the obvious."

Why?, we have times of shine and times of darkness (All of us).
;)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now