how to run other program's macro in excel?

[Yong]

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

 

[Guest]

Hi
dn't think this is possible (different application, systems, etc.) Maybe you
could explaing what you're exactly trying to achieve

 

[Tom Ogilvy]

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.aspx?scid=kb;EN-US;167223

Microsoft Office 2000 Automation Help File Available (Q260410)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;260410

Microsoft Office XP Automation Help File Available (Q302460)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;302460

http://msdn.microsoft.com/library/en-us/automat/htm/autoportal_7l45.asp
Automation Programmer's Reference


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