View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default how to run other program's macro in excel?

From the SigmaPlot web site:

Tap into SigmaPlot's powerful capabilities from other applications


Call on SigmaPlot's functionality from external sources that have
Visual Basic embedded including Microsoft Word and Microsoft Excel or custom
software applications. Analyze and graph your data using SigmaPlot within
those applications. For example, you can run a Visual Basic script in
Microsoft Word or Excel that calls on SigmaPlot to generate and embed your
graph in the document. SigmaPlot's OLE automation provides unlimited
flexibility.



You need to consult you software documentation on how to automate SigmaPlot
from other software.

Some general information on using Automation:

Microsoft Office 97 Automation Help File Available (Q167223)
http://support.microsoft.com/default...b;EN-US;167223

Microsoft Office 2000 Automation Help File Available (Q260410)
http://support.microsoft.com/default...b;EN-US;260410

Microsoft Office XP Automation Help File Available (Q302460)
http://support.microsoft.com/default...b;EN-US;302460

http://msdn.microsoft.com/library/en...ortal_7l45.asp
Automation Programmer's Reference


http://support.microsoft.com/default...b;EN-US;253235
FILE: OFFAUTMN.EXE Discusses Office 97 and 2000 Automation and Provides
Sample Code

--
Regards,
Tom Ogilvy


"Yong" wrote in message
...
I recorded some macros in sigmaplot and all test passed. Could anybody

help
me how to run these macros in Excel's macro?
I am just start using vba, so many questions.
Thank you very much.
Yong