webquery

Hi All I am trying to do a web query to obtain data from a table split across multiple web pages and then insert the data onto one sheet in Excel. I have been unable to get this to work. I get the following error on the Refresh.BackgroundQuery=False line - Run-time error '1004'...

Hello Excel masters, I wish to design a time sheet macro for employees in excel using VBA using webquery. I have done most of the part (thanks to you guys for posting replies on various forums). The difficult part is after clicking login button, the actual timesheet browser opens in a new...

Even though i can write little bit VB code, I am relative beginner, hence i would like if someone could help me with this. I have set up a perfect loop, that changes cell values from named table here is code: Sub LoopThroughForEachCellInARange() Dim OutputAddress As String Dim rng As...

Hi, Need web query in Excel for the below mentioned website. http://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm When executed with excel web query ends with no data Need your kind help to resolve this Thanks Sathish

Hello, Eventhough I've used a lot of the answers posted on these forums, I've never posted before. I want to thank you for the times this site provided me with an answer. #TL;DR [intro - begin] I am trying to be innovative at my work however our IT department is not really supportive...

Hello Forum-members, I'm having some hard time to achieve my goals for finishing a project where I need to query approx 500 URLs. Well, I could do things manually for each query, but maybe someone knows a way of repating things, as the queries only differ by the URLs...I would be very greatfull...

I have made a dynamic webquery but i can not get the "deeplink" right. When i input Registers van de AFM | AFM i have to hit a link (the first one to the right in the body part of the page and then i see anotherlink: A.....Volmacht B.V. | Register financiële dienstverleners | Registers van de...

Example: I have the list of the url in a column. https://tools.xxx.com/xxx/publh/doc/DocRet?NO=60-8&Rev=&RCN=&Org_Id=1&OrgID=1 https://tools.xxx.com/xxx/publh/doc/DocRet?NO=60-1&Rev=&RCN=&Org_Id=1&OrgID=1 https://tools.xxx.com/xxx/publh/doc/DocRet?NO=60-2&Rev=&RCN=&Org_Id=1&OrgID=1 1. I have...

I am new and have searched endlessly for a couple of days to try and figure this out. Thanks in advance for any help and insight... sheets(1) has two columns; Column A is href links and Column B is FileNo Macro looks up href links on sheets(1) and utilizes a webquery to pull table...

Excel friends, I found this code, it gets the nx3 matrix stored in table done with HTML code in passwords.html, and copy all values to the active sheet starting in A1, and works fine so far: Public Sub GetValues2() Let TheURL = "http://www.samplewebsite.com/PW/passwords.html" With...

Hi, Im fairly proficient with Excel but rarely do much intense VBA. Anyway, I have been trying to create a looping macro that effectively takes a list of URL's down column A and outputs the data imported from the website into a separate column. Below is a copy of my code. Anyway, the code...

take a number from colum A (001-650) paste it into a cell and then run a webquery the trouble i have is it won't loop this is the code Sub Macro2() Dim VAL As String Do ActiveCell.Offset(1, 0).Select Range("E2").PasteSpecial Range("E1").Copy Range("G1").PasteSpecial...

hi, everyone; i am having a code to navigate my IE browser to a webpage, and then from there i want the whole webpage to copy it into my excel sheet. can anyone help me with that? webquery is not an answer! because i need to do some log-in and other functions till i get to that specific page...

I have an Excel application that used to effectively pull mutual fund data from Morningstar.com (ex. http://quote.morningstar.com/fund/f.aspx?Country=USA&pgid=hetopquote&Symbol=PTTDX) into a workbook using a standard webquery, but it no longer works because of a change in the way the webpage is...

Hello all, I am trying to create a macro that fetches information from a password protected site. I am getting error 438 but don't know how to fix it. At the moment, I am unable to automate the log in process. I tried checking the page's source code for the property but I'm not sure what...

I am trying to create a dynamic QueryTable connection. The site I am using displays a table of data as well as some filters. Everytime you change the filter, the webpage reloads with different data. I need to import these various data tables into Excel. How can I automate this via VBA? I...

I am novice of VBA. I would like to obtain the historical price data from http://q.stock.sohu.com/hk/00992/lshq.shtml. I used to use querytable, but it doesn't work. Thanks.

I would like to get some data such as historical stock price from the web. 1. What are the criteria to use the 3 function? 2. which method is the best to use? 3. website example: http://www.quamnet.com/quote.action?quoteSectionCode=pastprices&stockCode=2345...