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 |
macro to open csv file on the web with password
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 |
macro to open csv file on the web with password
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 |
All times are GMT +1. The time now is 06:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com