View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Rudski[_5_] Tom Rudski[_5_] is offline
external usenet poster
 
Posts: 5
Default 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