How can i access and get data from an active sheet of Ecxel from another Program by VBA. Ex: I want to get data from an active Excel from AutoCad to draw base on this data.
Thank s lot!
Printable View
How can i access and get data from an active sheet of Ecxel from another Program by VBA. Ex: I want to get data from an active Excel from AutoCad to draw base on this data.
Thank s lot!
I don't know AutoCAD, but if it's not an MSOffice product, you won'T be able to do it that way, since VBA is running only on MSOffice.
You can have an MSOffice. file open another application and sending data there using VBA, but not the other way around.
At least to my knowledge.