• State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 10 replies
  • Answers 1 answer
  • Subscribers 125 subscribers
  • Views 1456 views
  • Users 0 members are here

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

Sean Keene
Offline Thu, Jan 24 2019 3:06 PM

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
  • 0 Offline Fri, May 8 2020 12:00 PM

    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
  • 0 Offline Fri, May 8 2020 12:00 PM

    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
Communities
Support and Services
Training and Learning
Social Media