Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort Gavin Excel Worksheet Functions 0 May 17th 07 01:20 PM
I cant use all the functions in Excel,so the program's useless Disabled commands? Excel Worksheet Functions 1 February 24th 07 12:08 AM
how to run other program's macro in excel? Frank Kabel Excel Programming 0 December 13th 04 12:31 PM
translate lotus 1-2-3 macro into excel macro using excel 2000 krutledge0209 Excel Programming 1 November 2nd 04 05:50 PM
Writing an Excel Spreadsheet via a program's output Blake[_2_] Excel Programming 3 August 27th 03 11:20 AM


All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"