Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

Revision history [back]

how to solve this VBA problem?

I downloaded the macro for excel in this site https://github.com/jmarrec/Useful-Excel-Macros-for-Energy-Modeling and I think it is helpful in editing large of building data. The problem I encountered is in exporting excel file to idf file. I already check the references: Microsoft Forms 2.0 Object Library based on the suggested instruction but when I tested the program it has an error (see attached file). I would like ask for help to fix this. Thank you.

image description image description

how to solve this VBA problem?

I downloaded the macro for excel in this site https://github.com/jmarrec/Useful-Excel-Macros-for-Energy-Modeling and I think it is helpful in editing large of building data. The problem I encountered is in exporting excel file to idf file. I already check the references: Microsoft Forms 2.0 Object Library based on the suggested instruction but when I tested the program it has an error (see attached file). I would like ask for help to fix this. Thank you.

image description image description