Re: $$Excel-Macros$$ Re: Amendment (With exception) on the the created vendor macro file

2014-11-25 Thread Laxmanan M
Dear Anil, I have attached 2 attachments in the first post of the same thread.one macro file and another one word document.please have a look in the same post. Kind regards, Lax -- 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

Re: $$Excel-Macros$$ Re: Amendment (With exception) on the the created vendor macro file

2014-11-25 Thread Laxmanan M
PLs have a look anyone? Lax On Tuesday, November 25, 2014 3:45:17 PM UTC+5:30, Laxmanan M wrote: Dear Anil, I have attached 2 attachments in the first post of the same thread.one macro file and another one word document.please have a look in the same post. Kind regards, Lax

Re: $$Excel-Macros$$ Re: Amendment (With exception) on the the created vendor macro file

2014-11-25 Thread Laxmanan M
Can anyone please have a look as I have done with the code.Need help on the amendment part as am fearing that code will break if I make amendment with out getting guidance from the experts here. Lax -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Re: Amendment (With exception) on the the created vendor macro file

2014-11-25 Thread Laxmanan M
Can anyone please have a look? Lax On Tuesday, November 25, 2014 8:52:45 PM UTC+5:30, Laxmanan M wrote: Can anyone please have a look as I have done with the code.Need help on the amendment part as am fearing that code will break if I make amendment with out getting guidance from

$$Excel-Macros$$ Re: Macro for send mail

2014-11-24 Thread Laxmanan M
the list of of users one by one. here the email column is For Each cell In Range(AJ2:AJ300) Regards, Mandeep Baluja Excel Specialist. https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Saturday, November 22, 2014 6:52:37 PM UTC+5:30, Laxmanan M

$$Excel-Macros$$ Re: Amendment (With exception) on the the created vendor macro file

2014-11-24 Thread Laxmanan M
can any one pls? On Monday, November 24, 2014 7:44:09 PM UTC+5:30, Laxmanan M wrote: Hi All, I have done with the macro code for the Vendor file validation.But i need to make some amendments in the created code.The amendments requirement has been placed in the attached word document. Also

$$Excel-Macros$$ Re: Macro for send mail

2014-11-22 Thread Laxmanan M
End Sub Regards, Mandeep Baluja Excel Specialist. https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Thursday, November 20, 2014 10:39:07 PM UTC+5:30, Laxmanan M wrote: hi All, Please see the attached file as requested. What the outcomes

Re: $$Excel-Macros$$ Re: Macro for send mail

2014-11-21 Thread Laxmanan M
at 11:53 PM, Laxmanan M laxfly...@gmail.com javascript: wrote: Am not gud at macros and am in learning phase.But i have been assigned to complete this task.So am roaming around the web.Please paul help me to be done this macro code lax On Thursday, November 20, 2014 10:39:07

$$Excel-Macros$$ Re: Macro for send mail

