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 <mailto: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 <mailto:excel-macros+unsubscr...@googlegroups.com> . To post to this group, send email to excel-macros@googlegroups.com <mailto: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 <mailto:excel-macros+unsubscr...@googlegroups.com> . To post to this group, send email to excel-macros@googlegroups.com <mailto: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. --- This email has been checked for viruses by Avast antivirus software. http://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.
