Re: $$Excel-Macros$$ How to assign macro to an Active X Controls Command Button
add active x control and right click on it choose view code and paste your code . see if that helps you ( in design mode) On Sun, Jan 9, 2011 at 9:42 AM, Susan susan.m.ander...@comcast.net wrote: This macro works for the command button selected under Forms Control, (Excel 2007). Is macro option not available for the active X control command buttons? Sub zOpenBugetEstimateFile() ' ' zOpenBugetEstimateFile Macro ' ' ChDir C:\Documents and Settings\All Users\Documents\Budget\Finances\2010 Workbooks.Open Filename:= _ C:\Documents and Settings\All Users\Documents\Budget\Finances\2010\Budget_Estimation_Tys.xls _ , UpdateLinks:=0 End Sub ~Susan -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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$$ How to format Cmd Buttons
Hi Susan Is it possible in 2003 version. Regards thanks Rajesh Kainikkara On 1/9/11, Susan susan.m.ander...@comcast.net wrote: Hi, If you are using version 2007, you'll need to select the command button from the active X list. Then right click on the command button and select Properties. Then select Backcolor from Alphabetic list and choose from the Palette. ~Susan -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Rajesh K R Sent: Saturday, January 08, 2011 11:32 AM To: excel-macros Subject: $$Excel-Macros$$ How to format Cmd Buttons Hi Experts How can change the color of command buttons 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 -- -- 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 -- -- 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$$ Re: Efficiency report
Thanks alot for your...help.. On Sat, Jan 8, 2011 at 11:31 PM, ashish koul koul.ash...@gmail.com wrote: check the attachment On Sat, Jan 8, 2011 at 9:49 PM, Prathima R prathima@gmail.com wrote: Hello, Need your help once again plz. i am in the process of preparation of efficiency report so i will take from the ching work book from the consolidated sheet data to efficiency report but it should copy data for current date only suppose if i run that macro it should copy complete sheet details as it is but only todays date always Like this i have 8 peoples work books i need to prepare all peoples daily activities report. Please help me ... Thanks, Prathima -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 -- -- 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: How to Protect a Excel sheet
Hi Ankit, Save the excel file through save-as option, Click on the tools option at the bottom of the window opened, select General optionsthen the password to open and modify the file can be inserted Best Regards Mohit Gupta +919899073117 On Jan 8, 1:31 pm, ankit varshney ca.ankit.varsh...@gmail.com wrote: Please Help How to Protect a Excel sheet with password in MS 2007, so that no one can open the file without password. Thanks -- Ankit Varshney 9716588239 -- -- 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$$ Understand macro code in timesheet
Dear Paul Thanks for the reply. The sheet has been used in the organisation for long time and there is no current owner of it. Currently the workbook is Excel 2007 version. It is simply a spreadsheet with xlsm extension and no application or like that. It has xls extension in 2009 but during the upgradation to MS Office 2007, the extension changed to xlsm.I can open vba editor but there is no code.Also no macros. When I click Record macro and press any of two buttons, nothing happens and in vba code there is following code: Sub Macro1() ' ' End Macro1 Please advise what can be done with that sheet. The buttons works fine, but I cannot make any change. Regards Anil On Jan 7, 1:53 am, Paul Schreiner schreiner_p...@att.net wrote: What version of Excel are you using? Is it the spreadsheet application that used to come with Windows rather than an msOffice application? WAY back in Excel version... 4? they didn't use a VBA editor. Instead, you created a sheet called macro# and wrote your scripting there. It wasn't really VBA, it was more like a scripting language. I haven't done that in many, many years. I THINK it had a macro recorder funcion. Perhaps you could record your steps and see what scripting is created? otherwise, we'll need to know what version of Excel you're using and perhaps we can find someone with expertise with it. sorry, Paul From: anil dhi...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wed, January 5, 2011 6:11:57 PM Subject: $$Excel-Macros$$ Understand macro code in timesheet Problem - I have one spreadsheet which is used to record our time sheet in office. Sheet 1 is named Macro1 and has following code/lines in the cells starting from A1 till A18: Next Fortnight =ECHO(FALSE) =SELECT(R56C13) =COPY() =SELECT(R9C15) =PASTE.SPECIAL(3,1,FALSE,FALSE) =SELECT(R10C4:R49C5) =CLEAR(3) =SELECT(R12c10:R13c10,R16c10:R17c10,R20c10:R21c10,R24c10:R25c10,R24c10) =CLEAR(3) =SELECT(R28c10,R28c10:R29c10,R32c10:R33c10,R36c10:R37c10,R40c10:R41c10,R44c10:R45c10,R48c10:R49c10,R48c10) =CLEAR(3) I=FLEXY!$B$12 I=I+14 =SELECT(R10C4) =FORMULA(I,FLEXY!$B$12) =CALCULATE.NOW() =RETURN() In second sheet named 'TimeSheet' we have to enter time in and time out and it calculates total time and credit. There are 2 buttons on the sheet - 'Next fortnight' and 'Re- Calculate'. No code in visual basic window at all. When I right click 'Next fortnight' and select 'Assign macro' - It goes to second line of the code - =ECHO(FALSE) When I right click Re-Calculate' and select 'Assign macro' - It goes to second line of the code - =CALCULATE.NOW() I want to make few changes like copy fortnight data to new blank sheet and few other minor bits, but completly clueless how to make any change. Can you please guide me how can I make any changes in the spreadsheet? Is the macros locked? Thanks in advance -- ------ 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 linkhttp://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/discussexcel
$$Excel-Macros$$ Need Urgent help
Hi Experts, Please help in this concern, Is there a solution to copy the excel data from web, i need to copy the excel data from website i tried this option from excel 2007 DATA--From web But some error is poping up.. Please advise any macro to reduce this criticality, i need to copy literally line by line it will not even copy in proper format. for this i need to copy into excel again do some text to columns stuff then manually delete un necessary blanks. Please assist me in this concern i need to copy around 1000 Lines per day. Thanks for your help in advance. Regards, Pratima -- -- 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$$ Excel Puzzle of the week - Winner is Manoj Kumar
Thanks :) Regards, Manoj Kumar On Sat, Jan 8, 2011 at 2:58 PM, Maries talk2mar...@gmail.com wrote: Congrats Mr.Manoj.. -- Forwarded message -- From: ayush jain jainayus...@gmail.com Date: Sat, Jan 8, 2011 at 2:49 PM Subject: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar To: excel-macros@googlegroups.com Cc: manoj.vishwakarma...@gmail.com Dear Group, The winner of this puzzle has been selected as Manoj. His formula is shortest and working very well. The formula is =MONTH(1A1). I will publish the same on the blog with his name. Congratulations Manoj ! Thank you all for participating! The new puzzle is on the waySTAY TUNED . Thanks Best Regards, Ayush Jain Group Manager Microsoft MVP On Thu, Jan 6, 2011 at 7:33 PM, Paul Schreiner schreiner_p...@att.netwrote: given the string is in Cell A1, use: = MONTH(01-LEFT(A1,3)) Paul -- *From:* ayush jain jainayus...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, January 6, 2011 1:26:42 AM *Subject:* Re: $$Excel-Macros$$ Excel Puzzle of the week there was Typo in example...its Decem to 12 Submit your answer now. :D Thnx again. On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote: Dear members, There is a excel puzzle for you. Let see who all can give the answer correctly. There is a data of [month] in excel with no fixed length , minimum three characters, text format. You need to develop formula (Not Macro) which can convert it into number. For example Jan to 1 March to 3 Apr to 4. Decem to 5. so on. The best formula(short relevant) winner name will be published on exceldailytip.blogspot.com blog of this group. Let see who is the first and who is the winner. Thank you. Best Regards, Ayush Jain Group Manager Microsoft MVP -- -- 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=wallref=ts -- 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 Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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=wallref=ts -- 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 Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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
$$Excel-Macros$$ How can you extract this information?
How can you use vba to help me do this? WorkbookA has 3 columns with these respective headings: Code - showing a list of 200 stockcodes Price - blank Volume - blank WorkbookB has a list of over two thousand stockcodes with no headings. Each line shows the Code, the Date, the Opening Price, the High, the Low and the Volume traded for that day. How can I transfer the corresponding information to fill the blanks in WorkbookA and to skip a line if a code in WorkbookB is missing when it is not traded on that day? Thank you for your help. Tom -- -- 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