How to run MERGE command in a VBA macro Excel

[agiovannetti]

How could I run MERGE command in a VBA macro Excel?

[alaaeid]

Hello Jerome,

Hope you are well, is this still not available on V5 CP4?

Best,

Alaa Eid

[jhorber · Accepted solution]

Hello agiovanetti

Note that the merge feature available in interactive mode

• Is generic: in applies to almost any MetaClass
• Is a wizard: user can validate/invalide default choices

There is no high level API function on Mega object that enables to trigger this merge feature.

What is available is basic functions (to create an object, to create a link...).

With design and code, you can consider to propopose a custom merge feature with APIs but this is a project.