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" 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" ha scritto: > > > > Can you explain with e

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 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 > =TIME(2,DO:IT,N:OW) ! Join o

$$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 = ActiveSheet.Cells

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 titles

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 environmental

$$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

$$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. Tha

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" ha scritto: > > Can you explain with example through excel workbook? > > On Fri, Mar 6, 2015 at 1:46 AM, Sa

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$$ Mail from excel using gmail

2015-03-07 Thread Ashish Bhalara
Hi Mr.Vaibhav, I tried both as you suggest, but error is still not solve. I also tried to setup ms outlook for gmail, but error receive of unencrypted connection. I follow all the setting as mentioned in website. Kindly solve my query by either send using gmail or add connection of gmail in outlook

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" wrote: > 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

$$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 t

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 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, SAVE EARTH” *

Re: $$Excel-Macros$$ Load ListBox

2015-03-07 Thread Vaibhav Joshi
Cheers!! On Tue, Mar 3, 2015 at 11:09 AM, Mihai Ghilea 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: J08/2507/1994 > >

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 < sharath.c.sambr...@gma

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 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 to > understand wha

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 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 official Faceboo

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 wrote: > Thanks > On 7 Mar 2015 14:46, "Vaibhav Joshi" 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

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

2015-03-07 Thread Mukesh Gupta
Thanks On 7 Mar 2015 14:46, "Vaibhav Joshi" 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 > wrote: > >> Dear Friedns, >> >> Kindly help me in creating a conditional formating calander just like >>

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$$ 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 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?? > > -- > Are you =EXP(E

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 wrote: > Are the file names always the same? or do they change when they > are updated? > > Do you open ALL the file

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 wrote: > Dear Friedns, > > Kindly help me in creating a conditional formating calander just like > goole calander. > > My basis needs are as follows:- > > > 1. Start Date