Paybook Run Time/Visual Basic Error

Issue

When submitting an Excel-based timesheet, an error occurs, typically a Visual Basic error.

Error Message

Run-time Error "5": Invalid Procedure call or argument (or similar Visual Basic error).

Environment

• Microsoft Excel
• GRCC Payroll Timesheet

Resolution

The most effective way to resolve this issue is to download a new paybook and resubmit your data.

1. Navigate to the GRCC HR Payroll webpage (opens in new window).
2. Click the appropriate link to download your specific timesheet.
3. Open the downloaded Excel file.
4. Save the document before entering any information:
   • Click the Save icon in the upper left or press Ctrl + S, and save the file to your J: Drive.
5. Enter the information requested on the Setup page.
6. Save the timesheet again to ensure the setup data is retained.
7. Navigate to the appropriate pay period using the tabs along the bottom of the workbook.
8. Enter your time information for the period.
9. Save the timesheet once more before submitting.
10. Click Submit Timesheet in the upper right corner.
    • Important: Use a single-click only.
    • Warning: A double-click will cause the macro to fail, resulting in a submission error.
11. Once the success message appears, click OK and Save one final time.