Re: $$Excel-Macros$$ Understand macro code in timesheet
Yes, you can email it to: schreiner_p...@att.net It SOUNDS like it's an old-style macro. But I'm not sure how it's actually working. I'll take a look at it and see if I can recognize what's happening. Paul From: anil dhi...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Mon, January 10, 2011 6:00:51 PM Subject: Re: $$Excel-Macros$$ Understand macro code in timesheet Hi Paul Thanks for the reply I followed your instructions. When I right click 'Next fortnight' button and select 'Assign macro' - It goes to second line of the code - =ECHO(FALSE) in 'Macro1' Sheet When I right click Re-Calculate' button and select 'Assign macro' - It goes to second line of the code - =CALCULATE.NOW() in 'Macro 1' sheet How can I send you file? can I email at your email address? Regards Anil -- -- 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$$ Understand macro code in timesheet
Anil, Try this: In Excel2007, go to the Developer tab. In the Controls group (center section) select the Design Mode icon. then, right-click on the button. You should get a menu, but depending on the type of button control, the menu will be different. If it is a Form Control, then there will be an Assign Macro selection. Pick it and a panel will appear that will show you the macro name and location. For Example: Book1!Button_Macro1 is a macro Called Button_Macro1 in workbook Book1. If it does NOT have an Assign Macro selection, then it is an ActiveX Control, in which case pick the View Code selection. It will open the VB Editor and take you to the code. If this doesn't help, perhaps you could send me the file and I can take a look. Paul From: anil dhi...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Sun, January 9, 2011 8:04:58 PM Subject: 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
Re: $$Excel-Macros$$ Understand macro code in timesheet
Hi Paul Thanks for the reply I followed your instructions. When I right click 'Next fortnight' button and select 'Assign macro' - It goes to second line of the code - =ECHO(FALSE) in 'Macro1' Sheet When I right click Re-Calculate' button and select 'Assign macro' - It goes to second line of the code - =CALCULATE.NOW() in 'Macro 1' sheet How can I send you file? can I email at your email address? Regards Anil -- -- 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
Re: $$Excel-Macros$$ Understand macro code in timesheet
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 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
$$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 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