import web query from javascript search output

**Champstaff** · 01-24-2012, 10:32 AM

Hi all

i am trying to do a 'import web query' from an intranet site.

when i perform a search the content is displayed wit javascript code.

but when i try to let excel import the data he does not find it.

does anyone have had this problem before or has tried and succeeded?

kind regards

**Kyle123** · 01-26-2012, 09:39 AM

Hi Champstaff,

This can be done, it gets a bit in depth however and you generally have to POST/GET the data yourself using code and parse the result. Unfortunately I can't look at this as it's an intranet site so I can't see the parameters that you need to send.

Sorry I can't be more use

**OlivierVB** · 06-19-2013, 11:49 AM

I had the same issu so I have do this code : it's work on Excel 2010 and 2013 :

Please Login or Register  to view this content.

**OlivierVB** · 06-19-2013, 11:55 AM

http://quickvba.blogspot.fr/2010/12/...-in-excel.html

Thanks a lot for the inspiration

**arlu1201** · 06-19-2013, 12:20 PM

OlivierVB,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

**OlivierVB** · 06-20-2013, 08:16 AM

Sorry i didn't read them

I want give my work to everybody who looking for, not only your comunity. The fact that we need an acconte for reply to an article is very good but this trick for having new member is sad

Bye