Activate NodeXL Ribbon methods by VBA for Excel

May 6, 2013 at 7:31 PM
Is there any way to activate the different methods in the NodeXL Ribbon by a macro (or by Visual Basic for Excel)?

I am trying to automate the import of multiple network data in the NodeXL Template and then the calculation of network metrics, but I am not able to activate the methods and functions (like "calculate metrics") in the NodeXL Ribbon by Visual Basic.

Does anybody have an idea? Any experience? Thank for any supports or hints :-)

Regards,
Coordinator
May 6, 2013 at 8:44 PM
The following does not directly address the question of VB Automation of NodeXL features.

However, NodeXL does provide support for automation of data collection and analysis.

These posts may offer some guidance on using NodeXL features for automating networks!

A Sample Settings File for NodeXL: An automated recipie for making Twitter network visualizations
http://www.connectedaction.net/2011/06/12/a-sample-settings-file-for-nodexl-an-automated-recipie-for-making-twitter-network-visualizations/

Setting forth: saving NodeXL option settings – how to exchange your expert configurations in NodeXL
http://www.connectedaction.net/2011/04/23/setting-forth-saving-nodexl-option-settings-how-to-exchange-your-expert-configurations-in-nodexl/

Fully automatic: NodeXL can build your network graphs hands free
http://www.connectedaction.net/2010/09/12/fully-automatic-nodexl-can-build-your-network-graphs-hands-free/

How to schedule the creation of a network with NodeXL and Windows Task Scheduler
http://www.connectedaction.net/2010/08/23/how-to-schedule-the-creation-of-a-network-with-nodexl-and-windows-task-scheduler/

Automatic for the people (who use the latest NodeXL!). Release v.1.0.1.128
http://www.connectedaction.net/2010/07/08/automatic-for-the-people-who-use-the-latest-nodexl-release-v-1-0-1-128/
Coordinator
May 7, 2013 at 2:09 AM
I tried to do that once and failed. The custom tab that NodeXL adds to the Ribbon is inaccessible from VBA, as far as I can tell.

-- Tony