$$Excel-Macros$$ Re: Macro to update another Macro?
Sounds good Paul!! Thanks!! On Oct 3, 4:52 pm, Paul Schreiner schreiner_p...@att.net wrote: Actually, I might be able to help here. I'll have to wait until I get back to work on Monday though! Paul From: Chechu cecic...@hotmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Saturday, October 3, 2009 7:48:53 AM Subject: $$Excel-Macros$$ Re: Macro to update another Macro? The VBA code is Password protected AND resides in a remote computer. I developed the protected VBA Code, and I know the password. This is an Excel tool that I sent to all my department two weeks ago, and now I figured out that has an error in a Macro. So instead of sending a NEW tool, I wanted to send a Macro to correct the Macro in the original file.. Paul, I am not trying to do anything ilegal here!!! I developed the original file, and I am trying to change it. Thanks, C On Oct 2, 9:24 am, Paul Schreiner schreiner_p...@att.net wrote: Let's clarify something. IS the VBA CODE PASSWORD PROTECTED? or does it simply reside at a remote location? There's a difference between having the VBA code protected and it simply being inaccessible. If the VBA code is password protected, and you don't know the password, then you can't do what you're asking. '= In my company, if you're not in the I.T. department (computer support) being in possession of a password breaker is a violation of Security Policy and cause for termination. '= But if the reason is that the files reside on remote computers, but the VBA code isn't actually locked, then I can send you some code that you can modify to remove the code modules and import your own! Paul From: Chechu cecic...@hotmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Friday, October 2, 2009 5:41:50 AM Subject: $$Excel-Macros$$ Re: Macro to update another Macro? Yes, that's the challenge!! I can't unlock the VBA Code, because the file resides on each user's computer. I have to send a new file with a Macro to update it Thanks! CC On Oct 1, 3:49 pm, Paul Schreiner schreiner_p...@att.net wrote: If you can unlock the VBA code, then it's fairly simple to remove an entire module and import another. But first you have to be able to unlock the VBA. Paul From: Cecilia Chiderski cecic...@hotmail.com To: excel-macros@googlegroups.com Sent: Thursday, October 1, 2009 12:37:25 PM Subject: $$Excel-Macros$$ Macro to update another Macro? Hi, I have an Excel file with a locked VBA code. I need to create in a separated Excel file a Macro to update a Macro stored in this first Excel. I read some useful information in the web, but still can't write the appropriate code to do it. Can somebody send an example?? Thanks, CC Charlas más divertidas con el nuevo Windows Live Messenger- Hide quoted text - - Show quoted text -- 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$$ Re: Macro to split a master list into three lists
Easier!! Given a sheet with the format I sent, I need to create an output sheet opened by resource location. On Oct 3, 3:33 pm, jamesdavey james_dav...@yahoo.co.uk wrote: so you mean, for example, you want to add a new resource manually, then press a button perhaps to update an output sheet? On 3 Oct, 12:42, Cecilia Chiderski cecic...@hotmail.com wrote: Hi, I need your expertise on this... Example attached. I have a list of resources with different locations. There are 3 possible locations. I need to split the list into three different tables, one per location, and add total on each. Number of resources is not fixed, number of locations is always three (might move to four, but I mean, is a fixed value). Any suggestions on a macro to do this?? Thanks, CC _ Nuevo Windows Live, un mundo lleno de posibilidades. Descúbrelo.http://www.microsoft.com/windows/windowslive/default.aspx Split by category.xls 20KViewDownload- 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$$ Re: macro help needed
Never mind, I received help elsewhere. On Oct 2, 11:55 pm, vespid jrblack...@gmail.com wrote: I'm making excel macros for the first time and getting things figured out, but I have a few questions: What code do I use to delete columns that have all empty cells EXCEPT the top cell (row 1) that contains any of a number of headings? I need to insert this into an existing macro. What code do I use to shade every other row (preferably even numbered) light grey after selecting a currentregion ? Again, to put inside an existing macro. A related question: When I find code help on the web, it usually starts with sub and ends with end sub so how do I insert that into an existing macro? It looks like a sub within a sub doesn't work. Thank you for your attention. Vespid --~--~-~--~~~---~--~~ -- 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: Write numbers in word
Dear Dilip, I am not as good as you are. So, could you pls modify the Macro to suite Indian Curreny i.e. Rupees (Rs) and Paisa. Thanks On Sun, Oct 4, 2009 at 4:58 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Zaheer, Just answered this one a while ago. Check out and let me know if you did'nt find that email. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/2/09, ~ Z A H E E R ~ zk9...@gmail.com wrote: Dear group members, Please help to to write numbers into words automatically. for. eg. if i enter 1,250/365 in any cell then formula or code should give me asnswer in words in any other cell [Currency Name] Öne Thousand Two Hundred Fifty [Currency Name for change] 365/1000 Only i.e Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only. Number could be answer of any formula. Please help me. Thanx 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 -~--~~~~--~~--~--~---
$$Excel-Macros$$ populate a column based on existing criterion
customer dzip New Customer proctoandg 10024 procto procto 10024 procto procto 10024procto bambo 13456 bambospecies bambospecies 13456 bambospecies barbs 200011 barbs bangal 10022 bangal I have two columsn of data which are populated. customer and dzip. The column New customer has to be populated such that new customer has to be equal to column customer when ever they have equal dzips. for example the first two entries in the new colum are procto since they have equal dzips. Now this could be populated by either proctoandg or procto- but procto is repeated more no of times in my original data than proctoandg . So new customer field will have procto in the first two fields. So bottomline new customer colmn is populated by using two crieteria 1)Dzip field values must be equl 2) when ever dzip field are same, then populate the last colum with the value of the column customer which is repeated max no of times. \\ Thanks for any help . help is appreciated. --~--~-~--~~~---~--~~ -- 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: Enable V Look up Option on the Excel Sheet.
There are many lookups, what kind of information you need to warrant the lookup function. Please tell us what is your problem precisely. dont make us guess. On Sat, Oct 3, 2009 at 12:20 PM, Equity Monk equitym...@gmail.com wrote: Dear Friends, I am attaching a portfolio. It is a mf portfolio. If you can pls attach a v look up function to it that would be great. The website from where the link can come is http://www.amfiindia.com/. Looking fwd to your help. --~--~-~--~~~---~--~~ -- 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: Calculate 10 working days from a given date
Hi Dilip, Thanks a tonn for your kind help. There is a typo in the second criteria which i send out earlier. Please read it as under: For other Customers, I need to follow up after 20*/25/30* calender days (depending upon the customer) from a given date (the given date can be today/yesterday or a day earlier) and the *resultant date** **should not fall on a US federal holidays,Sat or Sun* Thanks in advance Vinod N On Sun, Oct 4, 2009 at 4:10 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Vinod, You can use an inbuilt function of Excel viz. Workday to achive the required result. Same is explained in the attachment. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/3/09, Vinod N nvino...@gmail.com wrote: Hi, Please help me in the calculating the follow up date of a a particular request. The criteria is as under: - For a particular type of customer, I need to follow up after 10 working days from a given date (the given date can be today/yesterday or a day earlier) and need to exclude even US federal holidays and Sat and Sun - For another type of customer, I need to follow up after 20 calender days from a given date (the given date can be today/yesterday or a day earlier) and need to exclude even US federal holidays and Sat and Sun Can any one help me in writing a formula or a Macro.. Your help in this matter is highly appreciated. -- Thanks and Regards Vinod N -- Thanks and Regards Vinod N --~--~-~--~~~---~--~~ -- 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$$ status bar
dear excel genuises, may i request your help how to change the default message in excel 2003 status bar? and prevent the user from changing it. thanks a lot. may god shower you with graces. dellosa --~--~-~--~~~---~--~~ -- 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$$ Unsubscribe
Kindly unsubscribe me from the group. Extreme Regards Mahreen --~--~-~--~~~---~--~~ -- 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$$ RGB cell values
Hi All Please provide with a code which can put RGB cell values in colored cells. Hugs --~--~-~--~~~---~--~~ -- 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: Unsubscribe
This is done !! -Ayush Jain On Oct 5, 9:54 am, Mahreen Ellahi mahreen.a...@googlemail.com wrote: Kindly unsubscribe me from the group. Extreme Regards Mahreen --~--~-~--~~~---~--~~ -- 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: RGB cell values
A Google search for: excel vba read interior color rgb returned Chip Pearson's site at Pearson Software Consulting, LLC: http://www.cpearson.com/excel/colors.aspx He's got examples and functions for returning the RGB values for a cell. hope this helps. Paul From: janet dickson janetdicks...@gmail.com To: excel-macros@googlegroups.com Sent: Sunday, October 4, 2009 11:53:56 PM Subject: $$Excel-Macros$$ RGB cell values Hi All Please provide with a code which can put RGB cell values in colored cells. Hugs --~--~-~--~~~---~--~~ -- 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: Macro to update another Macro?
It looks like I spoke too soon. I have code that will delete VB modules and import vb modules, but it cannot protect/unprotect the VBProject. I took a look around the internet and from all posts I've seen, it can't be done with VBA directly. However, you CAN use SendKeys, but that would mean that the VBeditor has to be OPEN! It would be nice to be able to do this behind the scenes. If you want, I can send you the code I have for removing/adding the modules, but it sounds like you're going to have to try a different approach! sorry, Paul From: Chechu cecic...@hotmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Sunday, October 4, 2009 12:33:30 PM Subject: $$Excel-Macros$$ Re: Macro to update another Macro? Sounds good Paul!! Thanks!! On Oct 3, 4:52 pm, Paul Schreiner schreiner_p...@att.net wrote: Actually, I might be able to help here. I'll have to wait until I get back to work on Monday though! Paul From: Chechu cecic...@hotmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Saturday, October 3, 2009 7:48:53 AM Subject: $$Excel-Macros$$ Re: Macro to update another Macro? The VBA code is Password protected AND resides in a remote computer. I developed the protected VBA Code, and I know the password. This is an Excel tool that I sent to all my department two weeks ago, and now I figured out that has an error in a Macro. So instead of sending a NEW tool, I wanted to send a Macro to correct the Macro in the original file.. Paul, I am not trying to do anything ilegal here!!! I developed the original file, and I am trying to change it. Thanks, C On Oct 2, 9:24 am, Paul Schreiner schreiner_p...@att.net wrote: Let's clarify something. IS the VBA CODE PASSWORD PROTECTED? or does it simply reside at a remote location? There's a difference between having the VBA code protected and it simply being inaccessible. If the VBA code is password protected, and you don't know the password, then you can't do what you're asking. '= In my company, if you're not in the I.T. department (computer support) being in possession of a password breaker is a violation of Security Policy and cause for termination. '= But if the reason is that the files reside on remote computers, but the VBA code isn't actually locked, then I can send you some code that you can modify to remove the code modules and import your own! Paul From: Chechu cecic...@hotmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Friday, October 2, 2009 5:41:50 AM Subject: $$Excel-Macros$$ Re: Macro to update another Macro? Yes, that's the challenge!! I can't unlock the VBA Code, because the file resides on each user's computer. I have to send a new file with a Macro to update it Thanks! CC On Oct 1, 3:49 pm, Paul Schreiner schreiner_p...@att.net wrote: If you can unlock the VBA code, then it's fairly simple to remove an entire module and import another. But first you have to be able to unlock the VBA. Paul From: Cecilia Chiderski cecic...@hotmail.com To: excel-macros@googlegroups.com Sent: Thursday, October 1, 2009 12:37:25 PM Subject: $$Excel-Macros$$ Macro to update another Macro? Hi, I have an Excel file with a locked VBA code. I need to create in a separated Excel file a Macro to update a Macro stored in this first Excel. I read some useful information in the web, but still can't write the appropriate code to do it. Can somebody send an example?? Thanks, CC Charlas más divertidas con el nuevo Windows Live Messenger- Hide quoted text - - Show quoted text -- 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$$ Re: Difference of Modules
Thank You Paul Regards Umesh Dev On Thu, Oct 1, 2009 at 7:40 PM, Paul Schreiner schreiner_p...@att.netwrote: A Class is a way of defining a new object and attributes. let's say you wanted to create an object called People. Now, for each person in People you wanted to save the Name Address City Postal_Code Phone_Home Phone_Work Phone_Cell Birthday Start_Date You would define this Class in a Class Module. Then, in a Regular module, you could create a new variable like: Dim Employee as People then, the Employee variable automatically has the properties: Employee.Name Employee.Address Employee.City Employee.Postal_Code Employee.Phone_Home Employee.Phone_Work Employee.Phone_Cell Employee.Birthday Employee.Start_Date Of course, it's EMPTY until your macro fills it. to find examples (and a better explanation!) Just Google VBA Class Module. You'll find HUNDREDS of good articles! Paul -- *From:* Umesh Dev umesh.d...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, October 1, 2009 6:56:08 AM *Subject:* $$Excel-Macros$$ Difference of Modules Hi All, Can anyone tell the difference between a Module and a Class Module. What are the advantages in writing a code in either Module/Class Module. Regards Umesh Dev --~--~-~--~~~---~--~~ -- 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$$ Excel 2007: How can I use VBA to set series border line width?
After making a chart in Excel 2007, you can right click on a Data Series. then select Format Data point. The on the right, select Border Styles. Within this, there's a way to set the width: say to 0.25 pt. That's the GUI way of doing it, how can I change this width using VBA? --~--~-~--~~~---~--~~ -- 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: Excel 2007: How can I use VBA to set series border line width?
Have you tried recording a macro and then doing these steps? P From: Sonny sonnyt...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Monday, October 5, 2009 8:55:18 AM Subject: $$Excel-Macros$$ Excel 2007: How can I use VBA to set series border line width? After making a chart in Excel 2007, you can right click on a Data Series. then select Format Data point. The on the right, select Border Styles. Within this, there's a way to set the width: say to 0.25 pt. That's the GUI way of doing it, how can I change this width using VBA? --~--~-~--~~~---~--~~ -- 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: Excel 2007: How can I use VBA to set series border line width?
On 10/5/09, Paul Schreiner schreiner_p...@att.net wrote: Have you tried recording a macro and then doing these steps? P Hi Sonny, Go to tools macros recod new macro you can right click on a Data Series. then select Format Data point. The on the right, select Border Styles. Within this, there's a way to set the width: say to 0.25 pt. regards hari kumar From: Sonny sonnyt...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Monday, October 5, 2009 8:55:18 AM Subject: $$Excel-Macros$$ Excel 2007: How can I use VBA to set series border line width? After making a chart in Excel 2007, you can right click on a Data Series. then select Format Data point. The on the right, select Border Styles. Within this, there's a way to set the width: say to 0.25 pt. That's the GUI way of doing it, how can I change this width using VBA? -- Hari kumar Our strength grows out of our weaknesses. --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~---