Re: $$Excel-Macros$$ VBA Security - Restrict Users from Editing VBA Macros
Dear Vinod, By line Remeber some software do not ask for serial keys. :) - I meant to say that there are some softwares which do not asks for serial key(s) as they don't have the relavant option to enter serial key. So these types of softwares are only be cracked / patched. Alternatively, you can purchase a software from open market. Further to this, I may not help you because If I had the dump + serial key of the software, I would have forwarded you the same. Thanks. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sun, Dec 13, 2009 at 7:14 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Vinod, There are many demo softwares/ tools available over internet which well help you to remove VBA password. To get the full version, either you can purchase them or search for the unlock key(s) if you get the respective option in tool. Remeber some software do not ask for serial keys. :) Thanks Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/9/09, Vinod N nvino...@gmail.com wrote: Hi, Can you suggest any site which will help me in breaking/cracking the password ? A year back i had created few macros..but ironically i have forgotten the password and the macros need to be changed with course of time and environment... Thanks Vinod N On Mon, Dec 7, 2009 at 5:34 AM, tianung tian...@hotmail.com wrote: Just playing the devil's advocate here - though most people wouldn't bother or know how to (and I'm sure Dilip is aware of this but has probably chosen to keep his reply short and concise), excelCPA should realise that there are various tools freely available on the internet which allow determined hackers to see and edit your VBA code despite your password. -- -- 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 -- 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 -- -- 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: $$Excel-Macros$$ Freeze the cell once the Data has been entered?
Thanks Mr. Shah..!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sun, Dec 13, 2009 at 11:27 PM, harsh shah harshsha...@gmail.com wrote: hey this was good one 2009/12/13 Dilip Pandey dilipan...@gmail.com Dear Ramesh, Required automation is attached herewith. Thanks Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/10/09, Chanti-Hyderabad ramesh1...@gmail.com wrote: Hi Excel Gurus, Looking for the following actions in excel. 1. As soon as I select an option from the drop down, the cell should be frozen, rather locked. 2. Further Cell should not allow any user to edit the data Please let me know if you have any questions. Regards, --Ramesh -- -- 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 -- -- 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 -- -- 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 -- -- 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: $$Excel-Macros$$ Re: Rota planning
Just attach it as you would any attachment. Dave. Date: Sun, 13 Dec 2009 23:16:49 -0800 Subject: $$Excel-Macros$$ Re: Rota planning From: j...@jpwebs.co.uk To: excel-macros@googlegroups.com Sheet did not attach - where do I do this please? John -- -- 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 _ Looking for a great date? Meet singles at ninemsn dating http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- -- 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: Rota planning
When you first go to the Google Groups page for this group, there is a files- area: http://groups.google.com/group/excel-macros?hl=en and a button to add afile. On Dec 14, 2:16 am, Tonto j...@jpwebs.co.uk wrote: Sheet did not attach - where do I do this please? John -- -- 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: $$Excel-Macros$$ Alert for repeating cell information
Many thanks for the responses! The two that have been provided work perfectly. I think I'll step into the shallow end from now on, not the deep end :) On Dec 11, 7:20 pm, Paul Schreiner schreiner_p...@att.net wrote: How is it that you WANT it to function? do you want it to check when you ENTER a value? or do you just want a macro that you can execute that will change the color? this would work for the second scenario: Option Explicit Sub Flag_Dup() Dim Dict_CellVal, I, RowCnt 'Create Dictionary Object to count unique values Set Dict_CellVal = CreateObject(Scripting.Dictionary) Dict_CellVal.RemoveAll '--- Columns(A:A).Interior.ColorIndex = 0 'clear colors '--- ' count number of rows that have content RowCnt = Application.WorksheetFunction.CountA(Columns(A:A)) '--- ' Loop through rows '--- For I = 1 To RowCnt If (Not Dict_CellVal.exists(Cells(I, A).Value)) Then 'Add unique value to Dictionary Object Dict_CellVal.Add Cells(I, A).Value, 1 Else 'Increment count if duplicate is encountered Dict_CellVal.Item(Cells(I, A).Value) = Dict_CellVal.Item(Cells(I, A).Value) + 1 End If Next I '--- ' highlight rows where count 1 '--- For I = 1 To RowCnt If Dict_CellVal.Item(Cells(I, A).Value) 1 Then Cells(I, A).Interior.ColorIndex = 3 End If Next I End Sub (did 10,000 rows in less than 1 second!) Paul From: ChrisInHolland gapp...@hotmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Fri, December 11, 2009 8:40:22 AM Subject: $$Excel-Macros$$ Alert for repeating cell information Hi, I'm trying to write some code that will create an alert when a particular string value is found more than once in a specified range. For exmple, in Col A i have: cat cat cat mouse dog dog I need a script that will count how many times I have cat written and if that value is 1 I want it to change the colour of the adjacent cell in Col B. I then want it to repeat this for mouse, dog and many 100's of other string values in Col A. In the above case the cells B1, B2, B3, B5 B6 would change colour but not B4. Any help on how I'd write this would be greatly appreciated! Being my first foray in VBA scripting I'm hopelessly outgunned when it comes to writing code for the above. What I've come up with so far is the following which works for finding only 1 string at a time (the one that I specify, A1 in below example. Specifying each string I want to search is not practical given many hundreds of search strings that will be present in Col A). Dim R As Integer Dim x As Integer Dim Cell As Range For Each Cell In Range(A1:A100) If InStr(1, Cell, [A1]) 0 Then R = 1 x = x + R End If Next Cell Range(E1) = x If x = 2 Then ActiveCell.Interior.ColorIndex = 3 End If -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads athttp://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 athttp://groups.google.com/group/excel-macros/subscribe -- -- 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
Re: $$Excel-Macros$$ Alert for repeating cell information
Many thanks for the responses! The two that have been provided work perfectly. Thanks also for the workbook, it's a brilliant starting point. I think I'll step into the shallow end from now on, not the deep end :) On Dec 12, 1:13 am, Dave Bonallack davebonall...@hotmail.com wrote: Hi Chris, You could do this with VBA, but it's better, and easier, done with conditional formatting. If you are using XL2003 or earlier, select Col B, then put this formula into conditional formating: =COUNTIF(A:A,A1)1 Set your format as desired. If you've not used conditional format before, read the Help, or write back to the group. If you're using XL2007, it's better not to use whole column refs, so you would need to specify a range something greater than your expected data. For example: =COUNTIF($A$1:$A$2000,A1)1 I've attached a workbook for you to look at. Regards - Dave Date: Fri, 11 Dec 2009 05:40:22 -0800 Subject: $$Excel-Macros$$ Alert for repeating cell information From: gapp...@hotmail.com To: excel-macros@googlegroups.com Hi, I'm trying to write some code that will create an alert when a particular string value is found more than once in a specified range. For exmple, in Col A i have: cat cat cat mouse dog dog I need a script that will count how many times I have cat written and if that value is 1 I want it to change the colour of the adjacent cell in Col B. I then want it to repeat this for mouse, dog and many 100's of other string values in Col A. In the above case the cells B1, B2, B3, B5 B6 would change colour but not B4. Any help on how I'd write this would be greatly appreciated! Being my first foray in VBA scripting I'm hopelessly outgunned when it comes to writing code for the above. What I've come up with so far is the following which works for finding only 1 string at a time (the one that I specify, A1 in below example. Specifying each string I want to search is not practical given many hundreds of search strings that will be present in Col A). Dim R As Integer Dim x As Integer Dim Cell As Range For Each Cell In Range(A1:A100) If InStr(1, Cell, [A1]) 0 Then R = 1 x = x + R End If Next Cell Range(E1) = x If x = 2 Then ActiveCell.Interior.ColorIndex = 3 End If -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads athttp://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 athttp://groups.google.com/group/excel-macros/subscribe _ Use Messenger in your Hotmail inbox Find out howhttp://windowslive.ninemsn.com.au/hotmail/article/823454/web-im-for-h... Chris.xls 19KViewDownload -- -- 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: Rota planning
I have now uploaded the file and would be grateful for any help. Thanks John On Dec 14, 1:31 pm, Paul schreiner_p...@att.net wrote: When you first go to the Google Groups page for this group, there is a files- area: http://groups.google.com/group/excel-macros?hl=en and a button to add afile. On Dec 14, 2:16 am, Tonto j...@jpwebs.co.uk wrote: Sheet did not attach - where do I do this please? John- 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
Re: $$Excel-Macros$$ VBA Security - Restrict Users from Editing VBA Macros
Anyways.. Thanks a to!! Dilipji On Mon, Dec 14, 2009 at 5:00 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Vinod, By line Remeber some software do not ask for serial keys. :) - I meant to say that there are some softwares which do not asks for serial key(s) as they don't have the relavant option to enter serial key. So these types of softwares are only be cracked / patched. Alternatively, you can purchase a software from open market. Further to this, I may not help you because If I had the dump + serial key of the software, I would have forwarded you the same. Thanks. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sun, Dec 13, 2009 at 7:14 PM, Dilip Pandey dilipan...@gmail.comwrote: Dear Vinod, There are many demo softwares/ tools available over internet which well help you to remove VBA password. To get the full version, either you can purchase them or search for the unlock key(s) if you get the respective option in tool. Remeber some software do not ask for serial keys. :) Thanks Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/9/09, Vinod N nvino...@gmail.com wrote: Hi, Can you suggest any site which will help me in breaking/cracking the password ? A year back i had created few macros..but ironically i have forgotten the password and the macros need to be changed with course of time and environment... Thanks Vinod N On Mon, Dec 7, 2009 at 5:34 AM, tianung tian...@hotmail.com wrote: Just playing the devil's advocate here - though most people wouldn't bother or know how to (and I'm sure Dilip is aware of this but has probably chosen to keep his reply short and concise), excelCPA should realise that there are various tools freely available on the internet which allow determined hackers to see and edit your VBA code despite your password. -- -- 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 -- 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 -- 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$$ VBA code - required - Printout directly from a folder
Hi Excel Gurus, Many image files(tif)(say 200 files) will be pasted in a particular folder through fax server and i need to take printout of the same and also keep a log/list of image that has been printed. Can a code be created such that i can click a button and the files from that printer are printed and the names and fax time of the image are added in an excel file If required, we can saved the excel file in the designated folder and then we can run the macro Please feel free to contact me in case i'm too vague in my criteria or any additional data is required -- 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
Re: $$Excel-Macros$$ VBA code to trace formula *
Hi dear, If you want to see formulla in excel sheet no need of macro just put one command (CTRL + ' (APOSTROPHE) Regards, Guru On Sun, Dec 13, 2009 at 1:03 PM, Sameh Hassan Alkadry shas...@kaegypt.comwrote: Junk Score: 3 out of 10 (below your Auto Allow thresholdhttps://www.boxbe.com/mail-screening) | Approve sender https://www.boxbe.com/anno?tc=1025210703_907851879 | Block sender https://www.boxbe.com/anno?tc=1025210703_907851879disp=b | Block domain https://www.boxbe.com/anno?tc=1025210703_907851879disp=bdom Hi, I need to verify calculation in sheet. So, I want to develop a VBA code can trace cells have formula and produce formula in its notation (where notation cell is the cell just on left side of the variable cell) Thanks, * * *Sameh * __ Information from ESET Smart Security, version of virus signature database 4682 (20091212) __ The message was checked by ESET Smart Security. http://www.eset.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 -- -- 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: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form
Hi Punnet, I missed an important thing in this file, would sent you corrected file shortly. Regards, AJ On Mon, Dec 14, 2009 at 4:35 PM, Abhishek Jain abhishek@gmail.comwrote: Hi Punit, Please see if attached file helps you. User Password - user User working range - B2:B10 Admin Password - admin Kind regards, Abhishek On Mon, Dec 14, 2009 at 10:42 AM, Abhishek Jain abhishek@gmail.comwrote: Hi Nandkumar, Well, I downloaded it (as a free user) - two rar files, extracted them, two more rar files, extracted them too - one exe file, VIRUS ALERT ! (glad to know my antivirus works!), exe gone, I deleted rest of the downloaded package. What is it anyway ? Some kind of lost password recovery toolkit ? and if it is, how's it going to help in this query ? Punit - I await your revert. Kind regards, AJ On Sun, Dec 13, 2009 at 10:49 PM, Zilla zill...@gmail.com wrote: You have to be a premium member to dload that file. On Dec 11, 8:42 pm, Nandkumar kakvipure nandkumar.hindust...@gmail.com wrote: Try Dis one http://rapidshare.com/files/106336650/LostPassword.Passware.Kit.Enter. .. On Fri, Dec 11, 2009 at 8:02 PM, Abhishek Jain abhishek@gmail.com wrote: Punit, What's the VBA password of your file ? You said you have done something in this file, is it the VBA ? Krgrds, AJ On Thu, Dec 10, 2009 at 12:29 PM, punit poddar p2pod...@gmail.com wrote: Hi The above file will be used by two person - User and the Administrator, administrator can edit anywhere, while the user can edit only in the range specified, based on this I have done something in the file attached but would help you guys to pls help. Please find attached the excel file. 1. Form that will be used to unlock only the current sheet, it will be better if we give the user option to change the password. 2. On closing the file the sheet will automatically gets locked. 3. Have give the user the option to edit only a small range of cells. Regards Punit -- -- 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 -- -- 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 -- -- 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: $$Excel-Macros$$ VBA code - required - Printout directly from a folder
MODULE1 Option Explicit 'In input box assign the path i.e c:\tc\bin 'for more help u can contact directly at rfhyd1...@gmail.com Sub Batch_Print() Dim Input_Dir, Print_File As String Input_Dir = InputBox _ (Input directory path containing the files to print) Print_File = Dir(Input_Dir \*.xl*) Do While Len(Print_File) 0 Workbooks.Open Filename:=Input_Dir \ Print_File ActiveWorkbook.PrintOut Copies:=1 ActiveWorkbook.Close Print_File = Dir() Loop End Sub 'MODULE2 Option Explicit Public Const KEY_ENUMERATE_SUB_KEYS = H8 Public Const HKEY_LOCAL_MACHINE = H8002 Public Const SUCCESS = 0 Type FILETIME dwLowDateTime As Long dwHighDateTime As Long End Type Declare Function RegOpenKeyEx Lib advapi32.dll Alias _ RegOpenKeyExA (ByVal hKey As Long, ByVal lpSubKey As _ String, ByVal ulOptions As Long, ByVal samDesired As _ Long, phkResult As Long) As Long Declare Function RegEnumKeyEx Lib advapi32.dll Alias _ RegEnumKeyExA (ByVal hKey As Long, ByVal dwIndex As _ Long, ByVal lpName As String, lpcbName As Long, ByVal _ lpReserved As Long, ByVal lpClass As String, lpcbClass _ As Long, lpftLastWriteTime As FILETIME) As Long Declare Function RegCloseKey Lib advapi32.dll _ (ByVal hKey As Long) As Long Public Sub GetInstalledPrinters(ByRef sPrinters() As _ String, ByRef cPrinters As Long) ' Sets cPrinters to the number of installed printers. ' Sizes and fills sPrinters array with the names ' of these printers. Dim ft As FILETIME Dim KeyHandle As Long Dim KeyName As String Dim KeyLen As Long Dim Response As Long On Error GoTo ERR_INSTALLED_PRINTERS ReDim sPrinters(1 To 5) cPrinters = 0 ' Open registry key whose subkeys are installed printers Response = RegOpenKeyEx(HKEY_LOCAL_MACHINE, SYSTEM\CurrentControlSet\Control\Print\Printers, 0, KEY_ENUMERATE_SUB_KEYS, KeyHandle) ' If Error display message and exit If Response SUCCESS Then MsgBox Could not open the registry key. Exit Sub End If ' Loop to get subkeys Do KeyLen = 1000 ' Plenty of room for printer name KeyName = String(KeyLen, 0) ' Fill with 0s Response = RegEnumKeyEx(KeyHandle, cPrinters, _ KeyName, KeyLen, 0, vbNullString, 0, ft) ' If unsuccessful, then exit If Response SUCCESS Then Exit Do ' Next free index cPrinters = cPrinters + 1 ' Make room if necessary If UBound(sPrinters) cPrinters Then ReDim Preserve sPrinters(1 To cPrinters + 5) End If ' Add to array sPrinters(cPrinters) = Left(KeyName, KeyLen) Loop RegCloseKey KeyHandle Exit Sub ERR_INSTALLED_PRINTERS: MsgBox Err.Description Exit Sub End Sub Sub DisplayInstalledPrinters() Dim sPrinters() As String Dim cPrinters As Long Dim i As Integer Dim msg As String ' Get the installed printers GetInstalledPrinters sPrinters(), cPrinters ' Create the message and display it msg = For i = 1 To cPrinters msg = msg sPrinters(i) vbCrLf Next i MsgBox msg, , cPrinters Printers End Sub On Tue, Dec 15, 2009 at 3:00 AM, Vinod N nvino...@gmail.com wrote: Hi Excel Gurus, Many image files(tif)(say 200 files) will be pasted in a particular folder through fax server and i need to take printout of the same and also keep a log/list of image that has been printed. Can a code be created such that i can click a button and the files from that printer are printed and the names and fax time of the image are added in an excel file If required, we can saved the excel file in the designated folder and then we can run the macro Please feel free to contact me in case i'm too vague in my criteria or any additional data is required -- 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 -- -- 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
Re: $$Excel-Macros$$ need help in excel
Thank you for all of my excel experts. On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote: Hi Friends, I have 2 excel file having 12 sheets in it, what I want is to merge two file into one. I tried using move or copy but it din't work. Is there any method. Please not that i have formula in both file -- Regards, Shilpa -- -- 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 -- -- 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: $$Excel-Macros$$ need help in excel
This info helped me too. On Tue, Dec 15, 2009 at 1:24 PM, vinod rao vinod.ma...@gmail.com wrote: Thank you for all of my excel experts. On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote: Hi Friends, I have 2 excel file having 12 sheets in it, what I want is to merge two file into one. I tried using move or copy but it din't work. Is there any method. Please not that i have formula in both file -- Regards, Shilpa -- -- 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 -- -- 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