Re: $$Excel-Macros$$ Need macro help

2015-03-07 Thread Vaibhav Joshi
Hi I have already shared one macro with file name Macro import data from multiple files - 2 one sheets in this group. Cheers!! On Thu, Mar 5, 2015 at 9:59 PM, Paul Schreiner schreiner_p...@att.net wrote: Are the file names always the same? or do they change when they are updated? Do you

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-07 Thread Vaibhav Joshi
Can you explain with example through excel workbook? On Fri, Mar 6, 2015 at 1:46 AM, Sal Sal sal72...@gmail.com wrote: I know the way to colorize a font in a vba for excel listview but to colorize the background of cell in a listview? For example the cell in row 3, column 4?? --

Re: $$Excel-Macros$$ Help Required on Conditional Formating

2015-03-07 Thread Vaibhav Joshi
Do let us know if you need any help.. Cheers!! On Sat, Mar 7, 2015 at 3:42 PM, Mukesh Gupta mukesh2k2...@gmail.com wrote: Thanks On 7 Mar 2015 14:46, Vaibhav Joshi v...@vabs.in wrote: Hi check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/ Cheers!! On Fri, Mar 6, 2015 at

Re: $$Excel-Macros$$ Excel Macro to send email.. on specific dates of the month

2015-03-07 Thread Vaibhav Joshi
Hi Andy Is it solved? On Wed, Mar 4, 2015 at 2:02 AM, AndyB anindya20042...@gmail.com wrote: Hi everyone, Hope you're well. Looking for some help with an email macro. So I have an excel sheet (similar copy attached). Once run, the macro should read from (the first sheet) Data - Column I

Re: $$Excel-Macros$$ Excel VBA Example

2015-03-07 Thread Vaibhav Joshi
Its really good!! Cheers!! On Tue, Mar 3, 2015 at 8:02 AM, Nilkanth Raval nilkanth.ra...@gmail.com wrote: Hi Friends, Find attached some examples of VBA Macro *Thanks,* *Nilkanth Raval* *+91 900 428 0 428* *+91 808 000 1620* *Think Before You Print.Consider ENVIRONMENT.* *“SAVE TREES,

$$Excel-Macros$$ Re: vba recorded macro not working

2015-03-07 Thread Mike B
Hi Mandeep, Than you very, very much your macro works great, saving me an enormous amount of time. I would like to ask you one more thing , would you be able to add code to now delete the two rows containing the two dates, Totals for *Totals for 12/11/2014 5:15:14 AM:* and *12/12/2014 5:15.

Re: $$Excel-Macros$$ Mail from excel using gmail

2015-03-07 Thread Vaibhav Joshi
Hi change port no. to 465 also you need to enable smpt / imap services for your Google account Cheers On Mar 7, 2015 5:48 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I want mail from excel using gmail ID. I want to mail from data sheet by filtering data of mail

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-07 Thread Sal Sal
Simply, colorize a cell background in Row 2 Column 5. Naturally the cell is in un a userform listview. Note: Not the colorfont bug the background color. Il 07/mar/2015 10:21 Vaibhav Joshi v...@vabs.in ha scritto: Can you explain with example through excel workbook? On Fri, Mar 6, 2015 at 1:46

Re: $$Excel-Macros$$ Mail from excel using gmail

2015-03-07 Thread Ashish Kumar
Hi, change port no. to 465 also you need to enable smpt / imap services for your Google account and, incoming server pop up - 995 Reply back if you facing problem. 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

Re: $$Excel-Macros$$ Help Required on Conditional Formating

2015-03-07 Thread Vaibhav Joshi
Hi check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/ Cheers!! On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta mukesh2k2...@gmail.com wrote: Dear Friedns, Kindly help me in creating a conditional formating calander just like goole calander. My basis needs are as follows:-

Re: $$Excel-Macros$$ Load ListBox

