I need help with VBA macro in excel and visio.
The requirement is to open an excel file into visio 2007 and create an organisational chart. I need to do this using a macro.
My excel file contains columns Name, Designation, Location.
1. With the scanty information that you have provided , I doubt that you will too many helpful answers.
2. What I have seen in Googling is that integrating Visio and Excel , and using code in Visio , is much more technical than the usual VBA programming.
3. If your requirement is one-off , it is not worth taking the effort needed to do this ; there is a lot of professional software which has the normal 30-day trial period , in which you can probably develop and print your charts.
4. if your requirement is a regular one , you would be better off purchasing standard software , since there is no guarantee that you will continue to get help / support in future when you wish to make changes.
when the visio/data files are moved to another location, the linked data no longer works, cause it can’t find the data file. is there any code or solution available for this....any help regrading this will be appreciated
i have an excel file named orgchart if i run the macro it shows me that file updated
but when i copy same file to other location and rename it and edit data in it and then when i run the macro again it shows me data of that renamed folder....is there any code to hard code a single file to a particular macro? any help regarding this will be appreciated