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

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

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

Tom,
If you are using Organization Chart then it is on your system somewhere.
I don't believe that it can be programmed using VBA, I have never
heard of it being done.
I am an infrequent user of OC and not prepared to answer questions about it.
Regards,
Jim Cone
San Francisco, USA



"Tom Rudski"

wrote in message

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