Re: $$Excel-Macros$$ Save As - error - object required
Hi Jonathan, Could it be a problem that you skipped the quots... should be Filename:=strSelectedPath \Run1.xlsx instead of Filename:=strSelectedPath \ Run1.xlsx Kind 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 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 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$$ Want to forece numbers to look like text with Green Error Flag
Hi Ronald, What about running following macro first, and then sorting the dolumn... Greetings Paul Willekens '=== Sub Omzetten() Dim nRow nRow = 1 While Len(Cells(nRow, 1)) 0 If IsNumeric(Cells(nRow, 1).Value) Then Cells(nRow, 2).Value = = Chr(34) Cells(nRow, 1).Value Chr(34) Else Cells(nRow, 2).Value = Cells(nRow, 1).Value End If nRow = nRow + 1 Wend MsgBox Done at row (nRow - 1) 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 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 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$$ require default sheet as attached
Dear all, please luk the attached sheet and I require,whenever i open the excell spread sheet I need to open the attached sheet by default..., please anty helpme out, adavance thanks -- Thanks Regards Shivashankar.C.Katageri. -- -- 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 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 Book1.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Combined Excel file
Dear All, Need ur help i recvd 10 -14 file on daily basis with same hadder, i have to combined all the file in one excel sheet is there any way with macro or without macro to combined all diff. file in single work sheet. awaited reply thanks in Anticipation Regards Harish Upadhyay 9773284902 -- -- 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 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$$ subtracting time
Hey Steve, Does one of these help? =INT((B1-A1)*24)Total hours between two times (4) =(B1-A1)*1440 Total minutes between two times (295) =(B1-A1)*86400 Total seconds between two times (17700) =HOUR(B1-A1)The difference in the hours unit between two times. This value cannot exceed 24 (4). =MINUTE(B1-A1) The difference in the minutes unit between two times. This value cannot exceed 60 (55). =SECOND(B1-A1) The difference in the seconds unit between two times. This value cannot exceed 60 (0). regards, Michael On Apr 16, 8:09 am, Steve mck1...@gmail.com wrote: Hello, I need to subtract a specific time in one cell from another time another cell to produce the difference of the two times. I also need to consider passing through midnight, i may have a time on one day and have to subtract it from a time on the next day. Thanks in advance, Steve -- ------ 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 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 -- -- 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 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$$ require default sheet as attached
Find a folder named XLSTART in the Program files ---Microsoft Office --- Office12 and place the excel file there. Regards Yahya On Tue, Apr 20, 2010 at 10:05 AM, shivashankar katageri shankarkatag...@gmail.com wrote: Dear all, please luk the attached sheet and I require,whenever i open the excell spread sheet I need to open the attached sheet by default..., please anty helpme out, adavance thanks -- Thanks Regards Shivashankar.C.Katageri. -- -- 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 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 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 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$$ Urgent Help Required in a macro
Hi Group, I'm working in a huge excel sheet with thousands of entries. I am currently looking for a macro, that when invoked (upon press of a key etc) would open a dialogue box having three fields. The first field being Select Row, In which I can write a row number Like 3, the second filed would contain Replace item from column, where I can write, for example G, and the third field containing an other Replace item from column for example AA. In this case the VBA code should select cells G3 and AA3. Than when I press enter or a button on the excel sheet the contents of cell G3 should go to AA3 and contents of AA3 should go to G3. The dialogue should not close after the cell contents have been replaced, but should close upon clicking the cross because there would be mutiple entries that need correction. An urgent reply and help would be highly appriciated, I have very little time to do tjis HUGE task of finding and replacing data in excel. Thanks in advance and Regards, ZAC. -- -- 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 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: Urgent Help Required in a macro
Hi ZAC, I have created a user form as per your needs. The shortcut is CTRL + Y and userform will pop up on this shortcut. The data will be updated on click of submit button. The fields will reset on data successfully updated. Please have a look and let me know if any further assistance is required. It appears to me that this can be done in much better way rather than updating each value. If you have any logic to update the data from one place to another, We can help you doing same. Do let us know with relevant data, if you have any questions. Best regards, Ayush Jain Group Manager On Tue, Apr 20, 2010 at 5:25 PM, Chaudhry Zahid Ali chaudhry.zahid@gmail.com wrote: Hi Group, I'm working in a huge excel sheet with thousands of entries. I am currently looking for a macro, that when invoked (upon press of a key etc) would open a dialogue box having three fields. The first field being Select Row, In which I can write a row number Like 3, the second filed would contain Replace item from column, where I can write, for example G, and the third field containing an other Replace item from column for example AA. In this case the VBA code should select cells G3 and AA3. Than when I press enter or a button on the excel sheet the contents of cell G3 should go to AA3 and contents of AA3 should go to G3. The dialogue should not close after the cell contents have been replaced, but should close upon clicking the cross because there would be mutiple entries that need correction. An urgent reply and help would be highly appriciated, I have very little time to do tjis HUGE task of finding and replacing data in excel. Thanks in advance and Regards, ZAC. -- 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 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 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 Chaudhry.xlsm Description: Binary data
Re: $$Excel-Macros$$ require default sheet as attached
Files kept in XLSTART folder are always opened when excel starts. Keep the file you want to open in that folder. regards, harsh On Tue, Apr 20, 2010 at 12:35 PM, shivashankar katageri shankarkatag...@gmail.com wrote: Dear all, please luk the attached sheet and I require,whenever i open the excell spread sheet I need to open the attached sheet by default..., please anty helpme out, adavance thanks -- Thanks Regards Shivashankar.C.Katageri. -- -- 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 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 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 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$$ require default sheet as attached
curiously enough, it works just as well to copy a SHORTCUT pointing to your file to the XLSTART folder. that way, if the file is a shared file, or stored on a network folder for backup purposes, then you can still have it automatically open when you launch Excel without putting it somewhere that others cannot get to! Paul From: Harsh Gharpure hsgharp...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, April 20, 2010 10:42:13 AM Subject: Re: $$Excel-Macros$$ require default sheet as attached Files kept in XLSTART folder are always opened when excel starts. Keep the file you want to open in that folder. regards, harsh On Tue, Apr 20, 2010 at 12:35 PM, shivashankar katageri shankarkatag...@gmail.com wrote: Dear all, please luk the attached sheet and I require,whenever i open the excell spread sheet I need to open the attached sheet by default..., please anty helpme out, adavance thanks -- Thanks Regards Shivashankar.C.Katageri. -- -- 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 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 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 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 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 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$$ Fwd: Urgent Help Required in a macro
Hi Chaudhary, Please note that you should keep our Group email address in all communications. It will help you. I have modified the macro to swap the values. Have a look and it should work now. Let me know if any further assistance is required. The logic based updation of data is possible and someone in group should help you out on same, Please submit a separate query with detailed example. Best regards, Ayush Jain Group Manager On Tue, Apr 20, 2010 at 8:38 PM, Chaudhry Zahid Ali chaudhry.zahid@gmail.com wrote: Dear Ayush, Thanks for the file. But the problem is that when it updates Data from A1 to B1, the data in one of the cell's changes but the data in the other cell remains the same. Hwat I need is, suppose, A1 has a value of 100 and B1 has a value of 200, when I click submit, B1 should show 100 and A1 should show 200. And yes you are right, the data that I have has a trend to follow, but the issue is that there are too many variables to follow. Still I am sending you two rows from the data (From over 7000 rows), the pink values need to be max within the seven day period, than comes green values and finally the blue ones. The white value preceeding the blue value needs to be less than the blue value and the white value after the green cells needs to be less than the green value. The other two values in the week can have any value but should be less than the value in highlighted color. I hope you get the idea. Thanks for sending me the macro and I'll highly appreciate if you can send me the adjusted macro or if you can send me any macro or formula which can follow and solve the problem in above para. Thanks and Kindest Regards, ZAC On Tue, Apr 20, 2010 at 5:27 PM, ayush jain jainayus...@gmail.com wrote: Hi ZAC, I have created a user form as per your needs. The shortcut is CTRL + Y and userform will pop up on this shortcut. The data will be updated on click of submit button. The fields will reset on data successfully updated. Please have a look and let me know if any further assistance is required. It appears to me that this can be done in much better way rather than updating each value. If you have any logic to update the data from one place to another, We can help you doing same. Do let us know with relevant data, if you have any questions. Best regards, Ayush Jain Group Manager On Tue, Apr 20, 2010 at 5:25 PM, Chaudhry Zahid Ali chaudhry.zahid@gmail.com wrote: Hi Group, I'm working in a huge excel sheet with thousands of entries. I am currently looking for a macro, that when invoked (upon press of a key etc) would open a dialogue box having three fields. The first field being Select Row, In which I can write a row number Like 3, the second filed would contain Replace item from column, where I can write, for example G, and the third field containing an other Replace item from column for example AA. In this case the VBA code should select cells G3 and AA3. Than when I press enter or a button on the excel sheet the contents of cell G3 should go to AA3 and contents of AA3 should go to G3. The dialogue should not close after the cell contents have been replaced, but should close upon clicking the cross because there would be mutiple entries that need correction. An urgent reply and help would be highly appriciated, I have very little time to do tjis HUGE task of finding and replacing data in excel. Thanks in advance and Regards, ZAC. -- Best regards, Ayush Jain -- Best regards, Ayush Jain -- 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 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 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 Chaudhry.xlsm Description: Binary data
Re: $$Excel-Macros$$ Fwd: Urgent Help Required in a macro
Thanks Ayush, it works nicely now. I received a mail from your personal address and I replied without checing the address thats why this happened. Any how, will be more careful in the future. :-) Thanks again for all the help. On Tue, Apr 20, 2010 at 6:34 PM, ayush jain jainayus...@gmail.com wrote: Hi Chaudhary, Please note that you should keep our Group email address in all communications. It will help you. I have modified the macro to swap the values. Have a look and it should work now. Let me know if any further assistance is required. The logic based updation of data is possible and someone in group should help you out on same, Please submit a separate query with detailed example. Best regards, Ayush Jain Group Manager On Tue, Apr 20, 2010 at 8:38 PM, Chaudhry Zahid Ali chaudhry.zahid@gmail.com wrote: Dear Ayush, Thanks for the file. But the problem is that when it updates Data from A1 to B1, the data in one of the cell's changes but the data in the other cell remains the same. Hwat I need is, suppose, A1 has a value of 100 and B1 has a value of 200, when I click submit, B1 should show 100 and A1 should show 200. And yes you are right, the data that I have has a trend to follow, but the issue is that there are too many variables to follow. Still I am sending you two rows from the data (From over 7000 rows), the pink values need to be max within the seven day period, than comes green values and finally the blue ones. The white value preceeding the blue value needs to be less than the blue value and the white value after the green cells needs to be less than the green value. The other two values in the week can have any value but should be less than the value in highlighted color. I hope you get the idea. Thanks for sending me the macro and I'll highly appreciate if you can send me the adjusted macro or if you can send me any macro or formula which can follow and solve the problem in above para. Thanks and Kindest Regards, ZAC On Tue, Apr 20, 2010 at 5:27 PM, ayush jain jainayus...@gmail.comwrote: Hi ZAC, I have created a user form as per your needs. The shortcut is CTRL + Y and userform will pop up on this shortcut. The data will be updated on click of submit button. The fields will reset on data successfully updated. Please have a look and let me know if any further assistance is required. It appears to me that this can be done in much better way rather than updating each value. If you have any logic to update the data from one place to another, We can help you doing same. Do let us know with relevant data, if you have any questions. Best regards, Ayush Jain Group Manager On Tue, Apr 20, 2010 at 5:25 PM, Chaudhry Zahid Ali chaudhry.zahid@gmail.com wrote: Hi Group, I'm working in a huge excel sheet with thousands of entries. I am currently looking for a macro, that when invoked (upon press of a key etc) would open a dialogue box having three fields. The first field being Select Row, In which I can write a row number Like 3, the second filed would contain Replace item from column, where I can write, for example G, and the third field containing an other Replace item from column for example AA. In this case the VBA code should select cells G3 and AA3. Than when I press enter or a button on the excel sheet the contents of cell G3 should go to AA3 and contents of AA3 should go to G3. The dialogue should not close after the cell contents have been replaced, but should close upon clicking the cross because there would be mutiple entries that need correction. An urgent reply and help would be highly appriciated, I have very little time to do tjis HUGE task of finding and replacing data in excel. Thanks in advance and Regards, ZAC. -- Best regards, Ayush Jain -- Best regards, Ayush Jain -- 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 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 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 LinkedIN group @
$$Excel-Macros$$ Sumproduct
Dear All, Can you tell me that what is the work of sum product. -- 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 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 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