I’d like to pull information from a Rhino file I have open to an Office app via VBA. The particular Rhino file would be based on its filename. I could try “pushing” from Rhino, or exporting a little CSV from Rhino for the other thing to read, but I’m curious if the first idea could be done.
I was hoping someone else would post a solution.
From related threads, it seems like a problem with Rhino’s COM interface means that GetObject() is the only way to grab a Rhino instance from VBA in Excel. That gives you an Object reference without autocomplete, etc.
VBA cannot early bind RhinoApplication : RH-56504 (myjetbrains.com)
Vba excel macro to extract “Notes” from 3dm files - Rhino Developer - McNeel Forum
Connect to Rhino from Excel - Scripting - McNeel Forum
I didn’t dig too deeply, but I replicated the difficulties with early binding variables.
It seems like it would be much, much easier to control things from the Rhino end calling Excel functionality. It seems clunky, but setting flags on the Excel end might be the most practical way to get the two to cooperate if you need information flow from both directions.