Dont know about Superman but I m definitely Salman Khan's fan !! ;))) Cheers!!
On Sun, Feb 8, 2015 at 10:00 PM, B Sharma <sharma....@gmail.com> wrote: > Hii Vaibhav, > > Happy to know that you are a CA too. That means you are a superman in > accounting line. Because if a person is qualified CA and have good hands on > excel/vba, that means he can do 8 hrs work in just 1 hr. > > I am neither a CA nor a VBA expert but have good hands on excel, little > bit of VBA & advance formulas and this helps me a lot in my day to day > working. and minimized my work. > > Anyways, you earlier vba helped me a lot. > Thanks man. > > Thanks & Regards, > BS > > On Friday, February 6, 2015 at 3:00:41 PM UTC+5:30, Vabz wrote: >> >> By profession i am in to CA too, n it is once personal interest n desire >> to learn, since VBA is magical tool for everyone & if you expand your >> knowledge it can be boon to CA office. >> >> Also believe me those not belonging to core VBA are also replying & >> solving Queries at par with VBA experts.. >> >> Yes i did had hands on it & I have trial ready with me, wanted to see >> your work before posting... >> >> Appreciate your positive response! >> >> Cheers!! >> >> >> On Fri, Feb 6, 2015 at 2:51 PM, Kanwaljit Singh Dhunna <kanw...@gmail.com >> > wrote: >> >>> Hi Vaibhav, Thanks for the Concern ! >>> >>> I understand everyone here is engaged in some profession but even then >>> Some people like you spare time out of their busy schedule to help people >>> out of trouble. I am a CA by profession and can do some good things in >>> Excel but not in VBA. I tried learning VBA at some centres but none imparts >>> VBA in the traditional sense of the learning. Also bought two books, one by >>> John Walkenbach and other by Bill Jelen. Read some 150 pages of it. Gained >>> some knowledge but yet I do not feel confident enough to deal with Web >>> applications. >>> >>> Due to high stress of TDS returns now a days, I often come to >>> Excel-Macros groups to find helps on issues I cannot deal with. These >>> returns consuming a major portion of available time, even family time. So >>> honestly even though I long to do experiments in VBA, I couldn't spare time >>> yesterday to work on that. I understand that If I can't spend time on my >>> issues then why anyone else should be interested in it. That's why I don't >>> even requested again for anyone to solve it. I would certainly give it a >>> shot, Not sure with present skills I can conclude it, but certainly there >>> won't be any lack of efforts. >>> >>> Have you tried your hands on it ? >>> >>> On Fri, Feb 6, 2015 at 2:20 PM, Vaibhav Joshi <v...@vabs.in> wrote: >>> >>>> Hi Kanwaljit >>>> >>>> Any luck? >>>> >>>> On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi <v...@vabs.in> wrote: >>>> >>>>> yes, you an do it... >>>>> >>>>> >>>>> >>>>> On Thu, Feb 5, 2015 at 5:02 PM, Kanwaljit Singh Dhunna < >>>>> kanw...@gmail.com> wrote: >>>>> >>>>>> Ok Vaibhav. Even though I have very little idea about VB (Just read >>>>>> the codes and try to understand them) I will give it a shot. >>>>>> >>>>>> On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi <v...@vabs.in> wrote: >>>>>> >>>>>>> i want you to work on present requirement... >>>>>>> >>>>>>> On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna < >>>>>>> kanw...@gmail.com> wrote: >>>>>>> >>>>>>>> Ok Sir, I will do that. >>>>>>>> >>>>>>>> I hope I am clear on my present question. >>>>>>>> >>>>>>>> On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi <v...@vabs.in> wrote: >>>>>>>> >>>>>>>>> You want to learn VBA then start modifying last code which i sent >>>>>>>>> to you to accommodate it.. >>>>>>>>> >>>>>>>>> Start & letus know when you get error.. >>>>>>>>> >>>>>>>>> Cheers!! >>>>>>>>> >>>>>>>>> >>>>>>>>> On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna < >>>>>>>>> kanw...@gmail.com> wrote: >>>>>>>>> >>>>>>>>>> Hi Experts, >>>>>>>>>> >>>>>>>>>> I have attached a sheet. >>>>>>>>>> I wish there could be a macro which when run >>>>>>>>>> --assess the website given in column A1, >>>>>>>>>> --copy the value given in cell A4 in the input box >>>>>>>>>> --wait for me to enter the Captcha MANUALLY (as I have learnt >>>>>>>>>> that it is quite a tedious process via code) >>>>>>>>>> --copy the resulting values and paste them into the required >>>>>>>>>> columns in the sheet (if the input value is invalid then only Mark >>>>>>>>>> INVALIDPAN in column B) >>>>>>>>>> --copy and value given in Next Cell i.e., A5 and so on till the >>>>>>>>>> List is exhausted. >>>>>>>>>> >>>>>>>>>> Hope I am clear ! >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Sincere Regards >>>>>>>>>> CA Kanwaljit Singh Dhunna >>>>>>>>>> +91-987 6739 911 >>>>>>>>>> +91-950 1031 007 >>>>>>>>>> P*Please don't print this e-mail unless you really need to.* >>>>>>>>>> *IF U LOSE, DON'T LOSE THE LESSON.* >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> 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...@googlegroups.com. >>>>>>>>>> To post to this group, send email to excel-...@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...@googlegroups.com. >>>>>>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>>>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Sincere Regards >>>>>>>> CA Kanwaljit Singh Dhunna >>>>>>>> +91-987 6739 911 >>>>>>>> +91-950 1031 007 >>>>>>>> P*Please don't print this e-mail unless you really need to.* >>>>>>>> *IF U LOSE, DON'T LOSE THE LESSON.* >>>>>>>> >>>>>>>> -- >>>>>>>> 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...@googlegroups.com. >>>>>>>> To post to this group, send email to excel-...@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...@googlegroups.com. >>>>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Sincere Regards >>>>>> CA Kanwaljit Singh Dhunna >>>>>> +91-987 6739 911 >>>>>> +91-950 1031 007 >>>>>> P*Please don't print this e-mail unless you really need to.* >>>>>> *IF U LOSE, DON'T LOSE THE LESSON.* >>>>>> >>>>>> -- >>>>>> 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...@googlegroups.com. >>>>>> To post to this group, send email to excel-...@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...@googlegroups.com. >>>> To post to this group, send email to excel-...@googlegroups.com. >>>> Visit this group at http://groups.google.com/group/excel-macros. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Sincere Regards >>> CA Kanwaljit Singh Dhunna >>> +91-987 6739 911 >>> +91-950 1031 007 >>> P*Please don't print this e-mail unless you really need to.* >>> *IF U LOSE, DON'T LOSE THE LESSON.* >>> >>> -- >>> 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...@googlegroups.com. >>> To post to this group, send email to excel-...@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. > -- 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.
