View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steph[_3_] Steph[_3_] is offline
external usenet poster
 
Posts: 312
Default 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