Fwd: $$Excel-Macros$$ Automatic update excel file from website
FYI + *I did not do this for you. God is here working through me for you.* -- Forwarded message -- From: Vaibhav Joshi Date: Sat, Nov 1, 2014 at 3:17 PM Subject: Re: $$Excel-Macros$$ Automatic update excel file from website To: "excel-macros@googlegroups.com" check this... cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Oct 31, 2014 at 8:42 PM, Vaibhav Joshi wrote: > Though it looks simple, but not the same! I will try & send you working > file for MCA too. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Fri, Oct 31, 2014 at 2:30 PM, Bajrang Sharma > wrote: > >> Dear Friend, >> >> This works smoothly. I am really thankful to you. >> >> >> >> Thanks for sharing the link, I tried a lot to understand the logic / ways >> to do this by my own, but I failed as I don’t have programming knowledge. >> >> >> >> >> I want to learn this because I have to extract the data from other >> websites which have different options.. >> >> >> I am sharing one more file which have to extract data from mca website. >> >> Can you please please do the same programming in this file too... >> >> >> Thanks & Regards, >> >> BS >> >> >> >> >> >> >> >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi >> *Sent:* Thursday, 30 October, 2014 8:02 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Automatic update excel file from website >> >> >> >> Cheers Bro.. >> >> >> + >> >> *I did not do this for you. God is here working through me for you.* >> >> >> >> On Thu, Oct 30, 2014 at 7:08 PM, Ashish Kumar >> wrote: >> >> Hi Vaibhav Bhai, >> >> >> >> It's great.!! >> >> >> >> >> >> Regards >> >> Ashish >> >> -- >> 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 &
Re: $$Excel-Macros$$ Automatic update excel file from website
Hi Vaibhav Bhai, Working according to the requirement. Great!!! -- 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.
Re: $$Excel-Macros$$ Automatic update excel file from website
check this... cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Oct 31, 2014 at 8:42 PM, Vaibhav Joshi wrote: > Though it looks simple, but not the same! I will try & send you working > file for MCA too. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Fri, Oct 31, 2014 at 2:30 PM, Bajrang Sharma > wrote: > >> Dear Friend, >> >> This works smoothly. I am really thankful to you. >> >> >> >> Thanks for sharing the link, I tried a lot to understand the logic / ways >> to do this by my own, but I failed as I don’t have programming knowledge. >> >> >> >> >> I want to learn this because I have to extract the data from other >> websites which have different options.. >> >> >> I am sharing one more file which have to extract data from mca website. >> >> Can you please please do the same programming in this file too... >> >> >> Thanks & Regards, >> >> BS >> >> >> >> >> >> >> >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi >> *Sent:* Thursday, 30 October, 2014 8:02 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Automatic update excel file from website >> >> >> >> Cheers Bro.. >> >> >> + >> >> *I did not do this for you. God is here working through me for you.* >> >> >> >> On Thu, Oct 30, 2014 at 7:08 PM, Ashish Kumar >> wrote: >> >> Hi Vaibhav Bhai, >> >> >> >> It's great.!! >> >> >> >> >> >> Regards >> >> Ashish >> >> -- >> 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. >
Re: $$Excel-Macros$$ Automatic update excel file from website
Though it looks simple, but not the same! I will try & send you working file for MCA too. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Oct 31, 2014 at 2:30 PM, Bajrang Sharma wrote: > Dear Friend, > > This works smoothly. I am really thankful to you. > > > > Thanks for sharing the link, I tried a lot to understand the logic / ways > to do this by my own, but I failed as I don’t have programming knowledge. > > > > > I want to learn this because I have to extract the data from other > websites which have different options.. > > > I am sharing one more file which have to extract data from mca website. > > Can you please please do the same programming in this file too... > > > Thanks & Regards, > > BS > > > > > > > > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi > *Sent:* Thursday, 30 October, 2014 8:02 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Automatic update excel file from website > > > > Cheers Bro.. > > > + > > *I did not do this for you. God is here working through me for you.* > > > > On Thu, Oct 30, 2014 at 7:08 PM, Ashish Kumar > wrote: > > Hi Vaibhav Bhai, > > > > It's great.!! > > > > > > Regards > > Ashish > > -- > 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. > > -- > 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 a
RE: $$Excel-Macros$$ Automatic update excel file from website
Dear Friend, This works smoothly. I am really thankful to you. Thanks for sharing the link, I tried a lot to understand the logic / ways to do this by my own, but I failed as I don’t have programming knowledge. I want to learn this because I have to extract the data from other websites which have different options.. I am sharing one more file which have to extract data from mca website. Can you please please do the same programming in this file too... Thanks & Regards, BS *From:* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi *Sent:* Thursday, 30 October, 2014 8:02 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Automatic update excel file from website Cheers Bro.. + *I did not do this for you. God is here working through me for you.* On Thu, Oct 30, 2014 at 7:08 PM, Ashish Kumar wrote: Hi Vaibhav Bhai, It's great.!! Regards Ashish -- 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. -- 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. MCA - Data.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Automatic update excel file from website
Cheers Bro.. + *I did not do this for you. God is here working through me for you.* On Thu, Oct 30, 2014 at 7:08 PM, Ashish Kumar wrote: > Hi Vaibhav Bhai, > > It's great.!! > > > Regards > Ashish > > -- > 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.
Re: $$Excel-Macros$$ Automatic update excel file from website
Hi Vaibhav Bhai, It's great.!! Regards Ashish -- 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.
Re: $$Excel-Macros$$ Automatic update excel file from website
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 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 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. > > NOT
RE: $$Excel-Macros$$ Automatic update excel file from website
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 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 Advic
Re: $$Excel-Macros$$ Automatic update excel file from website
to run macro, click blue button, on prompt select range with TIN no. and press OK + *I did not do this for you. God is here working through me for you.* On Thu, Oct 30, 2014 at 12:11 AM, Vaibhav Joshi wrote: > 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 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 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.
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 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 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
Re: $$Excel-Macros$$ Automatic update excel file from website
Share the with excel file ... which text / details you want extract... On Sat, Oct 25, 2014 at 2:17 PM, B Sharma 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. -- PramodSingh -- 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.
$$Excel-Macros$$ Automatic update excel file from website
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.
