Converting excel data to org charts using macros
- Thread starter akshayp
- Start date
NARAYANK991
Excel Ninja
Hi Akshay ,
I don't think your requirement is so simple ; similar questions have been asked on this forum , without receiving any answers. See these links :
http://chandoo.org/forum/threads/ma...reate-an-organisation-chart.14656/#post-87537
http://chandoo.org/forum/threads/vb...t-using-excel-data-in-visio.14716/#post-87949
Narayan
I don't think your requirement is so simple ; similar questions have been asked on this forum , without receiving any answers. See these links :
http://chandoo.org/forum/threads/ma...reate-an-organisation-chart.14656/#post-87537
http://chandoo.org/forum/threads/vb...t-using-excel-data-in-visio.14716/#post-87949
Narayan
the thing is i dont want any random excel sheets to be dynamically converted into org charts
i'l tell you the steps so that you can get idea what i exactly want
1. There will be a single excel file stored in C:\ drive for e.g.....which might be modified from time to time
2. i want that whenever i execute the macro in visio 2007 it will show me the accordingly updated organizational chart for the same updated excel sheet (not any random excel sheet) directly rather than asking me for browsing the document and have to perform all the operations again and again as i am using the same single excel sheet which will be modified from time to time not dynamic excel sheets
3. Steps will be
open visio-> execute macro -> get updated organizational chart for the same single updated organizational data sheet
so i will require help for creating vba code for executing this macro which provides the above functionality.....any help regarding this will be appreciated.
let me know if you are still not getting what i am trying to say
i'l tell you the steps so that you can get idea what i exactly want
1. There will be a single excel file stored in C:\ drive for e.g.....which might be modified from time to time
2. i want that whenever i execute the macro in visio 2007 it will show me the accordingly updated organizational chart for the same updated excel sheet (not any random excel sheet) directly rather than asking me for browsing the document and have to perform all the operations again and again as i am using the same single excel sheet which will be modified from time to time not dynamic excel sheets
3. Steps will be
open visio-> execute macro -> get updated organizational chart for the same single updated organizational data sheet
so i will require help for creating vba code for executing this macro which provides the above functionality.....any help regarding this will be appreciated.
let me know if you are still not getting what i am trying to say
Thanks Abhay
The second link which you sent me are the same exact steps i want to execute and i know this procedure very well and i am quite familiar with it.
But my job is to create a macro which can do all these steps that is from going to new -> open org chart wizard till the display of org chart in a automated way through my macro
i have to just execute the macro and it will take data from same excel file and following the steps shown by you in the second link, give me the organizational chart directly rather than me doing the steps in between manually
so i want your help for writing this particular macro in visio 2007.....any help regarding this will be appreciated
The second link which you sent me are the same exact steps i want to execute and i know this procedure very well and i am quite familiar with it.
But my job is to create a macro which can do all these steps that is from going to new -> open org chart wizard till the display of org chart in a automated way through my macro
i have to just execute the macro and it will take data from same excel file and following the steps shown by you in the second link, give me the organizational chart directly rather than me doing the steps in between manually
so i want your help for writing this particular macro in visio 2007.....any help regarding this will be appreciated
dear hui
i'l tell you what i exactly want
1. Consider Today if i have 5 fields in my excel sheet and if i import that excel sheet in visio it will show me the data in org chart accordingly.
2. Tommorow if i increase no. of fields to 6 and save the excel file
3. and when i open visio and try to open the same overwritten file it shows me chart according to 5 fields only
4. I know i can import the excel file again then it will show me 6 fields that is true
5. But the thing is i dont want to import the file again and again as i will be using same file all the time
5. So i want to write a macro by which if i modify data to 7 fields in excel sheet only and save it And then when i open visio and open the visio file which i had previously saved with six fields it should show me o5rg charts according to 7 fields accordingly not 6 fields
i dont want to import the same file again and again i want that changes in excel file will make direct changes in my visio file i.e. if previous data is 7 in both excel and visio file and if i make data of excel sheet 8 then when i open the visio file it should also show me data as 8 consistently without importing the file.
so i need to write a macro for it so that i dont need to import same file again and again.....i know it is a very difficult and complicated task but any help regarding this will be appreciated.
i will just execute the macro and data will be updated in visio file according to data in excel file.....i know it sounds very heavy but please help because i am stuck with this problem for long time.
and please let me know if you are still not getting what i am trying to say
i'l tell you what i exactly want
1. Consider Today if i have 5 fields in my excel sheet and if i import that excel sheet in visio it will show me the data in org chart accordingly.
2. Tommorow if i increase no. of fields to 6 and save the excel file
3. and when i open visio and try to open the same overwritten file it shows me chart according to 5 fields only
4. I know i can import the excel file again then it will show me 6 fields that is true
5. But the thing is i dont want to import the file again and again as i will be using same file all the time
5. So i want to write a macro by which if i modify data to 7 fields in excel sheet only and save it And then when i open visio and open the visio file which i had previously saved with six fields it should show me o5rg charts according to 7 fields accordingly not 6 fields
i dont want to import the same file again and again i want that changes in excel file will make direct changes in my visio file i.e. if previous data is 7 in both excel and visio file and if i make data of excel sheet 8 then when i open the visio file it should also show me data as 8 consistently without importing the file.
so i need to write a macro for it so that i dont need to import same file again and again.....i know it is a very difficult and complicated task but any help regarding this will be appreciated.
i will just execute the macro and data will be updated in visio file according to data in excel file.....i know it sounds very heavy but please help because i am stuck with this problem for long time.
and please let me know if you are still not getting what i am trying to say