Re: $$Excel-Macros$$ VBA to detect drive
VB 6.0 1 Add DriveListBox 2.Add DirListBox 3.Add FileListBox Resize your above tools on form according to your need. ''' write the code in coding window ''' Private Sub Drive1_Change() On Error GoTo Drivehandler Dir1.Path = Drive1.Drive Exit Sub Drivehandler: MsgBox Sorry but the drive you are trying to access is not available. End Sub ''' Private Sub Dir1_Change() File1.Path = Dir1.Path End Sub ''' '''This is useful accessing by VB Form. Hope it will Help :) Shyam On Mon, Apr 5, 2010 at 9:36 AM, Dave Bonallack davebonall...@hotmail.com wrote: Hi Harry, Further to what is below; If you want VBA to recognise a paticular pen drive to the exclusion of any other pen drive that might be plugged in, put a unique folder or two on your pendrive and ask VBA to look for that path. eg: ChDirG:\HarrysUniqueFolder\HUFSubFolder1 If VBA doesn't find that exact path, the same error 76 will be raised. Regards - Dave. From: davebonall...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ VBA to detect drive Date: Mon, 5 Apr 2010 11:59:41 +0800 Hi Harry, The following code line will raise a 'Run-time error 76' error message if Drive G is not present: ChDir G: VBA can use this to make a decision. Here is a sample code: Sub changedir() On Error GoTo ErrorHandler ChDir G: ' Your normal code goes here Exit Sub ErrorHandler: If Err.Number = 76 Then MsgBox Drive G not present End Sub Hope this is helpful. Regards - Dave. Date: Sun, 4 Apr 2010 17:44:55 +0530 Subject: $$Excel-Macros$$ VBA to detect drive From: harpreetguj...@gmail.com To: excel-macros@googlegroups.com Hi Gurus, Would it be possible to have VBA code to detect, whether a drive is attached to the computer or not? The idea is to achieve the following objectives: 1) To detect, removable Pen Drive/Hard drive has been attached with the computer or not? Eg: When i attach a pen drive on my PC it shows up as G Drive. 2) Is there a possibility to check, the validity of the drive i.e. any unique number that recognises a particular Pen Drive or somthing? Thanks Harry -- -- 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 Looking for a hot date? View photos of singles in your area! -- -- 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 Meet local singles online. Browse profiles for FREE! --
Re: $$Excel-Macros$$ 12 secret shortcuts of Excel
Dear Group, Ayush , Ashish All Persons involved in helping Group, I really congratulate for making this an Our Group. Thanks a lot for all helps stuff which i get daily. Its been few months i am associated with this group but learned a lot, I hope moving forward i will become more flexible and also try my level best to post some tips to the users. Thank you all, Sincerely, Sarojkumar. Kabir On Mon, Apr 5, 2010 at 9:44 AM, OSAVentures Calamba osav...@gmail.comwrote: Great Kudos and blessing to Ayush Jain. You will have a great legacy for helping others and sharing your candlelight. Indeed, sharing your light with others do not diminish its brightness but multiply it. On Fri, Apr 2, 2010 at 11:26 PM, ayush jain jainayus...@gmail.com wrote: Dear Members, Thanks for all your contribution to the group. The group has successfully completed three years. On this occasion, I would like to launch an eBook on excel shortcuts written by me recently. * Through this eBook I want to show some powerful shortcuts so you become more productive and efficient at work.* I hope this eBook will help you. Please let me know your feedback. Please share this *free eBook* with your friends and colleagues and help spreading the word. Thanks. Keep Posting!! Best regards, Ayush Jain Group Manager http://discussexcel.com/ P.S. The book is also available in files section of group. -- -- 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 -- -- 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 -- -- 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, reply using remove me as the subject.
$$Excel-Macros$$ Help Required
Dear Group, Please help me to create Function for below Problam Help books,Procedure to create udf's 20100312=12-mar-2010 * Thanks Regards, Venkat C* -- -- 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
Re: $$Excel-Macros$$ Help Required
Hi Venkat, Please use the below formula to get the desired output. Attached is the excel sheet for your reference. *=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))* Thanks and best regards, Ayush Jain On Mon, Apr 5, 2010 at 1:14 PM, Venkatesan c venkat1@gmail.com wrote: Dear Group, Please help me to create Function for below Problam Help books,Procedure to create udf's 20100312=12-mar-2010 * Thanks Regards, Venkat C * -- -- 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 -- Best regards, Ayush Jain -- -- 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, reply using remove me as the subject. sql.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ 12 secret shortcuts of Excel
Dear All, This post is really helpful for beginers.Appriciate to provide us a beautiful e-book. On Mon, Apr 5, 2010 at 11:29 AM, saroj.32006 saroj.32...@gmail.com wrote: Dear Group, Ayush , Ashish All Persons involved in helping Group, I really congratulate for making this an Our Group. Thanks a lot for all helps stuff which i get daily. Its been few months i am associated with this group but learned a lot, I hope moving forward i will become more flexible and also try my level best to post some tips to the users. Thank you all, Sincerely, Sarojkumar. Kabir On Mon, Apr 5, 2010 at 9:44 AM, OSAVentures Calamba osav...@gmail.com wrote: Great Kudos and blessing to Ayush Jain. You will have a great legacy for helping others and sharing your candlelight. Indeed, sharing your light with others do not diminish its brightness but multiply it. On Fri, Apr 2, 2010 at 11:26 PM, ayush jain jainayus...@gmail.com wrote: Dear Members, Thanks for all your contribution to the group. The group has successfully completed three years. On this occasion, I would like to launch an eBook on excel shortcuts written by me recently. Through this eBook I want to show some powerful shortcuts so you become more productive and efficient at work. I hope this eBook will help you. Please let me know your feedback. Please share this free eBook with your friends and colleagues and help spreading the word. Thanks. Keep Posting!! Best regards, Ayush Jain Group Manager http://discussexcel.com/ P.S. The book is also available in files section of group. -- -- 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 -- -- 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 -- -- 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 -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
$$Excel-Macros$$ hi-help required .
hi i have a worksheet where sizes and qty are maintained for each item in this way 460*12 Pet 31 460*12 Pet 265 460*12 Pet 340 460*12 Pet 392 460*12 Pet 523 460*12 Pet 150 470*12 Pet 35 470*12 Pet 212 470*12 Pet 159 480*12 Pet 131 480*12 Pet 7 480*12 Pet 56 480*12 Pet 12 480*12 Pet 91 daily some sizes and qty are added , deleted, modified. i need to know the total requirement of each size eg: 480*12 pet =+131+7+56+12+91 which is 297. same way need for all the sizes. the list is very big. i am not familiar with macros , any other formulae based solution will be helpful. thanks regards,sarvesh lahoti. The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ -- -- 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$$ Importing Text file
Dear All, Need ur advise... I got around 20 text files in a day,which had 13 to 15 columns separated by | this sign. each file contains around 15 lacs or more line items. when i import that text file in excel 2007, it takes the first 10 lacs records; rest does not come. Need ur help to solve this, I want that rest records should move to next sheet of the same workbook -- With Love, Mahesh Bisht -- -- 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, reply using remove me as the subject.
Re: $$Excel-Macros$$ Importing Text file
Hello Dear, This problem is alredy discussed in previous post. try to find out importing txt from notepad to excel. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 2:37 PM, Mahesh mahender.bi...@gmail.com wrote: Dear All, Need ur advise... I got around 20 text files in a day,which had 13 to 15 columns separated by | this sign. each file contains around 15 lacs or more line items. when i import that text file in excel 2007, it takes the first 10 lacs records; rest does not come. Need ur help to solve this, I want that rest records should move to next sheet of the same workbook -- With Love, Mahesh Bisht -- -- 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 -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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, reply using remove me as the subject.
Re: $$Excel-Macros$$ Importing Text file
Hello Dear, Here is the attached macro for your problem. Here string are picked after tab or new line. u can make change if string are separated by any special character. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 5:06 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear, This problem is alredy discussed in previous post. try to find out importing txt from notepad to excel. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 2:37 PM, Mahesh mahender.bi...@gmail.com wrote: Dear All, Need ur advise... I got around 20 text files in a day,which had 13 to 15 columns separated by | this sign. each file contains around 15 lacs or more line items. when i import that text file in excel 2007, it takes the first 10 lacs records; rest does not come. Need ur help to solve this, I want that rest records should move to next sheet of the same workbook -- With Love, Mahesh Bisht -- -- 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 -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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, reply using remove me as the subject. Importing txt to Excel.rar Description: Binary data
Re: $$Excel-Macros$$ Worksheets password break
Hello Dear, Vishal has provide awesom programming technique to do the same job. for your more requirement i am sending you addins.just open it at then that workbook,which have password protection. Follow the instruction.it is easy and safe. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 12:37 AM, Nishant Sharma leonish...@gmail.com wrote: On Sun, Apr 4, 2010 at 2:51 AM, Vishal Parihar vish.pari...@gmail.com wrote: Hi Friends is there any vba code to break excel file which has a password to open Thanks Nishant Today i am going to show you how to crack excel sheets password. Vba code to break password. Sub PasswordBreaker() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 ActiveSheet.Unprotect Chr(i) Chr(j) Chr(k) _ Chr(l) Chr(m) Chr(i1) Chr(i2) Chr(i3) _ Chr(i4) Chr(i5) Chr(i6) Chr(n) If ActiveSheet.ProtectContents = False Then MsgBox Tata sky laga dala life will be jiga lala Range(a1).Value = Tata sky laga dala life will be jiga lala Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub I hope i like this one. Regards Vishal Parihar 9910415530 vish.pari...@gmail.com -- -- 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, reply using remove me as the subject. -- -- 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 -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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
Re: $$Excel-Macros$$ Importing Text file
Import the text file to Access. Then based on the criteria, Import the records to Excel. thanks and Regards, Anand On Mon, Apr 5, 2010 at 2:37 PM, Mahesh mahender.bi...@gmail.com wrote: Dear All, Need ur advise... I got around 20 text files in a day,which had 13 to 15 columns separated by | this sign. each file contains around 15 lacs or more line items. when i import that text file in excel 2007, it takes the first 10 lacs records; rest does not come. Need ur help to solve this, I want that rest records should move to next sheet of the same workbook -- With Love, Mahesh Bisht -- -- 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 -- When everything fails Patience will win -- -- 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, reply using remove me as the subject.
$$Excel-Macros$$ Need urgent help.
Hi All, The way this network is responding and working is amazing. I have many learnt new tips out of this network. . Also I want to express myself that I am looking for a change. Am a Quality Ananlyst. 70% of my work is on excle. Your help in this matter will be highly appreciated. I am based in Pune. My contact No is 9370125136. Thanks, Baby Patel -- -- 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, reply using remove me as the subject.
Re: $$Excel-Macros$$ Importing Text file
Sub ImportData() Dim I As Long Dim Filename As String I = 1 Filename = C:\Documents and Settings\akoul\Desktop\my desktop\TESTSPLIT.txt Open Filename For Input As #1 Do While (Not EOF(1)) Input #1, Streng Cells(I, 1) = Split(Streng) I = I + 1 If I = 1048575 Then '- DELIMIT THE DATA Columns(A:A).Select Selection.TextToColumns Destination:=Range(B1), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _ :=|, _ TrailingMinusNumbers:=True Range(B1).Select ' INSERTING A NEW SHEET Sheets.Add After:=Sheets(Sheets.Count) I = 1 End If Loop '- DELIMIT THE DATA Columns(A:A).Select Selection.TextToColumns Destination:=Range(B1), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _ :=|, _ TrailingMinusNumbers:=True Range(B1).Select Close #1 End Sub On Mon, Apr 5, 2010 at 5:06 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear, This problem is alredy discussed in previous post. try to find out importing txt from notepad to excel. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 2:37 PM, Mahesh mahender.bi...@gmail.com wrote: Dear All, Need ur advise... I got around 20 text files in a day,which had 13 to 15 columns separated by | this sign. each file contains around 15 lacs or more line items. when i import that text file in excel 2007, it takes the first 10 lacs records; rest does not come. Need ur help to solve this, I want that rest records should move to next sheet of the same workbook -- With Love, Mahesh Bisht -- -- 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 -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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, reply using remove me as the subject. -- -- 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.
Re: $$Excel-Macros$$ Help: OUTLOOK VBA
Hello Dear, Please reply with full information.What you want to do... 1.send mail from excel 2.send attachment from excel 3.send attachment as current sheet or workbook ,using excel Every code are different,i.e for different different purpose codes are different. So please feel free to let us know. Option Explicit '''To Send Mail Simply Use This Code' Sub Email_This() ActiveWorkbook.SendMail recipients:=rfhyd1...@gmail.com End Sub Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 12:09 AM, janet dickson janetdicks...@gmail.com wrote: Hello Team Sorry for asking things out EXCEL, can anyone share sites/groups for MS OUTLOOK. Much regards -- -- 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 -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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, reply using remove me as the subject.
Re: $$Excel-Macros$$ Worksheets password break
Hello Dear, I can try,i will let you as soon as possible. Please wait for next post. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 4:55 PM, kumara datta yagneswara hkda...@gmail.com wrote: Hi Frnds, Can any one break this file's password. Thanks Regards, Kumara Datta. On Mon, Apr 5, 2010 at 12:37 AM, Nishant Sharma leonish...@gmail.com wrote: On Sun, Apr 4, 2010 at 2:51 AM, Vishal Parihar vish.pari...@gmail.com wrote: Hi Friends is there any vba code to break excel file which has a password to open Thanks Nishant Today i am going to show you how to crack excel sheets password. Vba code to break password. Sub PasswordBreaker() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 ActiveSheet.Unprotect Chr(i) Chr(j) Chr(k) _ Chr(l) Chr(m) Chr(i1) Chr(i2) Chr(i3) _ Chr(i4) Chr(i5) Chr(i6) Chr(n) If ActiveSheet.ProtectContents = False Then MsgBox Tata sky laga dala life will be jiga lala Range(a1).Value = Tata sky laga dala life will be jiga lala Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub I hope i like this one. Regards Vishal Parihar 9910415530 vish.pari...@gmail.com -- -- 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, reply using remove me as the subject. -- -- 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 -- -- 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 -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
Re: $$Excel-Macros$$ Worksheets password break
Hello Dear Try to use tools-- unprotect workbook tools--unprotect sheets tools--unprotect share workbook Password is abc123 Remember this password while working on that workbook. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 5:47 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear, I can try,i will let you as soon as possible. Please wait for next post. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 4:55 PM, kumara datta yagneswara hkda...@gmail.com wrote: Hi Frnds, Can any one break this file's password. Thanks Regards, Kumara Datta. On Mon, Apr 5, 2010 at 12:37 AM, Nishant Sharma leonish...@gmail.com wrote: On Sun, Apr 4, 2010 at 2:51 AM, Vishal Parihar vish.pari...@gmail.com wrote: Hi Friends is there any vba code to break excel file which has a password to open Thanks Nishant Today i am going to show you how to crack excel sheets password. Vba code to break password. Sub PasswordBreaker() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 ActiveSheet.Unprotect Chr(i) Chr(j) Chr(k) _ Chr(l) Chr(m) Chr(i1) Chr(i2) Chr(i3) _ Chr(i4) Chr(i5) Chr(i6) Chr(n) If ActiveSheet.ProtectContents = False Then MsgBox Tata sky laga dala life will be jiga lala Range(a1).Value = Tata sky laga dala life will be jiga lala Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub I hope i like this one. Regards Vishal Parihar 9910415530 vish.pari...@gmail.com -- -- 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, reply using remove me as the subject. -- -- 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 -- -- 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 -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller
Re: $$Excel-Macros$$ Need urgent help.
Hello Dear, 1'st welcome in our group,we are giving helping hands to vba programmers. 2'ns please let us better understand your problem,do u want to change domain (looking for job) OR Do you want to be a master in VBA. Please make us understand the problem first. Hope it Will Help Happy To Help :) Shyam On Mon, Apr 5, 2010 at 4:32 PM, Baby Patel smritipatel2...@gmail.com wrote: Hi All, The way this network is responding and working is amazing. I have many learnt new tips out of this network. . Also I want to express myself that I am looking for a change. Am a Quality Ananlyst. 70% of my work is on excle. Your help in this matter will be highly appreciated. I am based in Pune. My contact No is 9370125136. Thanks, Baby Patel -- -- 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 -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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, reply using remove me as the subject.
Re: $$Excel-Macros$$ Filtering in Excel
Hello Dear, No need to thanks,we are here to give the helping hands to our vba programmers. Hope it will help Happy to Help :) Shyam On Fri, Apr 2, 2010 at 5:01 AM, Dipika Mallya blraspirants...@gmail.com wrote: Hi thanks for pointing out the bug, its http://anonomi.com/iname Also if the topicstarter can provide the raw data it would be helpful is cusotmizing acc. to need. Now it is like working blind. Any in depth solution pls free to contact in link. On 4/1/10, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear, I have checked your provided link.It is showing spam free e mail registration. http://anonomi.com/about/ Now for the topic asked before. Shimmy you can try dependent list.Reply me if you are new and want more information. Hope it Will Help Happy to Help :) Shyam On Thu, Apr 1, 2010 at 4:19 PM, Dipika Mallya blraspirants...@gmail.com wrote: write in here: http://anonomi.com/DM yourorgname.net/branch/div/emplmgr/mgr/smgr/jmgr/sup/sub in excel format. On Wed, Mar 31, 2010 at 6:36 PM, Shimmy morur...@gmail.com wrote: Hello EXCEL_lent people. I am working for an emerging organisation/company. I would like to create a spreadsheet in Excel for my rganisation in which different components and their activities will be filtered like in the said spreadsheet like this: There is one organisation, with 9 components. Each component has three Division. Each Division has 6 Senior Managers. Under every Senior manager there are 3 Emerging managers. Under every emerging manager there is 2 supervisors. And under every supervisor there are 15 staff members. Can someone help me create a filter for this -- -- 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, reply using remove me as the subject. -- -- 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 -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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
$$Excel-Macros$$ help
Dear All, How can protect the file with vba passward ? -- Thanks For Mail. -- -- 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
Re: $$Excel-Macros$$ help
Hi Jai, Please follow the below steps to protect the file with VBA password : 1) Open Excel file 2) Press ALT + F11 to open Visual basic editor 3) In Project Explorer, right click on Microsoft Excel objects in tree view. 4) Select VBA Project properties 5) Select Protection Tab and check the 'Lock project for viewing' option. 6) Provide the password and confirm password 7) Click Ok...save ...close Open the file again to Test the password . Please let us know if any further assistance is required. Thanks and best regards, Ayush Jain On Mon, Apr 5, 2010 at 6:44 PM, Jai jaihumtu...@gmail.com wrote: Dear All, How can protect the file with vba passward ? -- Thanks For Mail. -- -- 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 -- Best regards, Ayush Jain -- -- 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, reply using remove me as the subject.
$$Excel-Macros$$ Excel Create List Must Be On The Active Worksheet
When I try to create a list and refer to another sheet, I get the below error! How can I get it to work. A working example would be useful. Where is the data for your list? ='test'!$D$1:$CC$3000 Error: The worksheet range for the list data must be on the active worksheet. Chris -- -- 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, reply using remove me as the subject.
$$Excel-Macros$$ Re: Find and Replace with an entire line from a another worksheet
Hi...I applied this code, and nothing happened. I think I may need more instruction. You mentioned variablesI have 857 different numbers in sheet A (QB) that I need to find the corresponding number and line of data in Sheet B (EST) which has over 3800 lines of data. I recorded the actions, I just need it to advance one cell down, and continue through the page. On Apr 4, 2:31 am, paulwillekens paul.johan.willek...@gmail.com wrote: Hi JavaOnLine This method works always and you can insert any specific criteria without limit... Good luck. Let me know if it was useful... Paul Willekens '=== Sub ESTSearch() Dim cValue Dim lDoneA Dim lDoneB Dim nNumberA Dim nNumberB Dim nRowA Dim nRowB nRowA = 2 lDoneA = False Sheets(QB).Select While Not lDoneA nNumberA = Cells(nRowA, 1).Value If IsEmpty(nNumberA) Then lDoneA = True Else Sheets(EST).Select nRowB = 2 lDoneB = False cValue = While Not lDoneB nNumberB = Cells(nRowB, 1).Value If IsEmpty(nNumberB) Then lDoneB = True ElseIf nNumberB = nNumberA Then cValue = Cells(nRowB, 2) lDoneB = True Else nRowB = nRowB + 1 End If Wend Sheets(QB).Select If Not cValue = Then Cells(nRowA, 2) = cValue End If nRowA = nRowA + 1 End If Wend End Sub '=== -- -- 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, reply using remove me as the subject.
Re: $$Excel-Macros$$ Excel Create List Must Be On The Active Worksheet
Hi Chris, You need to define the name for this range and then use INDIRECT function to call the range. Define 'test'!$D$1:$CC$3000 range as TEST (range name) Use =Indirect(TEST) formula to get the desired result. Let us know if any further assistance is required. Thanks and best regards, Ayush Jain On Mon, Apr 5, 2010 at 8:35 PM, ChristopherL clusard...@aol.com wrote: When I try to create a list and refer to another sheet, I get the below error! How can I get it to work. A working example would be useful. Where is the data for your list? ='test'!$D$1:$CC$3000 Error: The worksheet range for the list data must be on the active worksheet. Chris -- -- 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, reply using remove me as the subject. -- Best regards, Ayush Jain -- -- 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
Re: $$Excel-Macros$$ Excel Create List Must Be On The Active Worksheet
When I tried the below code, for Define I got the Compile error: Sub or Function not defined Public Sub auto_open Define 'test'!$D$1:$CC$3000 range as TEST (range name) End Sub Chris On Apr 5, 8:28 am, ayush jain jainayus...@gmail.com wrote: Hi Chris, You need to define the name for this range and then use INDIRECT function to call the range. Define 'test'!$D$1:$CC$3000 range as TEST (range name) Use =Indirect(TEST) formula to get the desired result. Let us know if any further assistance is required. Thanks and best regards, Ayush Jain On Mon, Apr 5, 2010 at 8:35 PM, ChristopherL clusard...@aol.com wrote: When I try to create a list and refer to another sheet, I get the below error! How can I get it to work. A working example would be useful. Where is the data for your list? ='test'!$D$1:$CC$3000 Error: The worksheet range for the list data must be on the active worksheet. Chris -- ------ 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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, reply using remove me as the subject. -- Best regards, Ayush Jain- 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 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
Re: $$Excel-Macros$$ Assistance required
ok, Prathap, let's start with the following macro: months without sales but with stock increase will get colored... is this what you want: highlight it? greetings Paul Willekens '=== Sub StockAnalysis() Dim lDone Dim nCol Dim nMonth Dim nRow nRow = 2 lDone = False While Not lDone For nMonth = 0 To 7 'first column in month nCol = 2 + nMonth * 4 'reset colors to white Cells(nRow, nCol).Interior.ColorIndex = 2 Cells(nRow, (nCol + 1)).Interior.ColorIndex = 2 Cells(nRow, (nCol + 2)).Interior.ColorIndex = 2 Cells(nRow, (nCol + 3)).Interior.ColorIndex = 2 'nothing dispatched? If Cells(nRow, (nCol + 2)).Value = 0 Then 'but still purchased? If Cells(nRow, (nCol + 1)).Value 0 Then Cells(nRow, nCol).Interior.ColorIndex = 19 Cells(nRow, (nCol + 1)).Interior.ColorIndex = 36 Cells(nRow, (nCol + 2)).Interior.ColorIndex = 44 Cells(nRow, (nCol + 3)).Interior.ColorIndex = 38 End If End If Next nRow = nRow + 1 If Len(Cells(nRow, 1).Value) 1 Then lDone = True End If Wend End Sub '=== -- -- 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, reply using remove me as the subject.
Re: $$Excel-Macros$$ Share Tips and Tricks
Hi All - Can you please share any presentation on Excel 2007 - Home tab? Regards -- -- 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, reply using remove me as the subject.
$$Excel-Macros$$ Re: Find and Replace with an entire line from a another worksheet
Hi Java, If your specifications are vague, then I can only speculate and simplify... I assumed first row contains column headings, so I start on row 2 (you can change that if necessary) in both sheets... I assumed the numbers to match are located in both sheets in the first column [if not, you can change that e.g. if in the sheet EST column 3 then nNumberB = Cells(nRowB, 3).Value ] I assumed you want data from the secund column from EST to get copied to QB (secund column) in case of a match... if there is more, then add such statements as cValue1 = Cells(nRowB, 3) cValue2 = Cells(nRowB, 4) etc. and Cells(nRowA, 3) = cValue1 Cells(nRowA, 4) = cValue2 etc. Or you could send a consistent test workbook and I'll further write it for you... Kind regards, Paul Willekens -- -- 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$$ Re: Help: OUTLOOK VBA
Hi Janet, Do I understand you differently from rf1234: you are looking for a group for OUTLOOK VBA instead of EXCEL VBA, not just for sending mail from an excel macro ? I made some macro's in Outlook... shoot your problem, we'll see, because VBA is not that different. Greetings Paul Willekens -- -- 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, reply using remove me as the subject.
$$Excel-Macros$$ Re: Modifying input data
Hi Hapreet, I agree with Seema: import with delimiter semicolon and the first sheet RAW DATA becomes easier. If it is still very cumbersome for you to convert this Seema-Raw Data to the Modified data sheet, tell me and I'll make it in the blink of an eye... Kind regards, Paul Willekens -- -- 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, reply using remove me as the subject.
Re: $$Excel-Macros$$ help
Hello Dear, if you are looking to permanently lock the project,i think there is no way. because using hex editor you can break the password.actually i am also looking to lock my project which can not be broke using hex editor. Hope it Will Help Happy To Help :) Shyam On Mon, Apr 5, 2010 at 7:57 PM, ayush jain jainayus...@gmail.com wrote: Hi Jai, Please follow the below steps to protect the file with VBA password : 1) Open Excel file 2) Press ALT + F11 to open Visual basic editor 3) In Project Explorer, right click on Microsoft Excel objects in tree view. 4) Select VBA Project properties 5) Select Protection Tab and check the 'Lock project for viewing' option. 6) Provide the password and confirm password 7) Click Ok...save ...close Open the file again to Test the password . Please let us know if any further assistance is required. Thanks and best regards, Ayush Jain On Mon, Apr 5, 2010 at 6:44 PM, Jai jaihumtu...@gmail.com wrote: Dear All, How can protect the file with vba passward ? -- Thanks For Mail. -- -- 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 -- Best regards, Ayush Jain -- -- 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 -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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, reply using remove me as the subject.
Re: $$Excel-Macros$$ Share Tips and Tricks
Hello Dear, Please reply with Confirmation,what u r looking for home tab. we can help better,when we will understand the exact problem. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 10:03 PM, Manisha Jain manishakothari.j...@gmail.com wrote: Hi All - Can you please share any presentation on Excel 2007 - Home tab? Regards -- -- 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 -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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, reply using remove me as the subject.
Re: $$Excel-Macros$$ Excel Create List Must Be On The Active Worksheet
Hello Dear, try to insert name define ='test'!$D$1:$C1$3000 Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 9:26 PM, ChristopherL clusard...@aol.com wrote: When I tried the below code, for Define I got the Compile error: Sub or Function not defined Public Sub auto_open Define 'test'!$D$1:$CC$3000 range as TEST (range name) End Sub Chris On Apr 5, 8:28 am, ayush jain jainayus...@gmail.com wrote: Hi Chris, You need to define the name for this range and then use INDIRECT function to call the range. Define 'test'!$D$1:$CC$3000 range as TEST (range name) Use =Indirect(TEST) formula to get the desired result. Let us know if any further assistance is required. Thanks and best regards, Ayush Jain On Mon, Apr 5, 2010 at 8:35 PM, ChristopherL clusard...@aol.com wrote: When I try to create a list and refer to another sheet, I get the below error! How can I get it to work. A working example would be useful. Where is the data for your list? ='test'!$D$1:$CC$3000 Error: The worksheet range for the list data must be on the active worksheet. Chris -- ------ 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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, reply using remove me as the subject. -- Best regards, Ayush Jain- 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 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 -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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
Re: $$Excel-Macros$$ Re: Help: OUTLOOK VBA
Hello Dear i am unable to understand this phase Do I understand you differently from rf1234 please let us know. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 10:28 PM, paulwillekens paul.johan.willek...@gmail.com wrote: Hi Janet, Do I understand you differently from rf1234: you are looking for a group for OUTLOOK VBA instead of EXCEL VBA, not just for sending mail from an excel macro ? I made some macro's in Outlook... shoot your problem, we'll see, because VBA is not that different. Greetings Paul Willekens -- -- 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, reply using remove me as the subject. -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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$$ Event driven Macro
Is there a way to run a macro based on an event? I want to be able to run about 10 SQL statements based on the value in a particular table, lets say table A. Step01: If the value in table A is 1, I want to run the 10 SQL statements Step02: If the value in table A is 0, then wait about 15 min and check for the value again. If the value now is 1, then go to Step01 Thanks for your help. -- -- 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, reply using remove me as the subject.
Re: $$Excel-Macros$$ Excel Create List Must Be On The Active Worksheet
Hello, I am stilling getting the error message: The worksheet range for the list must be on the active worksheet. This is what I did: (1) On first tab: Choose from menu Insert, Name, Define As the name I typed in TEST I selected a range of cells on tab TEST and it appears in the Refers To box close the window (2) On second tab after selecting a range of cells: Choose from menu Data, List, Create List I typed in =Indirect(TEST) Chris On Apr 5, 8:28 am, ayush jain jainayus...@gmail.com wrote: Hi Chris, You need to define the name for this range and then use INDIRECT function to call the range. Define 'test'!$D$1:$CC$3000 range as TEST (range name) Use =Indirect(TEST) formula to get the desired result. Let us know if any further assistance is required. Thanks and best regards, Ayush Jain On Mon, Apr 5, 2010 at 8:35 PM, ChristopherL clusard...@aol.com wrote: When I try to create a list and refer to another sheet, I get the below error! How can I get it to work. A working example would be useful. Where is the data for your list? ='test'!$D$1:$CC$3000 Error: The worksheet range for the list data must be on the active worksheet. Chris -- ------ 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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, reply using remove me as the subject. -- Best regards, Ayush Jain- 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 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
Re: $$Excel-Macros$$ Excel Create List Must Be On The Active Worksheet
Jane, it appears to be working when I use Data, validation instead of Data, List, Creat List Thank you if this is correct On Apr 5, 11:30 am, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear, try to insert name define ='test'!$D$1:$C1$3000 Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 9:26 PM, ChristopherL clusard...@aol.com wrote: When I tried the below code, for Define I got the Compile error: Sub or Function not defined Public Sub auto_open Define 'test'!$D$1:$CC$3000 range as TEST (range name) End Sub Chris On Apr 5, 8:28 am, ayush jain jainayus...@gmail.com wrote: Hi Chris, You need to define the name for this range and then use INDIRECT function to call the range. Define 'test'!$D$1:$CC$3000 range as TEST (range name) Use =Indirect(TEST) formula to get the desired result. Let us know if any further assistance is required. Thanks and best regards, Ayush Jain On Mon, Apr 5, 2010 at 8:35 PM, ChristopherL clusard...@aol.com wrote: When I try to create a list and refer to another sheet, I get the below error! How can I get it to work. A working example would be useful. Where is the data for your list? ='test'!$D$1:$CC$3000 Error: The worksheet range for the list data must be on the active worksheet. Chris -- ------ 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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, reply using remove me as the subject. -- Best regards, Ayush Jain- 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 Facebook Group @http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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 athttp://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer '''''' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '''''' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller ''''''- 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 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
Re: $$Excel-Macros$$ Re: Help: OUTLOOK VBA
Hi Shyam, I mean the following: I understand what Janet wrote in a different way than you. I had the impression that you assume that Janet wants something from Excel, but I think he/she wants VBA macros for Outlook (not for Excel)... regards Paul Willekens -- -- 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, reply using remove me as the subject.
$$Excel-Macros$$ Re: Find and Replace with an entire line from a another worksheet
Thanks Paul, I'm not sure I was being thorough enough with my explanation. In any case...Through trial and error today I kept working at it, and this is what I've come up with. It looks like it's providing me with what I need. Maybe it will be of help to someone else. Sub ESTSearch() Do Until ActiveCell.Value = Blank On Error GoTo ErrorProc Application.ScreenUpdating = False Sheets(QB).Select Var = ActiveCell.Value Sheets(EST).Select Columns(BP:BP).Select Selection.Find(What:=Var, After:=ActiveCell).Activate ActiveCell.EntireRow.Select Selection.Copy Destination:=Sheets(Results).Range(A65536).End(xlUp)(2) Search1: Sheets(QB).Select ActiveCell.Offset(1, 0).Select Loop ErrorProc: Sheets(QB).Select Var = ActiveCell.Value Selection.Copy Destination:=Sheets(Results).Range(A65536).End(xlUp)(2) If ActiveCell.Value = Then Exit Sub End If Resume Search1: End Sub On Apr 5, 12:50 pm, paulwillekens paul.johan.willek...@gmail.com wrote: Hi Java, If your specifications are vague, then I can only speculate and simplify... I assumed first row contains column headings, so I start on row 2 (you can change that if necessary) in both sheets... I assumed the numbers to match are located in both sheets in the first column [if not, you can change that e.g. if in the sheet EST column 3 then nNumberB = Cells(nRowB, 3).Value ] I assumed you want data from the secund column from EST to get copied to QB (secund column) in case of a match... if there is more, then add such statements as cValue1 = Cells(nRowB, 3) cValue2 = Cells(nRowB, 4) etc. and Cells(nRowA, 3) = cValue1 Cells(nRowA, 4) = cValue2 etc. Or you could send a consistent test workbook and I'll further write it for you... Kind regards, Paul Willekens -- -- 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, reply using remove me as the subject.
$$Excel-Macros$$ Help on this please
I have uploaded the file collection_ver2.xls. Its very hard to put in words but I am trying below: I created this worksheet to track the payments amounts as collected and applied to various outstanding balances. I start with Beginning Amount which is the outstanding moneys owed. the time periods involved these are s manually entered by the collector. This Beginning Amount owed generates interest based on the period of days 15% / Year penalty (5% of beginning amount is carried over until paid) collection fees (Agency Collection Fees are a flat 4,125 9% 27% of the Beginning Amount for the periods . There could be more than one collection agency involved in the payoff process. (later on this) I first take out the collection fee percentage of the Beginning payment, If there is a remaining balance than I apply this towards the Beginning Amount if there is any money left over after the payment of the Beginning Amount than penalty fee is paid and if there are funds available after the payment of the penalty fee than the interest is paid.Rules of payments are: Collection Fee than, Beginning amount than Penalty then Interest. In the attached example in Period 1, $250.00 is received towards the Beginning Amount of $1700.00. Based upon the Beginning Amount of $1700.00 a collection fee of $70.13 is realized for Ace Corp, A penalty of $85 is incurred interest of $111.08 is accumulated. After applying the $250 to the collection fee for Ace corp then I take the $179.00 and subtract it from the Beginning Amount of $1700 and get the balance of $1520.00. As at this time my Beginning Amount of $250.00 has run out nothing is applied to the Penalty and Interest. Penalty is carried along and interest is accumulated period to period.. This process is repeated until all balances are paid of as in Period 11. I have the following problems I need help in solving them. 1st: Collection agency can be different for each period. Right now I have to manually change the formula etc to accommodate this. I need a macro or something that can prompt the collector to enter the collection agency name and then calculate and plug in the values. And apply the calculated amount to the Beginning Amount. 2nd: Another issues is with when e.g. in period 9 Beginning Amount goes negative I Period 10 penalty amount goes negative I need a macro or something to automatically switch over to the next collection item and follow through. Until all 4 categories are completely paid for. If there is a final negative amount it would be the refund owed to the payer. Thanks for all your help guidance. -- -- 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
RE: $$Excel-Macros$$ Excel Create List Must Be On The Active Worksheet
Hi, If you select List in the Allow: dropdown on the Settings tab of the Data Validation window, you don't need to use the indirect function. Just =TEST in the list window will do. Regards - Dave. From: jainayus...@gmail.com Date: Mon, 5 Apr 2010 20:58:32 +0530 Subject: Re: $$Excel-Macros$$ Excel Create List Must Be On The Active Worksheet To: excel-macros@googlegroups.com Hi Chris, You need to define the name for this range and then use INDIRECT function to call the range. Define 'test'!$D$1:$CC$3000 range as TEST (range name) Use =Indirect(TEST) formula to get the desired result. Let us know if any further assistance is required. Thanks and best regards, Ayush Jain On Mon, Apr 5, 2010 at 8:35 PM, ChristopherL clusard...@aol.com wrote: When I try to create a list and refer to another sheet, I get the below error! How can I get it to work. A working example would be useful. Where is the data for your list? ='test'!$D$1:$CC$3000 Error: The worksheet range for the list data must be on the active worksheet. Chris -- -- 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, reply using remove me as the subject. -- Best regards, Ayush Jain -- -- 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 _ If It Exists, You'll Find it on SEEK. Australia's #1 job site http://clk.atdmt.com/NMN/go/157639755/direct/01/ -- -- 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$$ Need help in function
Hi All, I want to calculate difference between two date , but i want result in minute's. please suggest function, Please find attached if u r sending solved reply Please CC sandeepxxxku...@gmail.com -- Thanks Regards: ╚►♥ѕαη∂єєρ♥◄╝ -- -- 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, reply using remove me as the subject. Book14.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Help: OUTLOOK VBA
Hello Dear, I appriciate your prompt reply,it may be a missunderstanding,but please let me know if any one has a outlook express in his or her PC,Then what is need to write a macro for outlook(To Send The Mail) . It is useful when we are accessing outlook from another application. Your suggestion are welcome,so that i can improve my prompt reply. Hope it Will Help Happy to Help :) Shyam On Tue, Apr 6, 2010 at 1:48 AM, paulwillekens paul.johan.willek...@gmail.com wrote: Hi Shyam, I mean the following: I understand what Janet wrote in a different way than you. I had the impression that you assume that Janet wants something from Excel, but I think he/she wants VBA macros for Outlook (not for Excel)... regards Paul Willekens -- -- 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, reply using remove me as the subject. -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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
Re: $$Excel-Macros$$ Worksheets password break
Hello Dear, In vba Level(Password in module).Password breaking is little bit lengthy process. Please send the Confirmation mail with Admin of group.If we will recognized you for this process,then we can help you. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 2010 at 10:45 AM, kumara datta yagneswara hkda...@gmail.com wrote: Thanks alot Shyam, But it has VBA Password ,will you please help me in breaking that password. Regards, Kumara Datta On Mon, Apr 5, 2010 at 6:01 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear Try to use tools-- unprotect workbook tools--unprotect sheets tools--unprotect share workbook Password is abc123 Remember this password while working on that workbook. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 5:47 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear, I can try,i will let you as soon as possible. Please wait for next post. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 4:55 PM, kumara datta yagneswara hkda...@gmail.com wrote: Hi Frnds, Can any one break this file's password. Thanks Regards, Kumara Datta. On Mon, Apr 5, 2010 at 12:37 AM, Nishant Sharma leonish...@gmail.com wrote: On Sun, Apr 4, 2010 at 2:51 AM, Vishal Parihar vish.pari...@gmail.com wrote: Hi Friends is there any vba code to break excel file which has a password to open Thanks Nishant Today i am going to show you how to crack excel sheets password. Vba code to break password. Sub PasswordBreaker() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 ActiveSheet.Unprotect Chr(i) Chr(j) Chr(k) _ Chr(l) Chr(m) Chr(i1) Chr(i2) Chr(i3) _ Chr(i4) Chr(i5) Chr(i6) Chr(n) If ActiveSheet.ProtectContents = False Then MsgBox Tata sky laga dala life will be jiga lala Range(a1).Value = Tata sky laga dala life will be jiga lala Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub I hope i like this one. Regards Vishal Parihar 9910415530 vish.pari...@gmail.com -- -- 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, reply using remove me as the subject. -- -- 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 -- -- 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