Article ID: 153307 - View products that this article applies to.
This article was previously published under Q153307
Using Automation, you can manipulate Microsoft Excel. It is possible to call macro procedures that are stored in Microsoft Excel Workbooks by using the Run method of the Microsoft Excel Application object. Microsoft Excel macro procedures that take parameters cause a slight change in the syntax. Included below is a code sample showing how to call a Microsoft Excel macro procedure from Visual Basic.
For more information about using Visual Basic to Automate Excel, see the following:
(https://support.microsoft.com/kb/219151/EN-US/ )How To Automate Microsoft Excel from Visual Basic
Article ID: 153307 - Last Review: May 10, 2007 - Revision: 5.1