Chris,

Your suggestion below works sometimes, not always. It's strange....often
when I open the file for the forst time and run the code, it still prompts
me for the user id and password. If I ener it, then rerun the code later,
it does NOT prompt me for user id and password. Any idea how I can get it
to NEVER prompt me??

"Chris" wrote in message
news:lR8nd.50283$V41.47574@attbi_s52...
(Apache). Can that user id and pw be coded in my vba module?

CSVPath = "http://test/testdata/latestdata.csv"

Workbooks.Open CSVPath

CSVPath = "

Enjoy

--
You should never practice juggling with batteries. I have the
black eye to explain why.