Accessing AutoCad Blocks from Excel

[3576]

I am trying to access autocad block from Excel by using the following code:
Set acadBlockRef = acadDoc.HandleToObject(strHandle)
I am getting an error message: "Type mismatch" even though this statememt works in AutoCAD and MS Access. Please let me know of a way to make this work.

Thanks,

TW

 

[borgunit]

Might want to define the acadBlkRef as a variant or object and not a block reference.

 

[3576]

Thanks for the reply.
I tried that but then I need to GetAttributes and that method is not available with object. Any other suggestion?

TW

 

[borgunit]

Assign another variable as a blockreference and then set the acadblkref to it.