When running the drainage tabulation vba and selecting the generate spread tabulation button, I get a run time error '62': Input past end of file and I haven't been able to find a solution. I have checked all the normal fixes and there are no missing references. Any help would be greatly appreciated. Thanks.
Hello Keith,
This might be a silly question, but have you checked the DrainTab References (via the Microsoft Visual Basic Editor)?:
We've experienced issues where the selected Reference (for Excel) was "missing". So, we needed to Browse for the EXCEL.EXE application file to resolve (and Save the changes to the DrainTab.mvba File).
If this is not the issue, can you check your "working folder" for a SpreadReport.csv File? I believe that this File is created as you press the Generate Spread Tabulation button. If the File is not created in the expected folder, I'm wondering if there is an issue with the Path (special characters, maybe or the DrainTab is not finding the correct path for some reason?).
ProjectWise Explorer CONNECT Edition, Version 10.00.03.453
ProjectWise Drive, Version 2022.1.328
OpenRoads Designer CONNECT Edition, Version 10.09.00.91
OpenRoads Designer CE 202 Release 2, Version 10.10.21.4
Power GEOPAK V8i (SELECTseries 10), Version 08.11.09.918
Hi Matt,
No question is ever silly. If you don't ask, you will never know. I tell my kids that every day. Yes, I updated that when I tried to run the StormTab Spredsheet and got the other error. The StormTab Spredsheet runs fine now. I don't know what the cause of this error is though. Hopefully, we can find a solution.