$$Excel-Macros$$ Re: How to break the vba project password
Hi Harmeet, Thank you very much. Regards Hari Kumar _ From: Harmeet Singh [mailto:harmeet.hew...@gmail.com] Sent: Wednesday, March 18, 2009 10:10 PM To: excel-macros@googlegroups.com Cc: prekkeh...@gmail.com Subject: Re: $$Excel-Macros$$ Re: How to break the vba project password Hi Hari, It is unlocked. Password for is 1. On Fri, Mar 20, 2009 at 10:19 AM, hari prekkeh...@gmail.com wrote: Hi Harmeet, Enclosed please find the file. Regards Hari Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Harmeet Singh Sent: Wednesday, March 18, 2009 7:19 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: How to break the vba project password Where is the file. On Thu, Mar 19, 2009 at 1:20 PM, hari prekkeh...@gmail.com wrote: Hi All, Can anyone help me how to break a vba protect password. Regards Hari kumar -- Thanks Regards, Harmeet Singh -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Update from internet
unsubscribe On Wed, Mar 18, 2009 at 10:16 PM, Balachander S sba...@gmail.com wrote: Can some body in the group tell me how to solve this problem I Have a worksheet that updates some rates from the internet on a daiily basis.When it updates then I want it to do some action ... say print. I use the on change but it doesnt work unless i key in some value in the sheet and not when it updates from the web. Can any body help. S Baloo -- PRAVIN MEHTA --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Update from internet
Pravin Since every member is important to this group and hence their posts and presence. We didn't unsubscribed you but solved your problem, now onwards you won't be receiving our mails, to check them you'll have to come online and see this group. This doesn't affect your membership at all. Regards Ashish Jain Group Manager On Mar 19, 12:27 pm, pravin mehta mehtapravin@gmail.com wrote: unsubscribe On Wed, Mar 18, 2009 at 10:16 PM, Balachander S sba...@gmail.com wrote: Can some body in the group tell me how to solve this problem I Have a worksheet that updates some rates from the internet on a daiily basis.When it updates then I want it to do some action ... say print. I use the on change but it doesnt work unless i key in some value in the sheet and not when it updates from the web. Can any body help. S Baloo -- PRAVIN MEHTA --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Update from internet
Hi Group, I am trying to create spreadsheet where i can see the change in data every time the spreadsheet refreshes. please find the spreadsheet attached to it. the spreadsheet refreshes in every 1 min. so every time the data set gets refresh. please help me to write a macro which will take a backup of data in cells B18, E18, G18 to calculate the % change every time the data gets refresh. if possible if i can put a counter so that whenever i select a strike price in the combo box, it paste the data points dynamically in each row below.. Thanks in advance himu --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~--- File backup.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Update from internet
Attached workbook is updated by VBA code. let me know if you need more clarification. On Thu, Mar 19, 2009 at 3:43 PM, Himadri Roy himadri@gmail.com wrote: Hi Group, I am trying to create spreadsheet where i can see the change in data every time the spreadsheet refreshes. please find the spreadsheet attached to it. the spreadsheet refreshes in every 1 min. so every time the data set gets refresh. please help me to write a macro which will take a backup of data in cells B18, E18, G18 to calculate the % change every time the data gets refresh. if possible if i can put a counter so that whenever i select a strike price in the combo box, it paste the data points dynamically in each row below.. Thanks in advance himu -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~--- Copy of File backup(1).xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ help me for check box
Hello, Can any one tell me how a check box can be used. Or how does it work with or with out macros Regards --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Repeated Value in a Column
thanks Ashish,, will try the codes and if anything come back to you thanks once again Gohar On Thu, Mar 19, 2009 at 7:29 AM, Ashish Jain 26may.1...@gmail.com wrote: --- Hi Gohar, Try this code, This will Select all the duplicates in your selection and will tell you their count too. 1. Press Alt+F11 2. Paste the code below in code window. Sub SelectDuplicateValues() Dim MyCell As Range Dim rNew As Range Dim rFind As Range Dim iSecRange As Range For Each MyCell In Selection.Cells If Not IsEmpty(MyCell.Value) Then For Each ncell In Selection.Cells If Intersect(MyCell, ncell) Is Nothing Then If iSecRange Is Nothing Then Set iSecRange = ncell Else Set iSecRange = Union(ncell, iSecRange) End If End If Next Set rFind = iSecRange.Find(MyCell.Value, LookIn:=xlValues, LookAt:=xlWhole, MatchCase:=True) If Not rFind Is Nothing Then If rNew Is Nothing Then Set rNew = MyCell Else Set rNew = Union(rNew, MyCell) End If End If End If Set iSecRange = Nothing Next If Not rNew Is Nothing Then rNew.Select End If Msgbox Selection.cells.count Duplicate Cells Found. End Sub 3. Press Alt+Q. 4. Press Alt+F8. 5. Run the macro - Select Duplicate Values. For more tips, tricks, downloads and problem solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com +91--40-48-43 --- --- On Mar 19, 7:47 am, tariq 78692 tariq.78...@gmail.com wrote: repleated value find some type - conditional formating logical value by if condition. On 17/03/2009, Harmeet Singh harmeet.hew...@gmail.com wrote: See attached file. On Tue, Mar 17, 2009 at 12:34 PM, Gohar goh@gmail.com wrote: Dear All How to find out repleated value in a column. Thanks Gohar -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Subtract values that are in different rows
Here's the setup: 1. In column A I have date/time stamps. 2. In column B I have text entries associated with the time stamps. These entries vary but each day starts with a date/time stamp of System Login and ends with a stamp of System Shutdown. Kind of like a time clock situation. 3. I pull the start times with a VLOOKUP that looks for System Login and the stop times with a VLOOKUP that looks for System Shutdown. If it doesn't find them, it enters Null. 4. Now I've got columns C D with 100 rows that say either Null or have a date/time stamp. 5. I now have to subtract the date/time values in column C from the matching date/time value in column D to get the duration of time worked for that particular day. The problem is that the start times and the stop times are in different rows, e.g. I might have the start time for 3/16/09 in C2 and the stop time in D6, the start time for 3/17/09 in C7 and the stop time in D10, and so on. Does anyone know of a formula I can enter in column E that will subtract the first date/time value in column C from the first date/time value in column D, the second date/time in column C from the second date/time in column D and so on down the line? Any help greatly 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Error setting Application.ActivePrinter
Hi All, I get a runtime error when I set Application.ActivePrinter to a valid printer from the Printers collection in VB6. I even get the error if I set Application.ActivePrinter = Application.ActivePrinter. Does anyone have any ideas, or is this just invalid via a COM call. Regards, Dale. --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Change image source
Hi Sister Here is your Solution posted - Please check the Link below: http://www.excelitems.com/2009/03/change-picture-or-image-location.html . . . . . . For more tips, tricks, downloads and problem solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com +91--40-48-43 --- --- On Mar 17, 5:58 pm, Sister Ray carlosp...@gmail.com wrote: I'm trying to change a Picture object that is included in a Excel Worsheet, since I haven't had much sucess I was wondering if it is possible to change the image source (the file that is being displayed) 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Subtract values that are in different rows
Hi Jake, Can you please provide us with the dummy data workbook? It's not 100% clear and providing any solution in such a case doesn't worth much. . . . . . For more tips, tricks, downloads and problem solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com +91--40-48-43 --- --- On Mar 20, 2:23 am, Jake doug_jacob...@intuit.com wrote: Here's the setup: 1. In column A I have date/time stamps. 2. In column B I have text entries associated with the time stamps. These entries vary but each day starts with a date/time stamp of System Login and ends with a stamp of System Shutdown. Kind of like a time clock situation. 3. I pull the start times with a VLOOKUP that looks for System Login and the stop times with a VLOOKUP that looks for System Shutdown. If it doesn't find them, it enters Null. 4. Now I've got columns C D with 100 rows that say either Null or have a date/time stamp. 5. I now have to subtract the date/time values in column C from the matching date/time value in column D to get the duration of time worked for that particular day. The problem is that the start times and the stop times are in different rows, e.g. I might have the start time for 3/16/09 in C2 and the stop time in D6, the start time for 3/17/09 in C7 and the stop time in D10, and so on. Does anyone know of a formula I can enter in column E that will subtract the first date/time value in column C from the first date/time value in column D, the second date/time in column C from the second date/time in column D and so on down the line? Any help greatly 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 - -~--~~~~--~~--~--~---