Move object from a class to another with VBA

I am using the famous mass updating excel sheet, and I tried to add the class move option to it.

unfortunately when I drop and recreate an object, it lost its object_id, so the report will not find it.

is there any way to move an object to another class, or is there any way, where I can set an object_id for a new object?


tfoldi (BOB member since 2008-02-04)

Welcome to B:bob:B!

I don’t know about famous grin … but I’m glad you find the utility useful.

As far as a “move” functionality, I’m afraid the answer is no. I would have (probably) included that functionality in the utility if it were possible. There is no .Move method, and the .Id property for classes and objects is not only hidden, but read-only.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

thanks for the welcome and for the answer, I’m glad to be here :slight_smile:

about the object_id/move issue: is there any other API which supports this operation? If the drag and drop works on the GUI then we should find a way to code it somehow


tfoldi (BOB member since 2008-02-04)

One would think so :yesnod: … but it’s not the case. We’re spoiled by the Microsoft Office applications, where virtually anything done manually can be automated. There are many examples where the BusObj object models simply are not “complete” in the same sense, and this is one of them.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)