Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling Excel macro from command line
Message
From
25/02/1998 19:02:49
Guy Barrette
Lasalle, Quebec, Canada
 
 
To
25/02/1998 16:22:16
Andrew Risenhoover
Rtis
Dallas, Texas, United States
General information
Forum:
Visual Basic
Category:
ActiveX controls
Title:
Re: Calling Excel macro from command line
Miscellaneous
Thread ID:
00081206
Message ID:
00081235
Views:
20
Here's how to do it:

set xl = CreateObject ("Excel.Application")
xl.Workbooks.Open ("c:\book1.xls")
ReturnValue = xl.Run ("FunctionName", "Argument")
Guy Barrette, MCSD
============
Blog http://weblogs.asp.net/guybarrette
Microsoft Regional Director, Montreal, Canada www.microsoft.com/rd
MVP, ASP.NET http://mvp.support.microsoft.com/
President, Montreal Visual Studio User Group www.guvsm.net
INETA Regional Rep for Quebec www.ineta.org
UniversalThread Magazine Columnist (.NET Books Review Column) www.utmag.com
Tech Chair French Track, DevTeach 2004 & 2005 www.devteach.com
Business Architect, Microsoft Team - Nurun Inc www.nurun.com
XBox Live Gamer Tag: Slomo QC CA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform