Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Script a userid and password (apache)
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?? (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. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Script user id and password | Excel Programming | |||
DSN UserId and Password Prompt | Excel Programming | |||
DSN UserId and Password Prompt | Excel Programming | |||
Web Query - UserID/Password Protected Textbox | Excel Programming | |||
FileSystemObject CopyFile with UserID/Password | Excel Programming |