Hi andycg

Can you create a link to the cvs file ?
http://www.rondebruin.nl/copy7.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"andycg" wrote in message
...

Hi all -

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

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

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

thanks a bunch!
Andy


--
andycg
------------------------------------------------------------------------
andycg's Profile: http://www.excelforum.com/member.php...o&userid=35959
View this thread: http://www.excelforum.com/showthread...hreadid=557515