Need to update excel on making changes in visio flowcharts 1

[navyasree]

Hi guys, I am working on a new feature to update excel using flowchart. I have seen resources that helps to update the flowchart through excel data. But I need to update the excel when I make changes in the visio flowchart.

 

[Westi]

I know it is a leap year but asking an excel question in a telephony forum is quite the leap

You are probably looking to post that in an excel forum and I am not sure that Tek-Tips has that.

Joe
FHandw, ACSS, ACIS

https://www.millsidetc.com/

 

[mintjulep]

It's possible, with "visio plan 2"

https://support.microsoft.com/en-us...supports two-way,Excel data from the diagram.

I guess it would also be possible with VBA or Office Add-In.

 

[navyasree]

Thanks for the help. That steps and process really helped me alot. I would like to know if it is possible to mandate any field of excel in visio flowchart. Example, if a user want to add any new process/ custom shape in visio flowchart. Can we make a field may be, Alt text mandatory to save that shape process/ custom. Can you please help me with that.

Addition to that, Can we have any new column in excel sheet that has dropdown menu for that field data. That can be done same through visio as well. Like adding that same data as dropdown menu and selecting options from that dropdown.

Thanks
Navya

 

[Andrzejek]

new column in excel sheet that has dropdown menu for that field data

You can Create and manage drop-down lists in Excel

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson