Re: $$Excel-Macros$$ Send Email from Excel to Multiple Addresses
Hello Friends, It's really gr8 and useful. Thnxs Ashish. Anyone can help me, if I want to send a single msg/mail to more than one person through excel, how can i do this. I mean i want to mark more than one person in "To" and more than one person under "Cc" category. Is it possible through Excel, if yes, how? - Manish On Dec 16, 4:30 pm, ashish koul wrote: > hi > > check the attchment > > i made it for my own purpose it send the email to all the email ids > mentioned in col b > > with different attachmnet as in col e and col f > > you can romve the attchment option and can also add more attchament > options > > rember attachment cols e and f and col b can not be blank > > and you can amend the code as per your requirement > > Thanks > > On Tue, Dec 15, 2009 at 11:17 PM, Hiren Sheth wrote: > > > > > Hi, > > > I have just started VB programming. I have gone through your query & I > > think if you change the code to .To = Sheets("Email").Range("A2").Value then > > mail will be sent to e-mail ID mention in cell A2. I do not know how to send > > mail if you have more than one emial addrees. But I think this may help you. > > > Regards > > Hiren > > > -Original Message- > > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > > On Behalf Of JMac > > Sent: Tuesday, December 15, 2009 8:21 PM > > To: MS EXCEL AND VBA MACROS > > Subject: $$Excel-Macros$$ Send Email from Excel to Multiple Addresses > > > I have a excel 2003 file that contains the following code to send a > > email message to several people. > > > Sub SendMail() > > > Dim OL As Object, MailSendItem As Object > > > Set OL = CreateObject("Outlook.Application") > > Set MailSendItem = OL.CreateItem(olMailItem) > > > With MailSendItem > > .Subject = "Test" > > .Body = "Testing 1,2,3" > > .To = "b...@bob.com; s...@sam.com" > > .Send > > End With > > > End Sub > > > I would prefer to get the addresses from a list on another sheet > > instead of typing each one in the above. I've tried the following, > > .To = Sheets("Email").Range("List") > > > But I get an automation error when I run it. > > > Any suggestions ? > > > Thanks > > > -- > > > ------ > > Some important links for excel users: > > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > >http://www.excelitems.com > > 2. Excel tutorials athttp://www.excel-macros.blogspot.com > > 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com > > 4. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > If you find any spam message in the group, please send an email to: > > Ayush Jain @ jainayus...@gmail.com or > > Ashish Jain @ 26may.1...@gmail.com > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 6,500 subscribers worldwide and receive many nice notes about > > the learning and support from the group. Our goal is to have 10,000 > > subscribers by the end of 2009. Let friends and co-workers know they can > > subscribe to group at > >http://groups.google.com/group/excel-macros/subscribe > > This message is for the named person's use only. It may contain > > confidential, proprietary or legally privileged information. No > > confidentiality or privilege is waived or lost by any mis-transmission. If > > you receive this message in error, please immediately > > delete it and all copies of it from your system, destroy any hard copies of > > it and notify the sender. You must not, directly or > > indirectly, use, disclose, distribute, print, or copy any part of this > > message if you are not the intended recipient. > > Viteos Capital Market Services Ltd.and any of its subsidiaries each reserve > > the right to monitor all e-mail communications through > > its networks. Any views expressed in this message are those of the > > individual sender, except where the message states otherwise and > > the sender is authorized to state them to be the views of any such entity > > > -- > > > ------ > > Some important links for excel users: > > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > >http://www.excelitems.com > > 2. Excel tutorials athttp://www.excel-macros.blogspot.com > > 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com > > 4. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > If you find any spam message in the group, please send an email to: > > Ayush Jain @ jainayus...@gmail.com or > > Ashish Jain @ 26may.1...@gmail.com > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 6,500 subscribers worldwide and receive many nice notes about > > the learning and support from the group. Our goal is to have 10,000 > > subscribers by the end of 2009.
$$Excel-Macros$$ Help in formula - Trace Dependents
Hello Friends, I am facing a problem in MS excel. I have one workbook with more than 10 worksheets. I had create a master sheet in which I have more than 200 rows contains the information pertains to different – different worksheets. All worksheets are linked with master sheet. Each row figure of master sheet is linked only with one worksheet. My problem is, I want to write the name of worksheet and row number in master sheet, in which that particular row figure is linked. Is it possible through any formula, if you please help me. Thanks in advance. Regds, Manish -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Spelling Check option in user form
Hello friends, Any one tell me how i can use spelling check option in user form? I devloped one macro in which i want to use spelling check option user form. Is it possible? Please assist me. Thanks in advance. Regds, Manish -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Worksheet Name as defined in master sheet
Dear Excel Masters, I need your help. I want to insert a new worksheet through macro and want to change that sheet name with pre-defined name in master sheet. Whatever name i defined in mastersheet, macro will insert that worksheet in my work book. Further, if work book have that name worksheet than macro will indicate that "The same name is as another sheet" and user can define a new name through user box for new worksheet. I think it is possible through macro. Please help me. Thanks in advance. Regds, Manish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Delete blank row through macro
Dear Masters, I want to create a macro through which i want to move a copy of active sheet and after that i want to run my macro in duplicate sheet. Macro will delete the row based on following criteria. 1. Blank column A: If in column A the cell is blank macro will delete the entire row. 2. Specific Name for example "Manish", if in column ‘A’ name Manish is appeared than macro will delete the row. Hope my text is self explanatory and it’s possible to set two criteria to delete row. Please help me, this will save my lot of time and will make easy my daily activity. Thanks in advance. - Manish Pansari -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
$$Excel-Macros$$ Translate through Macro & Google Translate tool
Dear Excel Guru's, I want to create an macro, by that in a single click, my excel sheet will get translated in whatever language i will select. Is it possible through macro. give me some hint so i will develop some code and will take further help from your side. Regds, Manish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: PDF password CRACKER
Hi everyone.. Any one can provide me the password crecker for MS Office/Excel. Actually I forget my own MS file password. :( - Manish On Oct 1, 3:08 pm, Anish Shrivastava wrote: > Hi Ram, > > Actually I got tht passware from my frnd. It works nicely to crack MS Office > passwords (I tried on excel files and and it gives you the alternate > password within seconds) but for now I m trying to crack password for the > pdf document which Vivek has sent me...it's running on..let's c whether it's > working for pdf too > > I will ask my frnd to share the setup file of this passware and will send it > across to our group. > > Cheers!! > ANISH > > On Thu, Oct 1, 2009 at 1:23 PM, Ramkrishna Padhi > > > > wrote: > > Hi Anish, > > > Please provide the details of the PDF Cracker application (if possible the > > link to download) so that even we can download the application. > > > Thanks & Regards, > > Ramkrishna T. Padhi > > On Wed, Sep 30, 2009 at 5:03 PM, Anish Shrivastava > > wrote: > > >> I have a Password Cracker application...may be I can give it a try..plz do > >> send ur file.. > > >> Cheers!! > >> ANISH > > >> On Wed, Sep 30, 2009 at 5:00 PM, vivek agrawal >> > wrote: > > >>> Hi There.. > > >>> I have downloaded a pdf file which is PASSWORD PROTECTED. > > >>> CAn anyone PLEASE help crack the password. IF YES, then pls tell me so > >>> that i can mail the pdf file to the concerned person. > > >>> I would be very oblidged for the help. > > >>> Thanks in advance > > >>> Thanks and Regards, > >>> Vivek Agrawal > >>> Skype ID - vivek.agrawal83 > > >>> GoogleMoonlight.com - Saving energy-Save Earth- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Need help in Excle macro
Hello Friends, I am very new in Excel Macros... I am triying to devlope a ms excel file with some useful macros.. I want a pop-up window whenever I open the ms excel file. In tht pop- up window i want to highlight the instruction like dont use command like "Ctrl+X" or edit in "green field only". Any one can pls help me tht how can I devlope the same. If any one can attach a sample file, than it will be more easy for me to learn and understand. Thanks a ton... - Manish pansari.man...@gmail.com --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Running Mecro automatically
Hello Friends, I want to run a macro continuously after every five minutes. Is there any option, by using that I can set macro run time and can run macro automatically? Thanks, Manish --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Mail through MS Excel more than one person - Help
Hello Friends, I want to set a macro, by using that I want to mail some data sheet on regular basis to my team members. The format is always same. So I want to devolve a macro, but I am facing a problem that how can I define body text of the mail. Further, I want to put mail IDs in a worksheet in different category like "To" & "Cc". Can through macro I can mark a single mail to more than one person? How its possible? Can anyone please suggest me the CODE or upload a sample file for code. Thanks in advance. Manish --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Getting External Data from Web when link changes with time
Hi Praveen, I think either you can define all 40 links in one workbook and than you link that cell reference in macro. Otherwise, Its better to upload a example sheet of the same. - Manish On Oct 11, 12:13 pm, Praveen Khunte wrote: > Hi Everyone > There is a specific requirement I came across while developing a tool > in excel. I am using 40 different links of the same website to extract > data in a single sheet of excel through feature "External Data from > Web". Now the problem is the link changes when month changes. > > For example for October month, first link will > behttp://www.nseindia.com/marketinfo/fo/foquote_printer.jsp?key=OPTIDXN... > For October month, second link will > behttp://www.nseindia.com/marketinfo/fo/foquote_printer.jsp?key=OPTIDXN... > Number of links are 40 which increases with CE value > > Link will change when month changes to November, example of first link > ishttp://www.nseindia.com/marketinfo/fo/foquote_printer.jsp?key=OPTIDXN... > It’s pretty simple to define a logic in excel which creates a link > automatically when month changes, so did I. I hope you got this. > > In the present situation I am using October month links to get > external data from web. I fear that when month changes to November, > the current links will not work and I have to replace all the 40 links > with November month series in the sheet. Is there any method through > macros which will automatically replace the October month links with > November month links so that I continue to receive data without > iterative process of cut and paste? > If you are not clear of the question, please ask me to upload an > example sheet of the same. > Thanks in advance. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
Re: Fwd: $$Excel-Macros$$ Running Mecro automatically
Thanks alot guys... .. .. :) I get it . ... - Manish On Oct 12, 8:59 pm, Harmeet Singh wrote: > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > > > -- Forwarded message -- > From: Harmeet Singh > Date: Mon, Oct 12, 2009 at 7:28 PM > Subject: Re: $$Excel-Macros$$ Running Mecro automatically > To: Manish Pansari > > Here u go > > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > On Mon, Oct 12, 2009 at 1:43 PM, Manish Pansari > wrote: > > > Thanks Harmeet, > > > But I am not be able to do it. Can you pls send me a sample mecro file for > > the same. > > > Thanks in advance buddy !! ! :) > > > - > > Manish Pansari > > > On Mon, Oct 12, 2009 at 2:24 PM, Harmeet Singh > > wrote: > > >> *Below code will help* > >> * > >> * > >> *Sub waitt()* > >> *For i = 1 To 5 'will run 5 times* > >> *'''''ur code* > >> *Application.Wait Now + TimeValue("00:00:05") '''will wait for 5 seconds* > >> *Next* > >> *End Sub* > > >> Thanks & Regards, > > >> Harmeet Singh > > >> Sent via BlackBerry Wireless > > >> On Sun, Oct 11, 2009 at 2:29 PM, Manish Pansari >> > wrote: > > >>> Hello Friends, > > >>> I want to run a macro continuously after every five minutes. Is there > >>> any option, by using that I can set macro run time and can run macro > >>> automatically? > > >>> Thanks, > >>> Manish > > > > Book1.xls > 27KViewDownload- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Hide/Unhide and Print selected sheets
Dear All, I want to create a macro by which I want to print relevant sheet and want to hide/unhide irrelevant sheets. I want to list out all working sheet in one sheet and in column next to the name of the worksheet i want to put Yes/No for hide the sheet. Once i decide the whole sheet which i want to hide i want to run the macro. e.g. Column A Column BColumn C HidePrint Sheet1 YesNo Sheet2 NOYes Sheet3 No Yes Sheet4 YesYes How I can do this, pls help me. I want to assign separate macro commend for hide/Unhide and print sheet. Thnxs in advance. - Manish -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Not be able to upload d file on grup
Hello all, I have one problem in excel macro, but i m not be able to upload my file on our group. :( How i can move forward to solve my problem... .. My mail ID is pansari.man...@gmail.com, mail me if you want to help me out this proble . :) Thnxs, Manish -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Long List problem
Hi All members, I have data in more than 2000 rows. I created drop down list through data validation option in excel. But its very hard and difficult to search the required name through long list. I want to create a macro with search option user form. When I click the macro, one user form will open and I can search the value (Colm A:A Value) and insert it in active cell. My idea is like MS Outlook contact book, when we want insert contact, we can search and select the required contact. Pls help me. - Manish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
$$Excel-Macros$$ Re: how dectec the mouse over an userform
Hi Jose, I am very new in excel macros... Can you pls share your macro file with me, I am also want to transparent one user form in my module. Thanks in advance. Manish pansari.man...@gmail.com On Nov 18, 3:11 pm, Alfred WALLACE wrote: > Hi to all gurus (day gurus, or night gurus !) > > My problem is in the objet of that post. > > I would like to detect when the user put the mouse > over a "non modal" userform. > > I make (with a lot of guru's help) an non-modal-ontopscreen userform. > this userform is "transparent", that works. > > Now, when the user put the mouse over my userform, i want > to give 0% of transparence. And return to the original transparence > (50% > for exemple) when the user puts the mouse on other part of sur screen. > > Can I dectect the fly, on, and off the mouse, over my USF ? > > thanks again for your help > > José from france -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
$$Excel-Macros$$ Re: Long List problem
Hi, Any help please Thanks On Nov 24, 11:17 am, Manish Pansari wrote: > Hi All members, > > I have data in more than 2000 rows. I created drop down list through > data validation option in excel. But its very hard and difficult to > search the required name through long list. > I want to create a macro with search option user form. When I click > the macro, one user form will open and I can search the value (Colm > A:A Value) and insert it in active cell. My idea is like MS Outlook > contact book, when we want insert contact, we can search and select > the required contact. > Pls help me. > > - > Manish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Re: Long List problem
SelFlag = False > > Exit For > > End If > > Next I > > If (SelFlag) Then > > Form_SelectList.List_SelectFrom.AddItem ValArray(X) > > End If > > Next X > > End Sub > > > Private Sub Btn_Select_Click() > > Sheets(CurSht).Range(CurCell).Value = > > Form_SelectList.List_SelectFrom.List(Form_SelectList.List_SelectFrom.ListIndex) > > > > > Unload Form_SelectList > > End Sub > > Private Sub Txt_Filter_Change() > > If (Form_SelectList.Txt_Filter.Value <> > > UCase(Form_SelectList.Txt_Filter.Value)) Then > > Application.EnableEvents = False > > Form_SelectList.Txt_Filter.Value = > > UCase(Form_SelectList.Txt_Filter.Value) > > Application.EnableEvents = True > > End If > > End Sub > > Private Sub UserForm_Initialize() > > Dim I, X > > Load_SelectList > > For X = 1 To UBound(ValArray) > > Form_SelectList.List_SelectFrom.AddItem ValArray(X) > > Next X > > Form_SelectList.Txt_Filter.SetFocus > > End Sub > > > Module: > > > Option Explicit > > Public ValArray > > Public CurCell, CurSht > > Sub Load_SelectList() > > Dim Dict_SelList, RowCnt, R, ValSht > > Dim SortFlag, tmpVal > > Dim LoopCnt > > > > Application.ScreenUpdating = False > > ValSht = "ValueList" > > > > Set Dict_SelList = CreateObject("Scripting.Dictionary") > > Dict_SelList.RemoveAll > > > > CurCell = ActiveCell.Address > > CurSht = ActiveSheet.Name > > > > Sheets(ValSht).Select > > RowCnt = ActiveCell.SpecialCells(xlLastCell).Row > > > > Sheets(CurSht).Select > > On Error Resume Next > > For R = 2 To RowCnt > > If (R Mod 1000 = 0) Then Application.StatusBar = "Processing " & R > > & " > > of " & RowCnt > > If (Sheets(ValSht).Cells(R, "A").Value & "X" <> "X") Then > > If (Not Dict_SelList.exists(UCase(Sheets(ValSht).Cells(R, > > "A").Value))) > > > Then > > Dict_SelList.Add UCase(Sheets(ValSht).Cells(R, "A").Value), R > > End If > > End If > > Next R > > ' ReDim ValArray(Dict_SelList.Count) > > ' For R = 1 To Dict_SelList.Count > > ValArray = Dict_SelList.keys > > Application.StatusBar = "Sorting Values" > > LoopCnt = 0 > > SortFlag = True > > While SortFlag > > LoopCnt = LoopCnt + 1 > > If (LoopCnt Mod 100 = 0) Then Application.StatusBar = "Sorting > > Values: > >" > > > & LoopCnt > > If (LoopCnt > UBound(ValArray) * 100) Then > > MsgBox "Excessive sorting, try sorting data first" > > Exit Sub > > End If > > > > SortFlag = False > > For R = 1 To UBound(ValArray) > > If (ValArray(R - 1) > ValArray(R)) Then > > SortFlag = True > > tmpVal = ValArray(R - 1) > > ValArray(R - 1) = ValArray(R) > > ValArray(R) = tmpVal > > ' Exit For > > End If > > Next R > > Wend > > On Error GoTo 0 > > Application.StatusBar = False > > Application.ScreenUpdating = True > > End Sub > > > - Original Message > > > From: Manish Pansari > > > To: MS EXCEL AND VBA MACROS > > > Sent: Wed, November 24, 2010 5:52:04 AM > > > Subject: $$Excel-Macros$$ Re: Long List problem > > > > Hi, > > > > Any help please > > > > Thanks > > > > On Nov 24, 11:17 am, Manish Pansari wrote: > > > > Hi All members, > > > > > I have data in more than 2000 rows. I created drop down list through > > > > data validation option in excel. But its very hard and difficult to > > > > search the required name through long list. > > > > I want to create a macro with search option user form. When I click > > > > the macro, one user form will open and I can search the value (Colm > > > > A:A Value) and insert it in active cell. My idea is like MS Outlook > > > > contact book, when we want insert contact, we can search and select > > > > the
Re: $$Excel-Macros$$ Re: Long List problem
Any help pls On Nov 25, 10:53 am, Manish Pansari wrote: > Hi Paul, > > Thanks a ton for your help. > > I am financial guy and I know only 20% coding in VBA. I am on the way > to learn VBA. > > I get an idea with following code. I need one textbox in same form > above the unique item text box to search the item from unique item > list. > Further this form takes lot of time to search unique item. How can we > make it fast?? If it’s not possible, than I am not want short the data > for unique item. > > Modules: > > Option Explicit > ' This example is based on a tip by J.G. Hussey, > ' published in "Visual Basic Programmer's Journal" > > Sub RemoveDuplicates() > Dim AllCells As Range, Cell As Range > Dim NoDupes As New Collection > Dim i As Integer, j As Integer > Dim Swap1, Swap2, Item > > ' The items are in A1:A65000 > Set AllCells = Range("A1:A65000") > > ' The next statement ignores the error caused > ' by attempting to add a duplicate key to the collection. > ' The duplicate is not added - which is just what we want! > On Error Resume Next > For Each Cell In AllCells > NoDupes.Add Cell.Value, CStr(Cell.Value) > ' Note: the 2nd argument (key) for the Add method must be a > string > Next Cell > > ' Resume normal error handling > On Error GoTo 0 > > ' Update the labels on UserForm1 > With UserForm1 > .Label1.Caption = "Total Items: " & AllCells.Count > .Label2.Caption = "Unique Items: " & NoDupes.Count > End With > > ' Sort the collection (optional) > For i = 1 To NoDupes.Count - 1 > For j = i + 1 To NoDupes.Count > If NoDupes(i) > NoDupes(j) Then > Swap1 = NoDupes(i) > Swap2 = NoDupes(j) > NoDupes.Add Swap1, before:=j > NoDupes.Add Swap2, before:=i > NoDupes.Remove i + 1 > NoDupes.Remove j + 1 > End If > Next j > Next i > > ' Add the sorted, non-duplicated items to a ListBox > For Each Item In NoDupes > UserForm1.ListBox1.AddItem Item > Next Item > > ' Show the UserForm > UserForm1.Show > End Sub > > User Form: > Private Sub OKButton_Click() > ActiveCell = ListBox1.Value > Unload Me > End Sub > > I don't have rights to shere my file on group. How can i shere my file > with you?? Thanks in advance. > > - > Manish > > On Nov 24, 7:53 pm, Paul Schreiner wrote: > > > > > Sorry Herman, > > I didn't mail you directly. > > > You received this because you've subscribed to the > > Excel-Macros group in Google. > > (actually, it's called: MS EXCEL AND VBA MACROS) > > > I simply responded to a message posted to the group. > > If you would like to stop receiving emails from the GROUP, > > you need to log into the Google Group site:http://groups.google.com/ > > > access your account, (My Account) > > select the "Groups - Manage Subscriptions" option. > > > Here you can select to receive indiviual emails, Abrigdged emails, or none > > at > > all. > > > Sorry for the inconvenience. > > > Paul > > > - Original Message > > > From: Herman Esmeijer > > > To: excel-macros@googlegroups.com > > > Sent: Wed, November 24, 2010 8:51:40 AM > > > Subject: RE: $$Excel-Macros$$ Re: Long List problem > > > > Hi Paul, > > > > Please stop mailing me. > > > > Gr. > > > Herman > > > > -Oorspronkelijk bericht- > > > Van: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > > >Namens Paul Schreiner > > > Verzonden: woensdag 24 november 2010 14:47 > > > Aan: excel-macros@googlegroups.com > > > Onderwerp: Re: $$Excel-Macros$$ Re: Long List problem > > > > OK, here's something to work with: > > > > My sample list (Sheet ValueList) has 65000 rows. > > > the userform (Form_SelectList) loads the UNIQUE values (6100) into a > > > listbox > > > called List_SelectFrom > > > > You enter any number of words into the The Text box (txt_Filter) > > > and hit the button (Btn_Filter) > > > which then reloads the listbox with records that contain the keywords. > > > > Give it a try and see what you think. > > > > Paul > > > > --
Re: $$Excel-Macros$$ Salary sending problem
Hi Vaibhav, It's really unbelievable... Even I can also use your module for my salary details. :) Thanks a ton for such type of valuable post on group. Vaibhav, I need a small change in your macro, I always sent salary details to reporting managers and he/she forward the same to concern employee. I want to send a single mail to reporting manager. Is it possible to send a single email with 5-6 file attachments? I mean, if I mention same email id in more than one column in sheet1, macro will attach all the details in different - different excel file and sent all the files in one email. :) Thanks in advance. Regds, Manish Pansari +91 9810 88 8281 On Nov 29, 11:54 am, in.vaib...@gmail.com wrote: > Hi Again, > > I can generate in PDF for that u will require to have Office 2007, but > password protection is not possible at present. > > Is it OK. > > Sent on my BlackBerry® from Vodafone > > > > -Original Message- > From: Ankit Agrawal > Date: Mon, 29 Nov 2010 11:42:43 > To: > > Cc: > Subject: Re: $$Excel-Macros$$ Salary sending problem > > Again a recommendation, if it is transfer in to the PDF with password.can it > possible. > > Regards, > Ankit > > On Mon, Nov 29, 2010 at 11:19 AM, Ankit Agrawal > wrote: > > > thank you sir, > > > Its done dana done. > > > On Sun, Nov 28, 2010 at 11:12 AM, wrote: > > >> Dear Ankit, > > >> Thanks for your appreciation, Is your query solved. If not then what type > >> of error is occurring. > > >> You need to create payslips folder in C drive. And all files are stored in > >> that folder. > > >> Pl note folder name is Payslips and not payslip. > > >> The location and name of folder can be also changed by editing cell in red > >> colour on sheet Form which contains "C:/payslips". > > >> Please revert. > > >> Sent on my BlackBerry® from Vodafone > >> -- > >> *From: * Ankit Agrawal > >> *Date: *Sat, 27 Nov 2010 08:37:47 +0530 > >> *To: *in.vaib...@googlemail.com > >> *Cc: * > >> *Subject: *Re: $$Excel-Macros$$ Salary sending problem > > >> Namste Vaibhav ji, > > >> *Unbelievable task. *how I tell you what you are? but sir after clicking > >> it, it add sheet and creating the file as well. but not saving it and > >> occurring a error. so please implement it also. > > >> Thanks & Regards > >> Ankit > >> > > >> On Fri, Nov 26, 2010 at 8:37 PM, in.vaib...@googlemail.com < > >> in.vaib...@gmail.com> wrote: > > >>> Dear Ankit, > > >>> Check the attached file. It meets all requirements. > > >>> Create folders name "payslip" in C: > > >>> //BR > > >>> VaibhavJ > > >>> Life is cool... > > >>> On Thu, Nov 25, 2010 at 11:05 PM, wrote: > > >>>> Dear Ankit, > > >>>> I have made one macro this will send payslip as in-line to email. > > >>>> Follow the instruction sheet. If format and everything is OK then I will > >>>> work for your other requirement. > > >>>> Pl note that I will able to generate password protected XLS file. > > >>>> Please revert for help. > > >>>> Sent on my BlackBerry® from Vodafone > >>>> -- > >>>> *From: * Ankit Agrawal > >>>> *Sender: * excel-macros@googlegroups.com > >>>> *Date: *Tue, 16 Nov 2010 18:53:55 +0530 > >>>> *To: * > >>>> *ReplyTo: * excel-macros@googlegroups.com > >>>> *Subject: *$$Excel-Macros$$ Salary sending problem > > >>>> Hello Sir, > > >>>> I have a problem related to mail through excel. basically I have to make > >>>> salary slip. and forward it to the employees. I manage the data into the > >>>> excel and use mail merge in MS word. now the problem is, I have to make > >>>> separate file for each employee and have to send one by one on their > >>>> e-mail > >>>> id. > > >>>> Question > > >>>> 1- Is any way that we can make separately file automatically and send to > >>>> it mail automatically to each employee. > >>>> 2- is any way that every file having its own password and its password > >>>> would be employee DOB or their PAN may be any other key > > >>>> Here I am sending you sample file so please illustrate it because I am >
$$Excel-Macros$$ SMS through MS Excel
Excel Experts, Is it possible to send message (SMS) through MS Excel. If yes, Pls give me an idea or some sample macro file. Thanks, Manish Pansari -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
$$Excel-Macros$$ Re: Learning Macro
Hi Anand, Thanks for your valuable suggestion. Pls fwd me the link for ebook. I want ebook on Excel VBA. Thanks in advance !! :) Regds, Manish Pansari On Dec 9, 12:28 pm, anandydr wrote: > Hi, > > If you do a google search for the term MS Excel VBA tutorials you will > find a lot of websites for that. The best way would be to take a task > that you do repeatedly and start creating a macro for it. Learning > from one project you will eventually learn how to automate a lot of > tasks. > > In case you need ebooks or further help on problems you encounter feel > free to post on the group or mail me at anand...@gmail.com > > Hope that helps, > Anand Kumar > > On Dec 9, 10:31 am, "balbirkumar ." wrote: > > > > > Dear Friends, > > > I dont know how create macros in excel and how and what codes are used for > > its creation. But, I am interested in Knowing them. Please suggest me from > > where i could learn. > > > With > > Thanks & Regards > > > -- > > Balbir Kumar- Hide quoted text - > > - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
$$Excel-Macros$$ How to lock cell based on condition
Dear EE, Is it possible to lock the entire row/selected cell based on condition in particular Cell. for example, I want to lock the row based on value in column A. If macro found value "yes" in cell A1 & A5, Macro will lock the row 1 & row 5. I hope its possible in macro. Pls suggest me the code. Thnxs, Manish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts