$$Excel-Macros$$ Web query to get exam result for all students from university website

2016-01-16 Thread Suvadip Paul
I have a list of Roll nos of 1000 students in a excel sheet. After publication of exam result in the website, we used to put the roll nos in the input textbox of the website and get the corresponding result which is then copied and pasted in a file. The same procedure is adopted for the all s

$$Excel-Macros$$ Web query

2014-09-03 Thread Παναγιώτης Σκούρτης
hi i am new to this forum i have a litle problem to ask for solution i have this macro to search for models from this site but returns to me all the page of the product my question is there something to add in this macro to search a certain div class in this page to return me only the price or

Re: $$Excel-Macros$$ Web Query Issues

2013-11-01 Thread Bill Q
glegroups.com ] *On Behalf Of *Bill Q > *Sent:* Saturday, November 02, 2013 3:12 AM > *To:* excel-...@googlegroups.com > *Subject:* $$Excel-Macros$$ Web Query Issues > > > > Hi, > > > > Not sure if this is the proper forum to post this in, but I will give it a

RE: $$Excel-Macros$$ Web Query Issues

2013-11-01 Thread Ravinder
What information you want to get From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bill Q Sent: Saturday, November 02, 2013 3:12 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Web Query Issues Hi, Not sure if this is the proper

Re: $$Excel-Macros$$ Web Query Issues

2013-11-01 Thread Bill Q
Very doubtful Sam thousands of people go on this site daily. It's been like this for a good 2-3 weeks. My anti-virus is not picking this up at all. The message seems to be generated on their end. I did a Google search on ajax.googleapis.com/**ajax/libs/query/1.8.3/querry. **min

Re: $$Excel-Macros$$ Web Query Issues

2013-11-01 Thread Sam Mathai Chacko
Any possibility that there's something malicious about the site now? Probably got recently infected, and your anti-virus program might be disallowing any potentially harmful script(s) to run. On Sat, Nov 2, 2013 at 3:11 AM, Bill Q wrote: > Hi, > > Not sure if this is the proper forum to post th

$$Excel-Macros$$ Web Query Issues

2013-11-01 Thread Bill Q
Hi, Not sure if this is the proper forum to post this in, but I will give it a shot. Recently, a website that I frequently perform web queries on must have gone through some sort of change where I am getting the same errors on multiple computers in both Excel 2003 & 2007. I can't make heads

Re: $$Excel-Macros$$ Web Query Problem / Need Small Macro

2012-11-25 Thread Anoop K Sharma
I can see the connection string in Connection tab which refreshes in every one minute. The changes you demand are needed to be written in VBA script as this one is system generated which needs modification. Make a new QT for your connection. - Regards, Anoop Sr. Developer -- Join official Facebo

$$Excel-Macros$$ Web Query Problem / Need Small Macro

2012-11-24 Thread qcan
Hi Guys, Find attached a simple web query that is currently being refreshed every minute. For the life of me, I am unable to figure out how to have new "refreshed" data placed directly below the previous data. In anycase, I realized that this would not solve all my issues. Here is what I am ult

Re: $$Excel-Macros$$ Web query return with no data....

2010-01-31 Thread saurabhn
http://www.crisil.com/credit-ratings-risk-assessment/outstanding-ratings-list.jsp?qry=S this is the link from where i want to import the data On Jan 31, 11:14 pm, Dilip Pandey wrote: > Dear Saurabh, > > Just a little explanation on this:- > If you have a database, suppose MS Access Database havi

Re: $$Excel-Macros$$ Web query return with no data....

2010-01-31 Thread saurabhn
http://www.crisil.com/credit-ratings-risk-assessment/outstanding-ratings-list.jsp?qry=S this is the link from where i want to import the data On Jan 31, 7:34 pm, mahesh parab wrote: > Hi > > Can you send link of website & the data which want to import. > > On 1/30/10, saurabhn wrote: > > > > >

Re: $$Excel-Macros$$ Web query return with no data....

2010-01-31 Thread Dilip Pandey
Dear Saurabh, Just a little explanation on this:- If you have a database, suppose MS Access Database having sales details of Mon to Fri and you used to query this database from a query (may be Microsoft Query or SQL etc) and someday you quered this database for Sat or Sun data, then you might get

Re: $$Excel-Macros$$ Web query return with no data....

2010-01-31 Thread mahesh parab
Hi Can you send link of website & the data which want to import. On 1/30/10, saurabhn wrote: > > While importing data from 1 site > got msg like dis > > > This Web query returned no data. To modify the query, click OK, click > the name of the external data range in the name box on the formula >

$$Excel-Macros$$ Web query return with no data....

2010-01-30 Thread saurabhn
While importing data from 1 site got msg like dis This Web query returned no data. To modify the query, click OK, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar. can any 1 help me out --

$$Excel-Macros$$ Web query

2008-12-31 Thread Souravmay Das
hi, I am trading using a local broker. but i wonder how can i automate lot of my work using web query by scrapping the website. So to solve my problem i have few quick question : 1 . Can we hold the http session with web query( very basic question? i m a programmer but never worked on VBA !!) 2