Import Data from HTTPS "Sri via OfficeKB.com" <u47062[ at ]uwe> 11/13/2008 2:08:54 PM Hello all I would like to import data into an xl sheet from a new web query. I am trying to use the option “Data -> Import External Data -> New Web Query”. In the “Address” field of new window popped up, I pasted my website as " https://marketdataresearch.credit-suisse.com/cs/mdr/p/d/stm/stockmarket/commodities.do " and press “Go”. It is then asking “Do you want to display the non secure items?” I clicked “Yes”. Then the website appeared and I ticked (selected) the main table and press “Import”. At the end it says “Unable to open https://marketdataresea........ Can not download the information you requested.”. Any help please…:-( Sri -- Message posted via http://www.officekb.com

Re: Import Data from HTTPS Bill Manville <Bill-Manville[ at ]msn.com> 11/13/2008 3:03:22 PM FWIW, I see the same result. It is probably not helpful to point out that you can select the content of the table on the website, Ctrl+C to copy it and then paste it into a worksheet, since you probably want to be able to refresh the query easily. I guess some websites are more amenable to querying than others, but it is not an area of expertise for me. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup