C
casey
I was given the task of programmatically automating the org chart which was
originally created from Excel.
My exposure to VBA is not super advanced, but have used it for the past
5yrs, from using DAO to ADO.
Now, I find this situation so daunting because I am unable to get myself
anywhere close to getting a final working product. I have taken some tips
from this newsgroup and from SDK, and still not getting anywhere.
What I did for the meantime, is create it manually in Visio. If there are
new employees or if some have been terminated, on my database I have a way
to create that list and programmatically change the Org Chart to accommodate
the changes. No problem here.
My question, has anybody succesfully created an Org Chart via VBA code? Is
this even worth my while, since my org chart is huge (more than 1,000+
employees, by country and dept)? Were also talking about formatting, making
it look at least presentable (from using fonts, colors, and especially
fitting in one page).
Another reason for the automation, is that an analyst (not a programmer)
will be running this process. So, it is imperative that the application will
run smoothly and less hassle for the user.
Appeciate any replies.
NOTE: Yes, I have used The Org Chart wizard. But this feature just drops
everything dynamically and my challenge is to place each manager/position on
a certain X and Y location.
originally created from Excel.
My exposure to VBA is not super advanced, but have used it for the past
5yrs, from using DAO to ADO.
Now, I find this situation so daunting because I am unable to get myself
anywhere close to getting a final working product. I have taken some tips
from this newsgroup and from SDK, and still not getting anywhere.
What I did for the meantime, is create it manually in Visio. If there are
new employees or if some have been terminated, on my database I have a way
to create that list and programmatically change the Org Chart to accommodate
the changes. No problem here.
My question, has anybody succesfully created an Org Chart via VBA code? Is
this even worth my while, since my org chart is huge (more than 1,000+
employees, by country and dept)? Were also talking about formatting, making
it look at least presentable (from using fonts, colors, and especially
fitting in one page).
Another reason for the automation, is that an analyst (not a programmer)
will be running this process. So, it is imperative that the application will
run smoothly and less hassle for the user.
Appeciate any replies.
NOTE: Yes, I have used The Org Chart wizard. But this feature just drops
everything dynamically and my challenge is to place each manager/position on
a certain X and Y location.