Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
I cant use all the functions in Excel,so the program's useless | Excel Worksheet Functions | |||
how to run other program's macro in excel? | Excel Programming | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
Writing an Excel Spreadsheet via a program's output | Excel Programming |