RUNTIME ERROR 76 VISUAL BASIC WHILE PREPARING PTRC TEMPLATE FOR MAHARASHTRA

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

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.

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:

1. 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.

2. 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
     

3. 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.

4. 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.

5. 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.

6. 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. 

Any one found solution to this??