From "M.Peer Mohamed Sardhar" : Dear HR Faternity,

Filling out EPF Forms, whether handwritten or on a PC

is a tedious task, especially when the attrition is

substantial. To make the life of my buddies

comfortable, attached pl. find “AUTOMATED” Form 5. The

form shall be generated at a click of a button.

The form can have a maximum of 15 employees. As with

any software, you have to follow certain rules. Follow

the rules and you shall get the forms in around 15 to

30 seconds flat. (Depending on the configuration of

your PC, the amount of data to be entered viz.

attrition etc).

1. To generate the forms, you MUST maintain the

Employee Master as per attached sample file

“Dummy_Emploee_Master-07-08.xls” (Source File – Name

of the file may be different).

a. The first record MUST appear on row no. 18.

b. Do not change the names of sheets (i. e.

Employee_Records and Resignations).

c. DO NOT delete the sheet named “Template”.

d. If the format of the source file is changed, you

will not get the proper output.

2. Before you generate the form, ensure that the

source file is closed. You will not get the proper

output if the source file is open. The source file

shall open automatically when you generate Form 5 and

10 and close automatically.

3. The form is setup for a standard A4 paper.

4. Open the file “Form-5.xls”

5. Make sure that the macros security is set to

“medium”. To do this do the following:

a. Go to Tools -> Macros ->Security.

b. Click the Medium radio button.

c. This shall ensure that you get a message to enable

the macros when you open the workbook.

6. Enable the macros. If you disable the macros, you

will not get results.

7. You shall be prompted to choose the Source File.

Choose the source file which forms an input.

8. Run the macro. Press <Alt>+<F8> and click <Run>

9. You shall be prompted for the month and year for

which the form is to be generated.

10. Choose the Month & Year & keep your fingures

crossed.

11. The desired form shall be generated.

12. The only shortcoming in this form is that you will

have to put in the PF nos. manually. I shall update

the code and post ASAP.

I have a few records in the source file. Pl. generate

the form-5 for the month of September 2007 before you

decide to use this.

Courtesy,,,, Mr.Deepak Kanade...

31st October 2007 From India, Coimbatore
Attached Files
File Type: xls form-5_687.xls (114.0 KB, 3225 views)
File Type: xls dummy_emploee_master-07-08_565.xls (151.0 KB, 1616 views)


Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

About Us - Advertise - Contact Us - RSS   On Google+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network