Organizational charts
Jim,
Thanks for input....
Cannot find the file nor a directory.
I searched C" drive for 'org' and 'chart', found nothing for orgcharts.
Any idea, I can insert an orgcahrt in EXCEL, just can't automate it.
2nd question, if I can get this to work, I noticed that you can only update
teh text in the org box manually. There is not paste option. Is this org
cahrt that restrictive??
TIA
"Jim Cone" wrote:
Tom,
You can use the Shell function, but you have to know the file path...
'------------------------------
Sub TestShellFunction()
Dim RetVal As Variant
RetVal = Shell("C:\Program Files\Common Files\Microsoft Shared\Orgchart\ORGCHART.EXE", 1)
End Sub
'------------------------------
Jim Cone
San Francisco, USA
"Tom Rudski"
wrote in message
Why can't I record a macro showing 'Organization chart' inserts? Can I use
Organization charts programmatically in EXCEl. Do I have to set references
or add-in?
TIA
|