Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

RUNTIME ERROR 76 VISUAL BASIC WHILE PREPARING PTRC TEMPLATE FOR MAHARASHTRA

Jignesh (Service) (42 Points)

31 December 2023

Since Last month when we try to prepare *.TXT File for uploading PTRC Return from FORM III B-V-1.0.004.xlsb file, we get the following error:

"RUNTIME ERROR 76 VISUAL BASIC"

Tried checking on Microsoft Site, it explains it can be resolved by editing the File Coding done in Visual Basic, but unable to do so as the file downloaded from PT Portal is locked.

Please provide solution for this issue.

Thanks

Jignesh Patel

Reply
Follow
Share

5 Replies

sabyasachi mukherjee (27537 Points)
Replied 04 January 2024

Its applicable

Upgrade to CAclubindia Pro. Subscribe Now!

Varda Parekh (2 Points)
Replied 03 February 2024

hello

even i am facing the exact same issue, did you find any solution? ive already enabled the macros setting but it still doesnt work

Jignesh (Service) (42 Points)
Replied 04 February 2024

Hi,

No, it has not been resolved yet, as updated Excel is not supporting Macros, the only available alternate solution is to use system which has older version of excel to generate TXT File.

Yasaswi Gomes new (Finance ) (4514 Points)
Replied 23 February 2024

I understand that you’re encountering a “RUNTIME ERROR 76” in Visual Basic when trying to prepare a *.TXT file for uploading PTRC Return from the FORM III B-V-1.0.004.xlsb file. Let’s troubleshoot this issue:

Check the File Path:
- Ensure that the file path you’re using in your VBA code exists and is accessible. The error might occur if the specified path is incorrect or the folder doesn’t exist.
- Double-check the path where you’re trying to create the *.TXT file.

Quotes Around File Paths:

If your file path contains spaces, make sure to enclose it in double quotes. For example:

folderPathWithName = "N:\Business Assurance Team\3. CONTROLS ASSURANCE\Audits\Compliance\01. Arrears Review\" & FileYear & "\" & FileQuarter & "\" & FileMonth & "\" & CallType & "\" & Branch & "\" & myName

File Permissions:
- If the file downloaded from the PT Portal is locked, you might not have the necessary permissions to edit it. Check if you can save a copy of the file in a different location and then try editing it.
Unlocking the File:
- If the file is password-protected or restricted, you might need to contact the PT Portal support or the file owner to unlock it.
- Alternatively, you can try saving a copy of the file with a different name and then work with the copy.
Debugging Your Code:
- Use breakpoints or debug print statements to check the values of variables (like folderPathWithName) during runtime. This will help you identify any issues.
- Make sure that all variables are correctly assigned and that the paths are constructed as expected.
Test with a Simple Example:
- Create a simple VBA scriptt that creates a folder and a file in a known location. Test if it works without any errors. If it does, then the issue might be specific to the PT Portal file.

Remember that the error message “RUNTIME ERROR 76” usually indicates that the specified path is not found. Double-check your paths, ensure file permissions, and try debugging your code step by step. If the issue persists, consider seeking assistance from your IT support or a VBA expert.