<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><DIV>G'day</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>In relation to Macros:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>As the timetabler, I have a copy of the timetable in Excel, one day per worksheet. I have a macro that will start at Monday's sheet, print Monday's timetable, go to Tuesday's worksheet, print it and so on down to Friday, and then return to Monday. (Yes I could have them all on the one sheet, but this works better for me for formatting reasons.)</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>In relation to student work, I once had a student SAC that (from memory) used one macro to</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV> 1. Collect salary data for an employee by copying it from relevant worksheets</DIV><DIV> 2. Paste that data into a Payslip worksheet</DIV><DIV> 3. Remove the colour (for printing purposes)</DIV><DIV> 4. Print the payslip</DIV><DIV> 5. Copy the data</DIV><DIV> 6. Open a new workbook</DIV><DIV> 7. Paste the data</DIV><DIV> 8. Save the workbook using employee name and the date (070729Hughes_G.xls) </DIV><DIV> 9. Close this workbook</DIV><DIV> 10. Return to original workbook</DIV><DIV> 11. Clear the data cells on Payslip worksheet</DIV><DIV> 12. Collect data about next employee</DIV><DIV> 13. Repeat steps 2 - 11 until all employees were done</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>This provided a payslip for each employee plus a saved copy of each paysjip for the business.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Once the above macro was completed, a second macro was run. It initiated a ' Save as' for the original workbook, saving it using the date as the file name e.g. 070729Pays.xls. This was closed and then the original workbook was re-opened all the data cleared, readying it for the next week's data, and then it was saved.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I think that the above is accurate ... apologies if my memory is faulty ....</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>On a personal note, I, in response to a challenge from my class, once wrote a macro that</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV> 1. Copied a weekly salary figure from a worksheet</DIV><DIV> 2. Pasted it in to a worksheet, 'Conversion', that used a complex series of formulae to convert the number to words</DIV><DIV> 3. Went to a worksheet called 'Cheque' and pasted, individually, the salary figure in numbers and words into a cheque</DIV><DIV> 4. Retrieved the employee's name and pasted it into 'Cheque' in the appropriate place</DIV><DIV> 5. Printed the cheque ready for signature (date was done using a function). I tried but did not succeed in getting the cheque numbers to increment after each printing.</DIV><DIV> 6. Cleared the data from 'Conversion' and 'Cheque', ready for the next employee</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I hope this is useful ... </DIV><DIV><BR><BR class="khtml-block-placeholder"></DIV> <BR><DIV> <SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><DIV>Graham Gales</DIV><DIV>Bright P-12 College</DIV><DIV>- - - - - - - - - - - - - - - - - - - </DIV><DIV>ITA, Science and Maths Teacher</DIV><DIV>Timetabler/ Daily Organiser</DIV><DIV>Gifted & Talented Co-ordinator</DIV><DIV>Heir apparent to the Chief Cook and BottleWasher</DIV><DIV>Understudy to the general Dogsbody</DIV><DIV><BR class="khtml-block-placeholder"></DIV><BR class="Apple-interchange-newline"></SPAN> </DIV><BR><DIV><DIV>On 25/07/2007, at 3:37 PM, Russell Edwards wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Does anyone have any thoughts on common uses of macros in Excel?</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I am struggling to come up with any examples that are generally applicable, and therefore worth putting in to student exercises.<SPAN class="Apple-converted-space"> </SPAN>I use macros occasionally but they are generally quite specific to the particular job that spreadsheet is designed for.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">About all I can think of would be setting the active cell to the first input data cell upon opening, and inter-sheet navigation buttons.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">thanks in advance</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Russell</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Whittlesea SC</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV></BLOCKQUOTE></DIV><BR><p></p><p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education.</p></BODY></HTML>