[Year 12 IPM] - Macro to Print a worksheet in Excel

[Meadows, Roslyn M]

Sorry folks - Just wondering if this (pay slips) was a "real world" example of how to use macros in Excel? 
Does "real world" matter? 
Oh well - here's my 2 bob's worth anyway! - from the perspective of an employer who has to actually do the Pay Slips every week.
 
Most businesses these days use MYOB or Quickbooks, or the freely available e-Record from the ATO. All automatically do calculations of PAYG tax, superannuation etc once you input the employee name and gross weekly, fortnightly or monthly salary, or hours worked. (And of course once you have these details in then the following weeks it is so much easier as it is all still there, you just change the date and hours worked) 
 
QuickBooks and MYOB also allow you to easily see how much superannuation per employee at the end of the 3 month period so you can pay it into their super fund, and how much PAYG Tax to pay to ATO every month (or 3 months for smaller businesses) Having to do the pays for our restaurant each week I would be lost without Quickbooks, and would say that anyone with more than 2 or 3 employees should have at least e-Record (which also allows businesses to submit BAS and PAYG Statements online, and prints out your group certificates - now called Payment Summaries - at the end of the financial year.) 
 
As an owner of two businesses we have been inundated with information from the ATO on the e-Record software and ECI (electronic submission of BAS, PAYG etc) over the last 12 months, so any person in business should know about its existence. And it is free.
 
Of course on the other hand there are probably many businesses who still do their pays with a calculator, and hand write out a pay slip on the forms from the Newsagent, but I would consider for most businesses one of the major reasons for buying their first computer would be to keep their business records, and a purchase of Quickbooks or MYOB would be included. 
 
Setting up all of the above in Excel with associated macros seems a little unrealistic - especially considering the figures (Gross, Nett, Super paid) would still need to be put into your business software anyway so the accountant and ATO have all the relevant figures for P/L and Balance sheets etc. 
 
Now if only there was some software that would count out the money and put it in an envelope with the Pay Slip!!!
 
See - I said it was only 2 bob's worth! :-)
 
Cheers
 
Ros Meadows
Bentleigh SC
9579 1044
meadows.roslyn.m at edumail.vic.gov.au
 
"Furious activity is no substitute for understanding." H. H. Williams 

________________________________

From: ipm-bounces at edulists.com.au on behalf of Mark Kelly
Sent: Mon 7/18/2005 3:16 PM
To: Year 12 Information Technology Processing and Management Teachers'Mailing List
Subject: Re: [Year 12 IPM] - Macro to Print a worksheet in Excel



Hi Lucy

I just wouldn't use Excel to produce the printed output.  How are you
going to show many people's data, each on a different page, without
endlessly repeating the payslip in the spreadsheet and creating a really
messy product!

I'm using Excel too, and payslips too, but I'll use mail merge using
Word and Excel to produce the output.

Quite a bit more powerful, and much better quality output.

HTH

lgusak at ansonic.com.au wrote:
> Hi,
>
> I was just wondering if anyone has a handout/tutorial on how to create a
> macro in Excel to print a specified range (ie. a payslip) of a worksheet.
>
> Thank you in anticipation
>
> Lucy Gusak


--
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria Australia
Phone +613 95780844  Fax +613 95789253
http://www.mckinnonsc.vic.edu.au
IPM Lecture notes: http://vceit.com
Moderator: IPM Mailing List

I'm often spick, but never span.
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IPM Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc




Important - 
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 & Training.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 8056 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20050719/32a20efb/attachment-0001.bin