2015-03-07 Thread Vaibhav Joshi
Cheers!! On Tue, Mar 3, 2015 at 11:09 AM, Mihai Ghilea mihai.ghi...@metabras.ro wrote: Thank you very much. Regards, Mihai Ghilea Network administrator [image: Sigla_METABRAS_STEEL_PEOPLEmica] SC METABRAS SRL Brasov Str. Grivitei A44, RO 500182 CUI: RO6340028 RC:

Re: $$Excel-Macros$$ Outlook VBA code to send email notification on a specific date criteria

2015-03-07 Thread Vaibhav Joshi
Hi check this : http://superuser.com/questions/635094/scheduled-and-recurring-email-in-outlook http://www.mrexcel.com/forum/excel-questions/731321-run-outlook-visual-basic-applications-macro-specific-time-day.html Cheers!! On Wed, Mar 4, 2015 at 5:34 PM, sharath chandra

$$Excel-Macros$$ Mail from excel using gmail

2015-03-07 Thread Ashish Bhalara
Dear experts, I want mail from excel using gmail ID. I want to mail from data sheet by filtering data of mail receivers. I find the code using google search as mention below but it's error occur of The transport failed to connect to the server. during the running code. Kindly help me regarding

Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

2015-03-07 Thread Vaibhav Joshi
Check this.. Cheers!! On Fri, Mar 6, 2015 at 5:04 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Eugene, PFA, Filter your data then after hit the button 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

Re: $$Excel-Macros$$ Re: Need macro help

2015-03-07 Thread Prashant Pednekar
Dear Mandeep, This was wonderful file. I used it for one of my project. However required one improvement. Tried to see the code, but it is lock hence. need your guidance. - I need to select entire data in sheet. currently it is not taking data after black rows. - The color and formating becomes

Re: $$Excel-Macros$$ Help Required on Conditional Formating

2015-03-07 Thread Mukesh Gupta
Thanks On 7 Mar 2015 14:46, Vaibhav Joshi v...@vabs.in wrote: Hi check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/ Cheers!! On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta mukesh2k2...@gmail.com wrote: Dear Friedns, Kindly help me in creating a conditional formating

$$Excel-Macros$$ Re: Excel Macro to send email.. on specific dates of the month

2015-03-07 Thread AndyB
Hi Vabz Nope, grateful if you can help me. On Tuesday, 3 March 2015 20:32:36 UTC, AndyB wrote: Hi everyone, Hope you're well. Looking for some help with an email macro. So I have an excel sheet (similar copy attached). Once run, the macro should read from (the first sheet) Data -

Re: $$Excel-Macros$$ Mail from excel using gmail

2015-03-07 Thread Ashish Kumar
I think your internet connection is slow. -- 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

Re: $$Excel-Macros$$ Mail from excel using gmail

2015-03-07 Thread Ashish Bhalara
I checked it, that's not a problem, data browsing and downloading is doing smoothly. On Sun, Mar 8, 2015 at 8:48 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: I think your internet connection is slow. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's

Re: $$Excel-Macros$$ Mail from excel using gmail

2015-03-07 Thread Ashish Bhalara
Hi.Mr.Ashish Kumar, I tried of changing port number, incoming server popup and also enable smtp/imap service in google account, but still receive error of connection failure. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread

$$Excel-Macros$$ Re: vba recorded macro not working

2015-03-07 Thread Mandeep Baluja
it's so easy paste this code in module. i have highlighted the line in bold where change is done. Remember one thing once these lines will be deleted it can traverse back. Sub Test() With Application .ScreenUpdating = False .DisplayAlerts = False End With Dim lr As Long lr =

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-07 Thread Sal Sal
Bug* but Il 07/mar/2015 17:09 Sal Sal sal72...@gmail.com ha scritto: Simply, colorize a cell background in Row 2 Column 5. Naturally the cell is in un a userform listview. Note: Not the colorfont bug the background color. Il 07/mar/2015 10:21 Vaibhav Joshi v...@vabs.in ha scritto: Can