macro to open csv file on the web with password

[andycg]

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

[Ron de Bruin]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Ron de Bruin]

Stupid answer from me


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



"Ron de Bruin" <[email protected]> wrote in message news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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
>>
>
>