Check this one...its fully automated now, you need to click on button to run macro & select range, rest things will be taken care by VBA.
Q- can you please explain that how you did this??? I used IE VBA automation to navigate webpage & fetching data from it using HTML underlying it. Refer this for more learning: http://www.wiseowl.co.uk/blog/s393/scrape-website-html.htm Q - I can see that you have written some VB programming and macros, but have you also used the web query / other things? No i didnt used web query, since webpage has scripts which run on pressing tab/on click. Cheers!! +++++ *I did not do this for you. God is here working through me for you.* On Thu, Oct 30, 2014 at 1:17 AM, Bajrang Sharma <sharma....@gmail.com> wrote: > OMG, > > I saw your mail on my mobile and was excited to see the file. And happy to > see that the output is what I wanted… > > > > Thanks a lot……… a lot….. > > > > But can you please explain that how you did this??? I can see that you > have written some VB programming and macros, but have you also used the web > query / other things? > > > > I have one more site with the similar work.. and want to do that by my > own… > > Please help… > > > > Thanks again.. > > BS > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi > *Sent:* Thursday, 30 October, 2014 12:11 AM > *To:* excel-macros@googlegroups.com > *Cc:* Rajan Verma > *Subject:* Re: $$Excel-Macros$$ Automatic update excel file from website > > > > Check this.... > > > > you will need to press enter when error appears or just disble IE > dialogues. > > > > Cheers!! > > > +++++ > > *I did not do this for you. God is here working through me for you.* > > > > On Sat, Oct 25, 2014 at 2:17 PM, B Sharma <sharma....@gmail.com> wrote: > > Dear Excel Gurus, > > I am trying to update my excel sheet which contains the TIN number of some > of the registered tax payers with their contact details and address. I can > do it manually by putting the TIN number in the below mentioned website and > then copy paste the details in the excel file. > > > > But is there any way to do it automatically with the help of macros / > VBA??? > > > > > https://www.odishatreasury.gov.in/echallan/ChallanSubmission.do?deptcode=COM > > > > In the above mentioned website if you put the TIN number (for > e.g. 21031209766) then it will give the details and can I make it an > automatically copy paste the data in my excel sheet??? > > > > Can it be possible with web query??? > > > > Please help .. > > > > BS > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/X00xbnfdjyE/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > > > ------------------------------ > <http://www.avast.com/> > > This email has been checked for viruses by Avast antivirus software. > www.avast.com > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Get TIN no.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
