Text only | Text with Images

Visio Guy

Visio Discussions => Programming & Code => Topic started by: contact_ankit86 on September 13, 2013, 07:20:48 AM

Title: Export Org Chart data to excel
Post by: contact_ankit86 on September 13, 2013, 07:20:48 AM
Hi All,

There is a functionality in Visio 2010 to export the organisation chart data to excel.

Can we do that through code. I want to export the data through code. When i try to record a macro it does nothing.

Can somebody please help. Its urgent.

Thanks,
Ankit Sharma
Title: Re: Export Org Chart data to excel
Post by: aledlund on September 13, 2013, 01:37:09 PM
you might try the database wizard which can dump the drawing to excel.
al
Title: Re: Export Org Chart data to excel
Post by: aledlund on September 14, 2013, 02:12:43 PM
some of visio's functionality is intentionally not copied when you try to create macro's. I usually fallback to the event monitor which is included in the sdk's functions. It will show you a lot more of what is happening.
al
Title: Re: Export Org Chart data to excel
Post by: reem522 on October 22, 2016, 08:45:32 PM
how? please explain the steps. I have org Chart in Visio and I want to copy the data of the position and employee names to excel.. how I can do this?
Text only | Text with Images
Browser ID: smf (is_webkit)
Templates: 1: Printpage (default).
Sub templates: 4: init, print_above, main, print_below.
Language files: 1: index+Modifications.english (default).
Style sheets: 0: .
Hooks called: 54 (show)
Files included: 25 - 925KB. (show)
Memory used: 747KB.
Tokens: post-login.
Cache hits: 8: 0.00214s for 22,302 bytes (show)
Cache misses: 2: (show)
Queries used: 11.

[Show Queries]