Re: $$Excel-Macros$$ Little Macro

2015-02-05 Thread Kanwaljit Singh Dhunna
That Was Amazing Indeed ! How do you do it ! Kindly share what should be the First step in Learning VBA. I am seriously into this now... On Thu, Feb 5, 2015 at 12:19 PM, Vaibhav Joshi v...@vabs.in wrote: Yes, check this... Cheers!! On Wed, Feb 4, 2015 at 11:49 PM, Kanwaljit Singh Dhunna

Re: $$Excel-Macros$$ Little Macro

2015-02-04 Thread Kanwaljit Singh Dhunna
Hi Vaibhav, A little tweak would do wonders ! In Column F1 I have a Validation List Yes,No If I select Yes, then the result is printed, but I have selected No, then only Status is updated in Sheet but no printing is done. On Sun, Feb 1, 2015 at 4:21 PM, Vaibhav Joshi v...@vabs.in wrote: It

Re: $$Excel-Macros$$ Little Macro

2015-02-04 Thread Vaibhav Joshi
Yes, check this... Cheers!! On Wed, Feb 4, 2015 at 11:49 PM, Kanwaljit Singh Dhunna kanwal...@gmail.com wrote: Hi Vaibhav, A little tweak would do wonders ! In Column F1 I have a Validation List Yes,No If I select Yes, then the result is printed, but I have selected No, then only

Re: $$Excel-Macros$$ Little Macro

2015-02-01 Thread Kanwaljit Singh Dhunna
:)) You can see the smile ! May God bless you with Bigger Smiley Moments in Yours Life ! A curious point. Why the column C needs to be blanked *manually* before running anything ! Is there some issue in doing it via Coding ? On Sun, Feb 1, 2015 at 12:12 PM, Vaibhav Joshi

Re: $$Excel-Macros$$ Little Macro

2015-02-01 Thread Vaibhav Joshi
It gives status. Even if you dont do, excel will overwrite it. Cheers!! On Feb 1, 2015 4:13 PM, Kanwaljit Singh Dhunna kanwal...@gmail.com wrote: :)) You can see the smile ! May God bless you with Bigger Smiley Moments in Yours Life ! A curious point. Why the column C

Re: $$Excel-Macros$$ Little Macro

2015-02-01 Thread Kanwaljit Singh Dhunna
Got it Now ! Thanks a Lot ! On Sun, Feb 1, 2015 at 4:21 PM, Vaibhav Joshi v...@vabs.in wrote: It gives status. Even if you dont do, excel will overwrite it. Cheers!! On Feb 1, 2015 4:13 PM, Kanwaljit Singh Dhunna kanwal...@gmail.com wrote: :)) You can see the smile !

$$Excel-Macros$$ Little Macro

2015-01-31 Thread Kanwaljit Singh Dhunna
Dear Experts, I am assessing the following site for a pre-defined list by entering the requited two field like *PTLP10490E and 091189600169286.* https://onlineservices.tin.egov-nsdl.com/TIN/JSP/tds/linktoUnAuthorizedInput.jsp The resuting page returns No Records found. But if the result is

Re: $$Excel-Macros$$ Little Macro

2015-01-31 Thread Vaibhav Joshi
hi can you send combination of sample data which has value to create macro for sending result to printer.. On Sat, Jan 31, 2015 at 7:35 PM, Kanwaljit Singh Dhunna kanwal...@gmail.com wrote: Dear Experts, I am assessing the following site for a pre-defined list by entering the requited two

Re: $$Excel-Macros$$ Little Macro

2015-01-31 Thread Kanwaljit Singh Dhunna
Hi Vaibhav, Thanks for the reply. I found some sample values. AGRS11370C - 01026025086 AGRS11370C - 01174026662 AGRS11370C - 01026053751 Above are correct values with me. You can use any incremental number with AGRS11370C to check for incorrect values. On Sat, Jan 31, 2015 at 8:02

Re: $$Excel-Macros$$ Little Macro

2015-01-31 Thread Vaibhav Joshi
Dear Kanwaljit Singh Dhunna, Check attachment, you need to fill data in col. A B, keep col C blank b4 running macro. Check that you have set correct printer as your default printer as data will be sent directly for print. Press blue button to run Macro Macro will one Internet Explorer by one