$$Excel-Macros$$ Re: how to crack Excel VBA password
Post the file here and someone will crack it for you. On Feb 19, 9:24 am, sunil sasidharan wrote: > *Hi All,* > ** > *I need to edit an excel macro file but the VBA coing is protected and > nobody is aware of the password.* > ** > *Could you please help me on how do i crack the excel password or is there > any free software available?* > ** > *Thanks in advance for your help > > Regards, > Sunny > * -- -- 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$$ Request Help to make code more efficient.
Hello all fellow fellow Macro friends :) I have a short bit of code that I was wondering if it's possible to make it run more efficiently. When it runs currently it takes up to 1 minute which seems like a long time. Notes: This is designed to remove an entire row if the condition is met. There is no *real* set limit on the number of potential rows, but in reality it shouldn't exceed 1,500 rows on a bad day. There is more code that runs after this but it's basic formatting stuff that dos not have a loop function in it. Regards, Jason Dim rng As Range Dim what As String Dim what1 As String Dim what2 As String Dim what3 As String Dim what4 As String Dim what5 As String Dim what6 As String Dim what7 As String Dim what8 As String what = "FD" what1 = "EX" what2 = "NA" what3 = "NB" what4 = "NC" what5 = "HN" what6 = "CLD" what7 = "Location" what8 = "of" Do Set rng = ActiveSheet.UsedRange.Find(what) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what1) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what2) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what3) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what4) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what5) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what6) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what7) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what8) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop -- -- 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$$ Request Help to make code more efficient.
Thanks you two, I integrated both suggestions into my vba and it processed instantly. Very helpful :) -- -- 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$$ Move from column a to b to c in loop
Hello again friends, I am cannot figure out how to make this work the way I want :( I need this to run in column a, then b, then c... but cannot figure out how to do it. Can someone please help with this matter. I'm sure it's a very simple solution! Sub Macro1() ActiveCell.Offset(-1, 0) = 1 Do While Not IsEmpty(ActiveCell.Value) ActiveCell.Value = (ActiveCell.Value + 1) * ActiveCell.Offset(-1, 0).Value ActiveCell.Offset(1, 0).Select Loop 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$$ Move from column a to b to c in loop
Basically, I want to run that code on each column (a through j). One column at a time. On Apr 14, 7:38 am, Paul Schreiner wrote: > I'm not sure what you're trying to accomplish, but > > First of all, I believe the format of .Offset is .Offset(row,column) > which means activecell.offset(1,0).select moves down one ROW > not to the right one COLUMN > > Paul > > ____ > From: JsinSk > To: MS EXCEL AND VBA MACROS > Sent: Tue, April 13, 2010 11:18:08 PM > Subject: $$Excel-Macros$$ Move from column a to b to c in loop > > Hello again friends, I am cannot figure out how to make this work the > way I want :( > > I need this to run in column a, then b, then c... but cannot figure > out how to do it. Can someone please help with this matter. I'm sure > it's a very simple solution! > > Sub Macro1() > > ActiveCell.Offset(-1, 0) = 1 > Do While Not IsEmpty(ActiveCell.Value) > > ActiveCell.Value = (ActiveCell.Value + 1) * ActiveCell.Offset(-1, > 0).Value > ActiveCell.Offset(1, 0).Select > Loop > > 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 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 > > 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
$$Excel-Macros$$ Delete rows based on duplicate and cell color
Hello All, At my workplace we have a report that is run every 15 minutes, it takes an employee nearly all of those 15 minutes to process and report the data to the group. I'm looking for a way to help automate this somewhat for the employee so he can work on other tasks through the day as well. Background: The report is generated in another application, he copy/pastes the information into excel then formats how he wants it. He highlights all the data in yellow. He then runs the report again and does the formatting then sorts by column A. He then goes through and deletes all the duplicates in the white (non colored) cells, but leaves the yellow ones. The new report is sent out with yellow (duplicate) and the new data in white. Question: Is there a way to automatically delete a row if the following conditions are met? • It's a duplicate • The cell color is white only The fresh data that was not a duplicate needs to remain on the sheet in order to be sent out. If you need more data please advise. Regards, Jason -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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: Delete rows based on duplicate and cell color
I have a file prepared, however I see no option to add on the "Add CC| Edit Subject" line. Please advise options to attach files. On Jun 8, 9:16 pm, Harpreet Singh Gujral wrote: > Jason, > > There can be a way to automate end-to-end, of what the employees are > doing or may be to some extent atleast > > Can you send a sample sheet to the group > > People will be able to help you a bit faster by looking at it > > Cheers > > Harry > > On Jun 8, 4:59 pm, JsinSk wrote: > > > Hello All, > > > At my workplace we have a report that is run every 15 minutes, it > > takes an employee nearly all of those 15 minutes to process and report > > the data to the group. I'm looking for a way to help automate this > > somewhat for the employee so he can work on other tasks through the > > day as well. > > > Background: > > The report is generated in another application, he copy/pastes the > > information into excel then formats how he wants it. He highlights all > > the data in yellow. He then runs the report again and does the > > formatting then sorts by column A. He then goes through and deletes > > all the duplicates in the white (non colored) cells, but leaves the > > yellow ones. The new report is sent out with yellow (duplicate) and > > the new data in white. > > > Question: Is there a way to automatically delete a row if the > > following conditions are met? > > > • It's a duplicate > > • The cell color is white only > > > The fresh data that was not a duplicate needs to remain on the sheet > > in order to be sent out. > > > If you need more data please advise. > > > Regards, > > > Jason > > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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: Delete rows based on duplicate and cell color
Please advise. I still cannot see an option to attach a file. If no reply I will upload to another site and link.. On Jun 8, 9:16 pm, Harpreet Singh Gujral wrote: > Jason, > > There can be a way to automate end-to-end, of what the employees are > doing or may be to some extent atleast > > Can you send a sample sheet to the group > > People will be able to help you a bit faster by looking at it > > Cheers > > Harry > > On Jun 8, 4:59 pm, JsinSk wrote: > > > Hello All, > > > At my workplace we have a report that is run every 15 minutes, it > > takes an employee nearly all of those 15 minutes to process and report > > the data to the group. I'm looking for a way to help automate this > > somewhat for the employee so he can work on other tasks through the > > day as well. > > > Background: > > The report is generated in another application, he copy/pastes the > > information into excel then formats how he wants it. He highlights all > > the data in yellow. He then runs the report again and does the > > formatting then sorts by column A. He then goes through and deletes > > all the duplicates in the white (non colored) cells, but leaves the > > yellow ones. The new report is sent out with yellow (duplicate) and > > the new data in white. > > > Question: Is there a way to automatically delete a row if the > > following conditions are met? > > > • It's a duplicate > > • The cell color is white only > > > The fresh data that was not a duplicate needs to remain on the sheet > > in order to be sent out. > > > If you need more data please advise. > > > Regards, > > > Jason > > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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: Outlook Problem
Open a new message, in the tool bar (same row as the send button) is the options tab, click. A new screen will open and you can check under delivery options do not deliver before a set time. >From what I know, Outlook must be left open for it to send. Someone else may know differently though. I've never tried it with Outlook closed. Regards, Jason On Jul 14, 4:47 am, Deepak Rawat wrote: > Hi guys > > Sorry for outlook > but i just wnat to know that is it possible to send any saved mail in > outlook at any specified time automatically. > > Suppose i want to send any mail automatically at 10 PM, is it possible. > > Regards, > Deepak -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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: Pivot table problem Pls help me
What is your problem? You need to give more information in order to receive help. On Jul 27, 9:02 am, Venkatesh Narla wrote: > Dear All, > I have problem in 2007 Excel Pivot table > Pls find the Pictures. > > Best Regards, > Venkatesh narla, > 9886058917 > > $11174984F06E120B.bmp > 666KViewDownload > > This Pivot formt i need.bmp > 858KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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: CONFIRMATION PROBLEM IN EXCEL 2007
Not sure how the computer program works, but you can use the below code to suppress errors if using a macro. Application.DisplayAlerts = False Be sure to use this at the end. Application.DisplayAlerts = True On Sep 21, 5:27 am, vikas gupta wrote: > DEAR ALL > > SOME DAYS BEFORE I HAVE INSTALL OFFICE 2007 > AFTER THAT I RECEIVED A CONFIRMATION BOX > AS ATTACHED FILE USING IT THROUGH EXPORT SOFTWARE > I HAVE ASKED FROM MRFING CO. BUT THEY CANT GIVE ME > ANY ANSWER > > IN OFFICE 2003 THERE IS NO PROBLEM OF THIS TYPE > > PLEASE SOLVE MY PROBLEM > > REGARDS > VIKAS > 9311334683 > > EXCEL PROBLEM.jpg > 231KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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$$ Find and replace the cell next to what your finding.
I have a excel sheet that I put data primarily into Columns A and B only. Column A gets data manually entered into based on what data is in Column be right next to it. After I go through the data and run another Macro, I sometime need to change what's in Column A, based on whats in column B. Image below: http://picasaweb.google.com/lh/photo/FQoASCIVATi-GAszyohiew?feat=directlink == >From that image if I'm finding (1:22) only is there a way to have it delete the information in Column A and the continue on to check the rest of the sheet?. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Find and replace the cell next to what your finding.
That worked out great actually.I just have to either 1 manually change the code when I need to change the value I'm looking for perhaps I should look at having a user input box come up :) Thank you Paul, a great help and huge time saver (and looks very easy!) On Jun 19, 9:29 am, Paul Schreiner wrote: > I'm not sure if I understand exactly what you're asking. > In a MACRO, it would be very easy to check the contents of "B", > and if it contains something specific (like 1:22), then clear "A". > Like this: > > For I = 1 to 1000 > if (instr(1,cells(I,2),"(1;22)") > 0) then cells(i,1) = "" > next I > > is that the kind of thing you're looking for? or did I misunderstand > completely? > > Paul > > > From: JsinSk > To: MS EXCEL AND VBA MACROS > Sent: Thursday, June 18, 2009 6:28:20 PM > Subject: $$Excel-Macros$$ Find and replace the cell next to what your finding. > > I have a excel sheet that I put data primarily into Columns A and B > only. > > Column A gets data manually entered into based on what data is in > Column be right next to it. > > After I go through the data and run another Macro, I sometime need to > change what's in Column A, based on whats in column B. > Image below: > > http://picasaweb.google.com/lh/photo/FQoASCIVATi-GAszyohiew?feat=dire... > > == > > From that image if I'm finding (1:22) only is there a way to have it > delete the information in Column A and the continue on to check the > rest of the sheet?. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: How to recover the VBA editor password for any book?
You will need to search the internet for options to get the password. There are prices to pay. Depending on what kind of data is in your workbook you could post a link to it, or email it to someone who can assist. On Jun 27, 3:47 pm, hanumant shinde wrote: > Please help me to recover my excel workbook password. It is very important > for me... and unfortunately I have lost the password. > thank you --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
Re: $$Excel-Macros$$ Sheet rename based on data in sheet & delete row
I'm not as good at VBA as I'd like to be and I especially thank you for taking the time to explain each step, I found it very helpful! Pertaining to the unique name problem, I looked but was unable to find a way to add a letter at the end of the date, starting with B going up to M (though if I get this far there is more problems than what the sheet will do!) I think if I can get past this last issue I'll be set. Regards, Jason -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Sheet rename based on data in sheet & delete row
I'm not as good at VBA as I'd like to be and I especially thank you for taking the time to explain each step, I found it very helpful! Pertaining to the unique name problem, I looked but was unable to find a way to add a letter at the end of the date, starting with B going up to M (though if I get this far there is more problems than what the sheet will do!) I think if I can get past this last issue I'll be set. Regards, Jason -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Sheet rename based on data in sheet & delete row
Paul, I have a another other question (excluding the previous one listed here in previous post). Sometimes the movement number has a single space between the letters and numbers that make up the flight number. Is there a way to include this information after the space (Total space will never exceed six characters/spaces). At current it doesn't include anything after a space. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Sheet rename based on data in sheet & delete row
Paul thanks, you helped me a ton. Basically this coupled with an
Outlook macro saved me 2 and a half hours a day in work. Thank you
very much. I can already see this being modified to help in other
tasks around the office!
Regards,
Jason
On Dec 3, 8:28 am, Paul Schreiner wrote:
> OK... here's what I came up with.
> I'm sure there are MANY other ways of doing this, but this uses some
> concepts that it would be good for you to know.
>
> You described two problems:
> 1) Sometimes, there is a single space after the first character of the
> movement
> type: "D 0970"
> 2) Add a suffix to the sheet name when a duplication occurs.
> So...
> --
>
> 1) Sometimes, there is a single space after the first character of the
> movement
> type: "D 0970"
>
> --
>
> When testing for the space, (If (Mid(tMvt, Pos, 1) <> " ") Then) instead of
> exiting
> the loop when you find one, check to see if the space is EARLY in the string.
> If Pos > 3 Then Exit For
> That way, if the string is "D0970", "D 0970", or even "D 0970", it will skip
> the space, but
> continue looking.
> --
>
> 2) Add a suffix to the sheet name when a duplication occurs.
> --
>
> If your script attempts to rename a sheet to a name that already exists, it
> will
> cause an error
> message.
> You can turn off this error message with:
> On Error Resume Next
>
> then, you can check to see if an error occurred.
> If all is well, Err.Number = 0, if an error occurs, Err.Number will NOT be 0.
> In this case, Err.Number is 1004 and Err.Description is:
> "Cannot rename a sheet to the same name as another sheet, a referenced object
> library or a workbook referenced by Visual Basic."
>
> The next thing you need to know is that there are 256 characters in the ASCII
> character set (and Extended ASCII)
> (numbered 0-255)
> These can be retreived using the chr() function.
> It happens that:
> The Upper Case letters A-Z are Chr(65-90) M = Chr(77)
> The Lower Case letters a-z are Chr(97-122) m = Chr(109)
>
> So, if you wanted to append the letter "B" to your Movement and Docdate
> string
> for the sheet name, use:
> ActiveSheet.Name = Mvt & " " & DocDate & Chr(66)
>
> But then, if THAT exists, you need to try "C", then "D".. and so on.
> since the ASCII index is numeric, you can use a simple loop:
>
> ' Attempt Letters B-M
> For inx = 66 To 77
> Err.Clear
> ActiveSheet.Name = Mvt & " " & DocDate & Chr(inx)
> If Err.Number = 0 Then Exit For
> Next inx
> --
>
> With both of these solutions, your macro ends up looking like:
>
> Sub Sheet_Cleanup()
> Dim R, DocDate, Pos, tMvt, Mvt
> Dim inx
> For R = 1 To 100
> If (Left(Cells(R, "A"), 5) = "Date:") Then
> DocDate = Replace(Replace(Replace(Left(Cells(R, "A").Value, 15),
> "Date:",
> ""), " ", ""), "/", "")
> If (R > 1) Then
> Rows("1:" & R - 1).Delete Shift:=xlUp
> Exit For
> End If
> End If
> Next R
> For R = 1 To 100
> If (InStr(1, Cells(R, "A").Value, "Movement") > 0) Then
> Pos = InStr(1, Cells(R, "A").Value, "Movement")
> tMvt = Trim(Mid(Cells(R, "A").Value, Pos + 12, 20))
> Mvt = ""
> For Pos = 1 To Len(tMvt)
> If (Mid(tMvt, Pos, 1) <> " ") Then
> Mvt = Mvt & Mid(tMvt, Pos, 1)
> Else
> If Pos > 3 Then Exit For
> End If
> Next Pos
> End If
> Next R
> ' Upper Case A-Z are Chr(65-90) M = Chr(77)
> ' Lower Case a-z are Chr(97-122) m = Chr(109)
> On Error Resume Next
> Err.Clear
> ActiveSheet.Name = Mvt & " " & DocDate
> If (Err.Number > 0) Then
> ' Attempt Letters B-M
> For inx = 66 To 77
> Err.Clear
> ActiveSheet.Name = Mvt & " " & DocDate & Chr(inx)
> If Err.Number = 0 Then Exit For
> Next inx
> End If
> End Sub
>
>
$$Excel-Macros$$ Re: Lock the Object
I believe you just need to set the locked object on your item (already done in your sheet), and then put protection on the sheet. (Tools| Protection|Protect Sheet) On Dec 22, 7:08 am, Chandra Shekar wrote: > Hello, > > How to lock the object? User should not edit the object or delete the > object. > > Please find attached file. > > Thanks > > Chandra Shekar > > Object_Lock.xls > 25KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
$$Excel-Macros$$ Re: How to get the system name using macro
Private Declare Function GetComputerName Lib "kernel32" _ Alias "GetComputerNameA" _ (ByVal lpBuffer As String, nSize As Long) As Long Function ReturnComputerName() As String Dim rString As String * 255, sLen As Long, tString As String tString = "" On Error Resume Next sLen = GetComputerName(rString, 255) sLen = InStr(1, rString, Chr(0)) If sLen > 0 Then tString = Left(rString, sLen - 1) Else tString = rString End If On Error GoTo 0 ReturnComputerName = UCase(Trim(tString)) End Function Found at: http://www.exceltip.com/st/Function_for_returning_the_computer_name_using_VBA_in_Microsoft_Excel/451.html -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Re: How to get the system name using macro
You can choose whichever cell you'd like and insert the following formula. =ReturnComputerName() On Jan 6, 12:24 pm, Rajesh K R wrote: > Hi > Thanks for the mail, let me know one thing how can get the result in > sheet 1! range"A1" > Regards > Rajesh kainikkara > > On 1/6/11, JsinSk wrote: > > > Private Declare Function GetComputerName Lib "kernel32" _ > > Alias "GetComputerNameA" _ > > (ByVal lpBuffer As String, nSize As Long) As Long > > > Function ReturnComputerName() As String > > Dim rString As String * 255, sLen As Long, tString As String > > tString = "" > > On Error Resume Next > > sLen = GetComputerName(rString, 255) > > sLen = InStr(1, rString, Chr(0)) > > If sLen > 0 Then > > tString = Left(rString, sLen - 1) > > Else > > tString = rString > > End If > > On Error GoTo 0 > > ReturnComputerName = UCase(Trim(tString)) > > End Function > > > Found at: > >http://www.exceltip.com/st/Function_for_returning_the_computer_name_u... > > > -- > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials 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 > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
$$Excel-Macros$$ Re: Unable to upload sample file
Send an email to "excel-macros@googlegroups.com" and attach your file. Use the subject for the title of your post. On Feb 2, 1:59 am, Bhushan wrote: > Hi Expert, > > PLease assist me how can attach sample excel file to the new post. > > There is no link avaliable which can upload my sample file for the > clear understanding of my problem. > > Warm Regards, > Bhushan Sabbani. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Need help on VBA code
Can you send a sample file? On Feb 22, 9:00 am, vinu wrote: > Hello Team, > > I need code on the below scenario: > > I have data dump which contains 15 columns of data. I need code to > perform the below steps: > Col A(Region), Col D(country), Col J(comments). For eg I filter the > Col A (Region) by "ANZ". Then column D(states) contains like PAK, > ENG, AU, NZ etc.,(In this PAK and ENG is not part of ANZ I need to > replace this with one conditon i.e., based on comments in Col J) , > will see the column J(comments) based on the content if it contains AU/ > NZ i ll replace the column D contents with the same. OR if it > contains other than AU and NZ anything(eg Ind, Pak, ENG ) I will > replace by default as AU. I have made a list as well, How do I do > this by coding. > > Thanks, > Vin -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Pls Help..
Send an email with the subject being what you need help with (title) to: excel-macros@googlegroups.com, and then attach file. On Feb 23, 5:30 am, кαяαηη yα∂αν wrote: > Hi..Experts, > > I need your help.I am unable to attach my file. Pls tell me where > I can attach file. > > Thnx > > Karan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Help Urgent i want to convert pdf file to Excel (column will remain same)
Simply searching the group for pdf to excel would've given you several potential answers. I did not check this URL but here is one possible software answer. Link to answer: http://groups.google.com/group/excel-macros/browse_thread/thread/b6fae3eee31606ec/d32d131c316fa8d4?lnk=gst&q=pdf+to+excel#d32d131c316fa8d4 Able2ExtractProPortable http://w15.easy-share.com/1700287853.html There are also apparently several online solutions, I would use these with caution depending on the sensitivity of your data. www.zamzar.com www.youconvertit.com www.pdftoexcelonline.com/ I cannot verify any of these as I'm at work, and I won't load unknown websites from here. On Feb 24, 1:54 am, rashid memon wrote: > -- Forwarded message -- > From: rashid memon > Date: Wed, Feb 23, 2011 at 2:57 PM > Subject: help! i want to convert pdf file to Excel (column will remain same) > To: excel-macros@googlegroups.com > > Dear Sir, > > i have PDF file which i have to convert to EXCEL i have Adobe Acrobat 7.0 > Professional > please provide me VB Code > > Excel file for sample is also attached... > > Looking forward to receive your kind attention. > > Thanks & Best Regards > > M.Rashid > > Email:- *mr.rashidme...@gmail.com* > > -- > Looking forward to receive your kind attention. > > Thanks & Best Regards > > Muhammad Rashid Hussaini > > Email:- *mr.rashidme...@gmail.com* > Cell: 0323-3289198 > > > > querry.xlsx > 25KViewDownload > > Querry.pdf > 26KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: pLEASE VERY URGENT--PLEASE
In the top sticked post is the answer to your question. http://groups.google.com/group/excel-macros/browse_thread/thread/a18c465d411d0138 Also a quick search of already posted query's will net you several answers http://groups.google.com/group/excel-macros/browse_thread/thread/903df336db00c77b http://groups.google.com/group/excel-macros/browse_thread/thread/74919681cc921c91 http://groups.google.com/group/excel-macros/browse_thread/thread/a18c465d411d0138 and more On Mar 18, 12:28 am, vijayajith VA wrote: > Hello All, > > Wednesday i have interview (excel and macros) .Can you please help me what > are the basic questions they will ask? > > please very urgent > Thankyou > vijay -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Help in formula to find the top 10 values
If you can change the format of your times it should work. I used hh:mm:ss and it works. On Mar 28, 6:59 am, Bhushan Sabbani wrote: > Dear All, > > I am facing the problem in the formula of the large to find the top 10. > > Here i am attaching the sample file for the reference. > > Thanks in advance. > > Warm Regards > Bhushan Sabbani > +91 98208 26012 > > time.xls > 147KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Help : Formula Required
You can use this formula, make sure to change C6 to the cell your data
is located.
=IF(AND(C6>TIMEVALUE("07:00"),C6 Hi All,
>
> I need formula to update column C, value if the time is between 7:00 AM to
> 9:00 PM "YES" else "NO"
> Find attached for the same.
>
> Column A Column B Column C
> Date Time (MST) 7:00 AM 9:00 PM
> 3/28/2011 6:26 AM YES IF LESS THAN 7:00:00 AM THEN YES
>
> 3/28/2011 6:47 AM YES IF GREATER THAN 9:00:00 PM THEN YES
>
> 3/28/2011 6:51 AM YES Between 7:00 Am to 9:00 Pm, Cell
> value "NO"
> 3/28/2011 6:59 AM YES
> 3/28/2011 7:13 AM NO
> 3/28/2011 7:32 AM NO
> 3/28/2011 7:45 AM NO
> 3/28/2011 7:46 AM NO
> 3/28/2011 1:29 PM NO
> 3/28/2011 1:42 PM NO
> 3/28/2011 1:42 PM NO
> 3/28/2011 1:42 PM NO
> 3/28/2011 1:43 PM NO
> 3/28/2011 1:43 PM NO
> 3/28/2011 1:49 PM NO
> 3/28/2011 1:56 PM NO
> 3/28/2011 2:06 PM NO
> 3/28/2011 2:08 PM NO
> 3/28/2011 2:12 PM NO
> 3/28/2011 2:18 PM NO
> 3/28/2011 2:23 PM NO
> 3/28/2011 2:32 PM NO
> 3/28/2011 2:35 PM NO
> 3/28/2011 2:37 PM NO
> 3/28/2011 2:41 PM NO
> 3/28/2011 2:46 PM NO
> 3/28/2011 2:50 PM NO
> 3/28/2011 2:50 PM NO
> 3/28/2011 2:55 PM NO
> 3/28/2011 3:02 PM NO
> 3/28/2011 3:02 PM NO
> 3/28/2011 3:15 PM NO
> 3/28/2011 3:18 PM NO
> 3/28/2011 3:21 PM NO
> 3/28/2011 3:30 PM NO
> 3/28/2011 3:31 PM NO
> 3/28/2011 3:33 PM NO
> 3/28/2011 3:39 PM NO
> 3/28/2011 3:43 PM NO
> 3/28/2011 3:59 PM NO
> 3/28/2011 4:00 PM NO
> 3/28/2011 4:03 PM NO
> 3/28/2011 4:05 PM NO
> 3/28/2011 4:07 PM NO
> 3/28/2011 4:20 PM NO
> 3/28/2011 4:28 PM NO
> 3/28/2011 4:28 PM NO
> 3/28/2011 4:28 PM NO
> 3/28/2011 4:38 PM NO
> 3/28/2011 4:39 PM NO
> 3/28/2011 4:45 PM NO
> 3/28/2011 4:46 PM NO
> 3/28/2011 4:48 PM NO
> 3/28/2011 4:49 PM NO
> 3/28/2011 4:49 PM NO
> 3/28/2011 4:49 PM NO
> 3/28/2011 4:51 PM NO
> 3/28/2011 4:52 PM NO
> 3/28/2011 4:54 PM NO
> 3/28/2011 5:05 PM NO
> 3/28/2011 5:31 PM NO
> 3/28/2011 5:49 PM NO
> 3/28/2011 5:58 PM NO
> 3/28/2011 6:04 PM NO
> 3/28/2011 6:10 PM NO
> 3/28/2011 6:16 PM NO
> 3/28/2011 6:26 PM NO
> 3/28/2011 6:27 PM NO
> 3/28/2011 6:28 PM NO
> 3/28/2011 6:44 PM NO
> 3/28/2011 6:57 PM NO
> 3/28/2011 7:03 PM NO
> 3/28/2011 7:10 PM NO
> 3/28/2011 7:15 PM NO
> 3/28/2011 7:18 PM NO
> 3/28/2011 7:18 PM NO
> 3/28/2011 7:20 PM NO
> 3/28/2011 7:26 PM NO
> 3/28/2011 7:34 PM NO
> 3/28/2011 7:35 PM NO
> 3/28/2011 7:39 PM NO
> 3/28/2011 7:44 PM NO
> 3/28/2011 8:06 PM NO
> 3/28/2011 8:12 PM NO
> 3/28/2011 8:20 PM NO
> 3/28/2011 8:22 PM NO
> 3/28/2011 8:23 PM NO
> 3/28/2011 8:23 PM NO
> 3/28/2011
$$Excel-Macros$$ Re: Help : Formula Required
You can use this formula, make sure to change C6 to the cell your data
is located.
=IF(AND(C6>TIMEVALUE("07:00"),C6 Hi All,
>
> I need formula to update column C, value if the time is between 7:00 AM to
> 9:00 PM "YES" else "NO"
> Find attached for the same.
>
> Column A Column B Column C
> Date Time (MST) 7:00 AM 9:00 PM
> 3/28/2011 6:26 AM YES IF LESS THAN 7:00:00 AM THEN YES
>
> 3/28/2011 6:47 AM YES IF GREATER THAN 9:00:00 PM THEN YES
>
> 3/28/2011 6:51 AM YES Between 7:00 Am to 9:00 Pm, Cell
> value "NO"
> 3/28/2011 6:59 AM YES
> 3/28/2011 7:13 AM NO
> 3/28/2011 7:32 AM NO
> 3/28/2011 7:45 AM NO
> 3/28/2011 7:46 AM NO
> 3/28/2011 1:29 PM NO
> 3/28/2011 1:42 PM NO
> 3/28/2011 1:42 PM NO
> 3/28/2011 1:42 PM NO
> 3/28/2011 1:43 PM NO
> 3/28/2011 1:43 PM NO
> 3/28/2011 1:49 PM NO
> 3/28/2011 1:56 PM NO
> 3/28/2011 2:06 PM NO
> 3/28/2011 2:08 PM NO
> 3/28/2011 2:12 PM NO
> 3/28/2011 2:18 PM NO
> 3/28/2011 2:23 PM NO
> 3/28/2011 2:32 PM NO
> 3/28/2011 2:35 PM NO
> 3/28/2011 2:37 PM NO
> 3/28/2011 2:41 PM NO
> 3/28/2011 2:46 PM NO
> 3/28/2011 2:50 PM NO
> 3/28/2011 2:50 PM NO
> 3/28/2011 2:55 PM NO
> 3/28/2011 3:02 PM NO
> 3/28/2011 3:02 PM NO
> 3/28/2011 3:15 PM NO
> 3/28/2011 3:18 PM NO
> 3/28/2011 3:21 PM NO
> 3/28/2011 3:30 PM NO
> 3/28/2011 3:31 PM NO
> 3/28/2011 3:33 PM NO
> 3/28/2011 3:39 PM NO
> 3/28/2011 3:43 PM NO
> 3/28/2011 3:59 PM NO
> 3/28/2011 4:00 PM NO
> 3/28/2011 4:03 PM NO
> 3/28/2011 4:05 PM NO
> 3/28/2011 4:07 PM NO
> 3/28/2011 4:20 PM NO
> 3/28/2011 4:28 PM NO
> 3/28/2011 4:28 PM NO
> 3/28/2011 4:28 PM NO
> 3/28/2011 4:38 PM NO
> 3/28/2011 4:39 PM NO
> 3/28/2011 4:45 PM NO
> 3/28/2011 4:46 PM NO
> 3/28/2011 4:48 PM NO
> 3/28/2011 4:49 PM NO
> 3/28/2011 4:49 PM NO
> 3/28/2011 4:49 PM NO
> 3/28/2011 4:51 PM NO
> 3/28/2011 4:52 PM NO
> 3/28/2011 4:54 PM NO
> 3/28/2011 5:05 PM NO
> 3/28/2011 5:31 PM NO
> 3/28/2011 5:49 PM NO
> 3/28/2011 5:58 PM NO
> 3/28/2011 6:04 PM NO
> 3/28/2011 6:10 PM NO
> 3/28/2011 6:16 PM NO
> 3/28/2011 6:26 PM NO
> 3/28/2011 6:27 PM NO
> 3/28/2011 6:28 PM NO
> 3/28/2011 6:44 PM NO
> 3/28/2011 6:57 PM NO
> 3/28/2011 7:03 PM NO
> 3/28/2011 7:10 PM NO
> 3/28/2011 7:15 PM NO
> 3/28/2011 7:18 PM NO
> 3/28/2011 7:18 PM NO
> 3/28/2011 7:20 PM NO
> 3/28/2011 7:26 PM NO
> 3/28/2011 7:34 PM NO
> 3/28/2011 7:35 PM NO
> 3/28/2011 7:39 PM NO
> 3/28/2011 7:44 PM NO
> 3/28/2011 8:06 PM NO
> 3/28/2011 8:12 PM NO
> 3/28/2011 8:20 PM NO
> 3/28/2011 8:22 PM NO
> 3/28/2011 8:23 PM NO
> 3/28/2011 8:23 PM NO
> 3/28/2011
Re: $$Excel-Macros$$ Help : Formula Required
On my response I screwed up the 24 hour time format! Should be 21:00 instead of 17:00. On Mar 30, 1:17 pm, "STDEV(i)" wrote: > Try this formula > > =IF((B2>=7/24)*(B2<=9/24),"NO","YES") > > On Wed, Mar 30, 2011 at 6:53 PM, wrote: > > Hi All, > > > I need formula to update column C, value if the time is between 7:00 AM to > > 9:00 PM "YES" else "NO" > > Find attached for the same. > > > Column A Column B Column C > > Date Time (MST) 7:00 AM 9:00 PM > > 3/28/2011 6:26 AM YES IF LESS THAN 7:00:00 AM THEN YES > > 3/28/2011 6:47 AM YES IF GREATER THAN 9:00:00 PM THEN YES > > 3/28/2011 6:51 AM YES Between 7:00 Am to 9:00 Pm, Cell > > value "NO" > > 3/28/2011 6:59 AM YES > > 3/28/2011 7:13 AM NO > > 3/28/2011 7:32 AM NO > > 3/28/2011 7:45 AM NO > > 3/28/2011 7:46 AM NO > > > Thanks, > > Mayur -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Password protect & unprotect sheets using code
I pulled your answer from URL listed below, second and third post both give different approaches depending on your needs. Below protects and unprotects all sheets, if you just need one sheet there are other options in the following URL. http://www.ozgrid.com/forum/showthread.php?t=20766&page=1 Dim ws As Worksheet Sub ProtectAll() For Each ws In Worksheets ws.Protect Password:="anystring" Next End Sub Sub UnProtectAll() For Each ws In Worksheets ws.Unprotect Password:="anystring" Next End Sub On Apr 15, 7:51 am, Rajesh K R wrote: > Hi Experts, > > I want to password protect my work sheets, but the same time it is > necessary to unprotect it for the running of macro so i have to give a > code to unprotect them. how can I do it. > > Regards > > Rajesh kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: solve the problem
Check www.pdftoexcelonline.com On Apr 21, 6:57 am, ashish kumar gupta wrote: > Dear All, > Please tell me how can we convert PDF in to Excel format & should not be > change format of PDF format. > > Thanks, > Ashish kumar gupta > phone 9540010417 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Multiple file Formatting
What format are your report files in? On Apr 26, 11:46 am, "Chidurala, Shrinivas " wrote: > Please help. > > Regards, > Shrinivas > Citi(r) Global Transaction Services - India > UB City, Canberra Block, # 24, Vittal Mallya Road, > Bangalore - 56 00 01. > Ph - +91-80-4144 6339 / 6340 > Email - shrinivas.chidur...@citi.com > > > > > > > > -Original Message- > From: Chidurala, Shrinivas [ICG-GTS] > Sent: Monday, April 25, 2011 9:10 PM > To: excel-macros@googlegroups.com > Subject: Multiple file Formatting > > Dear Gurus, > > I have created the attached macro for formatting of 50 to 60 files everyday > which are receive from system. But to run this macro i need to open and then > run. It taking too much time. > > Please can you advise to prepare the macro which will give facility do > similar formatting of all files at a time, if i save all files in specific > folder. > > Find attached sample file for your reference. > > Thanks in Advance > > Regards, > Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Macro for Converting txt to xls using Text Import Wizard
I can guess how you want it formatted, but is it possible for you to attach a sample excel sheet with the desired tabs/columns how you want it? On May 18, 3:31 pm, Susan 1 wrote: > Hi ~ > > Wondering if you could assist me with the Text import wizard to configure > the columns and tab delimiter for the attached txt file. And then send me > the steps. > > I will be needing to do this every week to the same types of txt files, > importing into Excel and I’d like to create a Macro for this but cannot > figure out how to set the tab/columns. > > Thanks, > > Sunnie > > 2065409868_05-03-2011.txt > 6KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Test Mail
When you reply to a post the moderators must approve it before it will appear. The delay in your reply and when it shows varies. On May 25, 3:16 pm, hanumant shinde wrote: > just checking if i can send a mail or not. i had sent a reply to 1 post but i > cant see my reply. i dot know whats wrong. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Move row to different sheet based on criteria
Hello, I would like to see about some assistance with the following problem, due to some re-arranging in our warehouse I need to have a report separate locations on different sheets. Locations are listed as AA-A-0 AA-A-1 AA-A-2 AA-A-3 AA-A-4 AA-B-0 AA-B-1 AA-B-2 AA-B-3 AA-B-4 AA-C-0 ... and so on.. to AA-M-4 Area one locations go from AA-A-0 to MM-M-4 in one area and should all be placed on one sheet. Area two locations go from AAA-A-0 to MMM-M-4 and should be placed on a sheet Area three locations go from A-A-0 to Z-M-4 Sheets should be renamed based on area (Area 1, Area 2,Area 3) All locations will be in column A and the entire row needs to be moved. (typically only A through F has data) Thanks Jason -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Move row to different sheet based on criteria
Can anyone else assist? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Search for keyword, and move all rows above found keyword to specific sheet
Hello Group, I'm attempting to automatically format a report that has several parts and break it down to what I need. The report comes in plain text and has three parts that all in with the phrase "total :" in the last part of that section. I'd like to see about having it break down each section into different sheets. I currently have it broken down to four sheets. Sheet 1 "Paste Sheet" - raw data goes here Sheet 2 "Listing" - First section of the raw data is put here Sheet 3 "Bond" - Second section of raw data Sheet 4 "Clear" - Third section The way I currently do the is is search for "total :" scroll up to the top of the paste sheet until I get to the top row and cut all data and move to the first sheet. Delete blank rows still the next section and repeat searching for total :. Then I do some text to columns to format the data to my requirements. All the formatting is done already just need help getting the data to automatically move to different sheets. Uploading sample data could be done if needed, will just require quite a bit of time to cleanse confidential information. Regards, Jason -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Re: Search for keyword, and move all rows above found keyword to specific sheet
Is it possible to skip saving it as a text file. The report comes in as an email and currently I copy/paste the data into Excel and manipulate the report to get what I need. An extra file would be an undesired result, but if it is needed I could accommodate. On Friday, July 13, 2012 10:12:52 AM UTC-4, JsinSk wrote: > > Hello Group, > > I'm attempting to automatically format a report that has several parts and > break it down to what I need. > > The report comes in plain text and has three parts that all in with the > phrase "total :" in the last part of that section. I'd like to see about > having it break down each section into different sheets. I currently have > it broken down to four sheets. > > Sheet 1 "Paste Sheet" - raw data goes here > Sheet 2 "Listing" - First section of the raw data is put here > Sheet 3 "Bond" - Second section of raw data > Sheet 4 "Clear" - Third section > > The way I currently do the is is search for "total :" scroll up to the top > of the paste sheet until I get to the top row and cut all data and move to > the first sheet. Delete blank rows still the next section and repeat > searching for total :. Then I do some text to columns to format the data to > my requirements. All the formatting is done already just need help getting > the data to automatically move to different sheets. > > Uploading sample data could be done if needed, will just require quite a > bit of time to cleanse confidential information. > > Regards, > Jason > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
