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.
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.
Children
No Data