View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andycg andycg is offline
external usenet poster
 
Posts: 1
Default macro to open csv file on the web with password


Hi all -

confused noob here :) i want to create a function in excel to open
csv file on the web and then do copy and paste. so far so good until m
company decided to put password on the link for security reason. m
current script (without password) looks like this:

Workbooks.Ope
Filename:="http://www.ourwebsite.com/folder/samplefile.csv"

it works without password. the question is: how do i script the macr
to open this csv file if the link is password protected?

thanks a bunch!
And

--
andyc
-----------------------------------------------------------------------
andycg's Profile: http://www.excelforum.com/member.php...fo&userid=3595
View this thread: http://www.excelforum.com/showthread.php?threadid=55751