Hi! I'm trying using VBA in Access to :
1) export employee table to excel and open Visio (done!!!);
after the updating organization structure chart in Visio (as usual!);
3) in Access save the organization chart uptdated in Visio and export the organization chart to excel file
4) import the excel file in access table (done!!!).
Someone has some experience about point 3)? (i'm able in Visio VBA to save some fields of the
organization chart in a excel file but i need to have the list of the main fields name too!)
thanks a lot