Drainage VBA error when running Draing VBA->Drainage Tabulation - Update 1.09

I receiving the attached error when running the Drainage Tabulation tool from the menu bar.  I have a drainage project open and the GEOPAK gpk path as well as working directory path are pointed to the drainage folder.  The GPK and GDF files are in the drainage folder.  The GDF file opens fine and the network can be analyzed OK.

Using PowerGEOPAK 08.11.09.878 and FDOT SS4 MR9.

Thanks

Sean Keene

Parents
  • We had some issues with this VBA previously and this is the solution we came up with.

    Drainage Tabulation VBA Error

    • Issue
      • Compile Error: Cannot find project or library
    • Cause
      • The VBA has the wrong location for the Excel installation
        • The VBA looks for the 32bit version of Excel
        • If the 64bit version is installed, this error will occur
    • Solution
      • Stop the VBA from running
      • Tools -> References
        • Set the reference looking for EXCEL to C:\Program Files\Microsoft Office\root\Office16
      • Close Microstation
      • Save the VBA with the same name and overwrite.

    Zachary Billings, P.E.

    Senior Roadway Engineer (Licensed in FL and MI)

    CONSOR Engineers, LLC

    System Info:

    Windows 10 | Intel Core i7-9700k | Nvidia RTX 3080 FTW3 Ultra | 32 GB of RAM | 500 GB Samsung 960 EVO NVME

    Power GEOPAK V8i Select Series 10 Version 08.11.09.918 | FDOT SS10 Version 01.04.01

    ORD Version 10.09.00.91 | FDOT Connect Version 10.09.00.00

    YouTube Page for ORD: https://www.youtube.com/channel/UC3S-94f7_yUJ-GMhMYPhInA

Reply
  • We had some issues with this VBA previously and this is the solution we came up with.

    Drainage Tabulation VBA Error

    • Issue
      • Compile Error: Cannot find project or library
    • Cause
      • The VBA has the wrong location for the Excel installation
        • The VBA looks for the 32bit version of Excel
        • If the 64bit version is installed, this error will occur
    • Solution
      • Stop the VBA from running
      • Tools -> References
        • Set the reference looking for EXCEL to C:\Program Files\Microsoft Office\root\Office16
      • Close Microstation
      • Save the VBA with the same name and overwrite.

    Zachary Billings, P.E.

    Senior Roadway Engineer (Licensed in FL and MI)

    CONSOR Engineers, LLC

    System Info:

    Windows 10 | Intel Core i7-9700k | Nvidia RTX 3080 FTW3 Ultra | 32 GB of RAM | 500 GB Samsung 960 EVO NVME

    Power GEOPAK V8i Select Series 10 Version 08.11.09.918 | FDOT SS10 Version 01.04.01

    ORD Version 10.09.00.91 | FDOT Connect Version 10.09.00.00

    YouTube Page for ORD: https://www.youtube.com/channel/UC3S-94f7_yUJ-GMhMYPhInA

Children