Script user id and password
 

Hello. The code below simply opens a csv file that is housed on a web
server. Unfortunately to connect to it, a user id and password is required
(Apache). Can that user id and pw be coded in my vba module?

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

Workbooks.Open CSVPath

Script user id and password
 

(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.

Script user id and password
 

Hi Chris. Thanks for the response. I tried it, but got an error. I
entered your proposed url directly into internet explorer, but got "page
cannot be displayed". I assume I substitute the actaul userid and password
where you have below? Any ideas? Thanks!

"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.

Script user id and password
 

Chris. nevermind! When it runs in the code, it works perfectly!! Thanks
you SO much!! Much appreciated.

Steph

"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.

Script user id and password
 

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.