2014-11-20 Thread Laxmanan M
Am using Normal MS Outlook application for sending mails.. Thanks, Lax On Thursday, November 20, 2014 10:39:07 PM UTC+5:30, Laxmanan M wrote: hi All, Please see the attached file as requested. What the outcomes I’m after are requested below. When column AJ (Name of successful

$$Excel-Macros$$ Re: Macro for send mail

2014-11-20 Thread Laxmanan M
Am not gud at macros and am in learning phase.But i have been assigned to complete this task.So am roaming around the web.Please paul help me to be done this macro code lax On Thursday, November 20, 2014 10:39:07 PM UTC+5:30, Laxmanan M wrote: hi All, Please see the attached file

Re: $$Excel-Macros$$ Mark Pass/Fail using excel vba macro

2014-11-15 Thread Laxmanan M
is here working through me for you.* On Wed, Nov 12, 2014 at 4:52 PM, Laxmanan M laxfly...@gmail.com javascript: wrote: Thanks vabz, How to achieve the second macro using vba.I tried here but am failing when trying to fetch details.. Lax -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

Re: $$Excel-Macros$$ Mark Pass/Fail using excel vba macro

2014-11-12 Thread Laxmanan M
Thanks vabz, How to achieve the second macro using vba.I tried here but am failing when trying to fetch details.. Lax -- 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 @

$$Excel-Macros$$ Re: Mark Pass/Fail using excel vba macro

2014-11-11 Thread Laxmanan M
Guys ..Kindly,can you please help me or give me root to solve this problem. Waiting for your valuable comments. Lax On Tuesday, November 11, 2014 1:27:54 PM UTC+5:30, Laxmanan M wrote: Hi All, Need help to complete my task using vba.Thanks in advance..Attaching the workbook here

Re: $$Excel-Macros$$ Load data's Update using vba

2014-10-31 Thread Laxmanan M
Dear Paul, I know vba editor and handling..please provide me an advice..for this request.. Kind regards, Lax On Thursday, October 30, 2014 6:03:44 PM UTC+5:30, Laxmanan M wrote: Dear Paul, Yes you are right..You got the point..as im new to this type of formula's..Either it may

Re: $$Excel-Macros$$ Load data's Update using vba

2014-10-30 Thread Laxmanan M
* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Laxmanan M laxfly

Re: $$Excel-Macros$$ Issue while using vba for pivot table data's

2014-10-27 Thread Laxmanan M
* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Laxmanan M laxfly

Re: $$Excel-Macros$$ Issue while using vba for pivot table data's

2014-10-27 Thread Laxmanan M
* - *From:* Laxmanan M laxfly...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *Cc:* schrein...@att.net javascript: *Sent:* Monday, October 27, 2014 7:26 AM *Subject:* Re: $$Excel-Macros$$ Issue while using vba for pivot table

Re: $$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-26 Thread Laxmanan M
containing file will get opened too + *I did not do this for you. God is here working through me for you.* On Sun, Oct 26, 2014 at 11:27 AM, Laxmanan M laxfly...@gmail.com javascript: wrote: Dear Vabz, Thanks for this challenging task..I ran this in my machine and it is working

$$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-25 Thread Laxmanan M
Dear guru's, Still am waiting for your valuable comments..pls help me. Regards, Lax -- 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

$$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-25 Thread Laxmanan M
Pls help me.. -- 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,

Re: $$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-25 Thread Laxmanan M
Hi pramod and vabz, Thanks for the help. Here I have give the file sample datais the data file and we can apply the code in the same file.the format file is just the output file data format means the output file should have the data's in the same format of the format.this file should save as

Re: $$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-25 Thread Laxmanan M
in my code you may need to amend it as you needed... Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Oct 26, 2014 at 12:15 AM, Laxmanan M laxfly...@gmail.com javascript: wrote: Hi pramod and vabz, Thanks for the help. Here I have give

$$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-24 Thread Laxmanan M
Hi People, Please find attached the sample data, output file format and the format of the output file. I have created names for all columns like P.APR, I.APR etc for all months. In the output file, the first 2 column values are coming from the Config sheet and other from Data Sheet. In

$$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-24 Thread Laxmanan M
Dear master's, Kindly help me to resolve my issue mentioned in the post Lax -- 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,

$$Excel-Macros$$ New Member

2014-10-23 Thread Laxmanan M
Hi There, Am new to this forum and i want to learn things in VBA..Had a look on this forum for past one month..I really like it and impressed a lot.Also have read the forum rules before i enter into this world. Quick Question..Hope the gurus here in the forum help me to pick the better

Re: $$Excel-Macros$$ New Member

2014-10-23 Thread Laxmanan M
Dear Paul, Thanks for the response.my kind regards to you..yeah I was trying to learn my own..I got some ideas about macros..its my passion to learn vba.but while searching forum most of the codes looks like very difficult.I'm confident..but need your guidance to achieve this ..I want to pick