Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Looking for some direction!

Status
Not open for further replies.

Smitty020

MIS
Jun 1, 2001
152
US
I'm currently in the middle of an application in C# that automates Excel. Does anyone know of any sites/forums ect, that deal with this?

Thanks,

Smitty
 
Versions of Excel prior to Office 2003 don't come with a .NET primary interop assembly, so you have to create your own by setting a COM reference to the Excel COM automation library. Afterwards, it behaves just like it did under COM -- you instantiate an Application object and go from there.

The documentation (assuming you did a default install of Office) is at: C:\Program Files\Microsoft Office\Office10\1033\VBAXL10.CHM

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top