$$Excel-Macros$$ Re: Need Help
The error is : Object variable or with block variable not set Best regards, Ayush jain On Jan 31, 11:11 am, Sunil Thacker wrote: > Whats the error..? > thx > Sunil T > > > > On Sat, Jan 31, 2009 at 1:09 AM, Ayush wrote: > > > I need your help. Do you know how to clear the clipboard of MS Word > > 2003 through VBA Code? > > > If you have any idea, do let me know please. > > > I have tried this code : Application.CommandBars > > ("Clipboard").FindControl(ID:=3634).Execute > > > But it through an error. > > > Thanks. > > Ayush Jain > > -- > Regards, > Sunil Thacker > ¨`·.·´¨) Always > `·.¸(¨`·.·´¨) Keep > (¨`·.·´¨)¸.·´ Smiling! > `·.¸.·´ > (¨`·.·´¨) (¨`·.·´¨) > `·.¸(¨`·.·´¨)¸.·´ > `·.¸.·«*:·. > .·:* > *:·. > *«*:·. > .·:* > *:·. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need Help
Whats the error..? thx Sunil T On Sat, Jan 31, 2009 at 1:09 AM, Ayush wrote: > > I need your help. Do you know how to clear the clipboard of MS Word > 2003 through VBA Code? > > If you have any idea, do let me know please. > > > > I have tried this code : Application.CommandBars > ("Clipboard").FindControl(ID:=3634).Execute > > But it through an error. > > > > Thanks. > Ayush Jain > > > -- Regards, Sunil Thacker ¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep (¨`·.·´¨)¸.·´ Smiling! `·.¸.·´ (¨`·.·´¨) (¨`·.·´¨) `·.¸(¨`·.·´¨)¸.·´ `·.¸.·«*:·. .·:* *:·. *«*:·. .·:* *:·. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Need Help
I need your help. Do you know how to clear the clipboard of MS Word 2003 through VBA Code? If you have any idea, do let me know please. I have tried this code : Application.CommandBars ("Clipboard").FindControl(ID:=3634).Execute But it through an error. Thanks. Ayush Jain --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Highlight present week with a border
What i Did: 1) Generated the Dates in Column B. 2) Applied the formula weeknum in Column C =WEEKNUM(B2,1) (To enable weeknum type of function: Tools > Add-Ins > analysis Toolpak ) 3) in $D$2 cell, applied the weeknum for now() 4) Performed the condition format (Formula Is) as mentioned below: =$C3=$D$2 then clicked in Format > border > outine & Patterns > click on light yellow color as background color. Click 'ok' 5) Went to cel b2, click on format paint & applied to entire col B. Enjoy. On Fri, Jan 30, 2009 at 11:23 PM, Srinivasan Ethirajalu < srinivasan.ethiraj...@gmail.com> wrote: > Use conditional format.. > > > > On Fri, Jan 30, 2009 at 4:07 PM, Ometoon wrote: > >> >> Hello, >> >> I am trying to highlight the present week with a border. The >> weeknumbers are shown in Cell A4:BA4. >> A function is used to give a notification FALSE or TRUE if the WEEKNUM >> is the same as the current weeknum (based on NOW() Function). >> >> I like to built a VBA statement which tells Excel to highlight the row >> of the current weeknumber with a coloured border. >> >> Can anyone help me with this? >> >> Thanks a lot! >> >> Regards >> >> Anton Mulder >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > > > -- > Srinivasan Ethirajalu, > +91-9449279330 > -- Srinivasan Ethirajalu, +91-9449279330 --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ regular expressions
Can you do regular expressions in Excel? I have a bunch of cells that say things like 14" SS and I would like to extract out just the numeric characters and return 14 It would be nice if I could do a regular expression like /[0-9]+/ to get the number out... --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ good
--~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Help me to add time to a date and time
I will explain my problem with an example. 30/01/2009 13:30 is the time.I want to add 36 hrs to it. But I should add it only during the working hours.(8:30 hours per hour a day(exclude week ends and holidays)). Assume working time to be from 08:00 to 16:30 So the time after 36hrs added would be 05/02/2009 16:00. I can add only the date through workday function,which also excludes holidays and weekends.But I am not able to add the exact time. Can YOU help me to get it done through macros?? Thanks in Advance --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Highlight present week with a border
Use conditional format.. On Fri, Jan 30, 2009 at 4:07 PM, Ometoon wrote: > > Hello, > > I am trying to highlight the present week with a border. The > weeknumbers are shown in Cell A4:BA4. > A function is used to give a notification FALSE or TRUE if the WEEKNUM > is the same as the current weeknum (based on NOW() Function). > > I like to built a VBA statement which tells Excel to highlight the row > of the current weeknumber with a coloured border. > > Can anyone help me with this? > > Thanks a lot! > > Regards > > Anton Mulder > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- Srinivasan Ethirajalu, +91-9449279330 --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Highlight present week with a border
Anton , You can do it with Conditional Formatting.. Regards, Vijay Ram On Fri, Jan 30, 2009 at 11:37 AM, Ometoon wrote: > > Hello, > > I am trying to highlight the present week with a border. The > weeknumbers are shown in Cell A4:BA4. > A function is used to give a notification FALSE or TRUE if the WEEKNUM > is the same as the current weeknum (based on NOW() Function). > > I like to built a VBA statement which tells Excel to highlight the row > of the current weeknumber with a coloured border. > > Can anyone help me with this? > > Thanks a lot! > > Regards > > Anton Mulder > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- Regards, Vijay Ram --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Highlight present week with a border
I am attaching a Workbook containing a macro (FmtWeekNum) that does what you describe. If you have any questions let me know. Tom On Fri, Jan 30, 2009 at 5:37 AM, Ometoon wrote: > > Hello, > > I am trying to highlight the present week with a border. The > weeknumbers are shown in Cell A4:BA4. > A function is used to give a notification FALSE or TRUE if the WEEKNUM > is the same as the current weeknum (based on NOW() Function). > > I like to built a VBA statement which tells Excel to highlight the row > of the current weeknumber with a coloured border. > > Can anyone help me with this? > > Thanks a lot! > > Regards > > Anton Mulder > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~--- FmtWeekNum.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Highlight present week with a border
Hello, I am trying to highlight the present week with a border. The weeknumbers are shown in Cell A4:BA4. A function is used to give a notification FALSE or TRUE if the WEEKNUM is the same as the current weeknum (based on NOW() Function). I like to built a VBA statement which tells Excel to highlight the row of the current weeknumber with a coloured border. Can anyone help me with this? Thanks a lot! Regards Anton Mulder --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Date Problem
Use the formula in cloumn 3 =IF(A5<>A6,B5,""). Fill it in each row. Then filter column 3 for non-blanks. NB: It will be best if you format the data as a table (or excel list). CA_logo_icai Small1 Anil Kumar Agarwala From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Chaudhry Zahid Ali Sent: Thursday, January 29, 2009 9:17 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Date Problem Hi, I have got a little problem that I need to solve I have a sheet with multiple transactions. The columns include Date and amounts. There are multiple amounts against a single date I need to extract the amounts which are appearing against every date, but the last amount in every date. As an example I'm attaching a sheet which has 5 dates and am highlighting the amounts that I need. Can anyone give me a formula to work with. The original sheet has 1+ rows Looking for a prompt reply Thanks everyone --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~--- <>
$$Excel-Macros$$ Date Problem (Soln. Attched)
HI, ATTACHED IS A SOLN. TO YOUR PROBLEM. JUST COPY THE FORMULA IN COLUMN 'A' TILL THE END OF YOUR DATA AND THEN REFRESH THE PIVOT TABLE HOPE IT SERVES YOUR PURPOSE REGARDS TEJAS S GANDHI On Thu, 29 Jan 2009 Chaudhry Zahid Ali wrote : >Hi, > >I have got a little problem that I need to solve I have a sheet with >multiple transactions. The columns include Date and amounts. There are >multiple amounts against a single date I need to extract the amounts >which are appearing against every date, but the last amount in every >date. As an example I'm attaching a sheet which has 5 dates and am >highlighting the amounts that I need. Can anyone give me a formula to work >with. The original sheet has 1+ rows > >Looking for a prompt reply > >Thanks everyone > >> --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~--- zz.xls Description: Binary data
$$Excel-Macros$$ Re: Date Problem
Hi, Could you pls confirm you need the total amount or the amount which is highlighted in your data sheet? Regards Naveen Kumar M N Email :naveenkumarmn...@yahoo.com Best Wishes-Karunaada Kuvara --- On Thu, 1/29/09, Chaudhry Zahid Ali wrote: From: Chaudhry Zahid Ali Subject: $$Excel-Macros$$ Date Problem To: excel-macros@googlegroups.com Date: Thursday, January 29, 2009, 9:47 AM Hi, I have got a little problem that I need to solve I have a sheet with multiple transactions. The columns include Date and amounts. There are multiple amounts against a single date I need to extract the amounts which are appearing against every date, but the last amount in every date. As an example I'm attaching a sheet which has 5 dates and am highlighting the amounts that I need. Can anyone give me a formula to work with. The original sheet has 1+ rows Looking for a prompt reply Thanks everyone --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Date Problem
Hi! Pls chk Attached file Thanks & regards Harish Upadhyay 9773284902 On 1/29/09, Chaudhry Zahid Ali wrote: > > Hi, > > I have got a little problem that I need to solve I have a sheet with > multiple transactions. The columns include Date and amounts. There are > multiple amounts against a single date I need to extract the amounts > which are appearing against every date, but the last amount in every > date. As an example I'm attaching a sheet which has 5 dates and am > highlighting the amounts that I need. Can anyone give me a formula to work > with. The original sheet has 1+ rows > > Looking for a prompt reply > > Thanks everyone > > > > > --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~--- zz(1).xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Date Problem
Attached sheet contains the solution, let me know if you are looking for something else Thanks, Nidhesh On Thu, 29 Jan 2009 Chaudhry Zahid Ali wrote : >Hi, > >I have got a little problem that I need to solve I have a sheet with >multiple transactions. The columns include Date and amounts. There are >multiple amounts against a single date I need to extract the amounts >which are appearing against every date, but the last amount in every >date. As an example I'm attaching a sheet which has 5 dates and am >highlighting the amounts that I need. Can anyone give me a formula to work >with. The original sheet has 1+ rows > >Looking for a prompt reply > >Thanks everyone > >> --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~--- zz_1_.xls Description: Binary data
$$Excel-Macros$$ Re: Date Problem
Hi, Check the attached file let me know if its fine Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Chaudhry Zahid Ali Sent: 29 January 2009 09:17 pm To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Date Problem Hi, I have got a little problem that I need to solve I have a sheet with multiple transactions. The columns include Date and amounts. There are multiple amounts against a single date I need to extract the amounts which are appearing against every date, but the last amount in every date. As an example I'm attaching a sheet which has 5 dates and am highlighting the amounts that I need. Can anyone give me a formula to work with. The original sheet has 1+ rows Looking for a prompt reply Thanks everyone The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~--- Copy of zz.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: convert digits into figures
Pls chk attached Add-Ins Thanks & Regards Harish Upadhyay 9773284902 On 1/25/09, sarfaraz ahmed wrote: > > Hello Vikash, > > I think I have achieved what you want and posted the same on my blog. > Kindly visit the link. Though it does not return after decimal. > > > I think mere modification would solve your issue. > > > > http://findsarfaraz.blogspot.com/2008/09/user-define-function-to-convert-number.html > > > > Regards, > Sarfaraz Ahmed > > On Sun, Jan 25, 2009 at 2:05 PM, Vikash Narnoli wrote: > >> Dear Group mates, >> >> Please help me on formula wherein digits are written as figures. >> For eg. >> 25 is written as Twenty Five. >> 2555.55 is written as Two Thousand Fifty five and Paise Fifty Five >> >> >> Thanks and Regards >> Vikash Narnoli >> ** >> ** >> >> >> > > > -- > Thanks with regards, > Sarfaraz Ahmed > > > > > --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~--- N2W.xla Description: Binary data