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

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

Stupid answer from me


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



"Ron de Bruin" wrote in message ...
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