I want to use C# instead of VBA

[Alexander Walker]

Hello

I would like to use C# to code against excel workbooks instead of VBA.

I am aware of the existence of Visual Studio Tools for Office but it doesn't fit
my needs.

Visual Studio tools for office creates a DLL that is accessed by the workbook.

Will a future version of excel support C# in such a way that it would be
possible to embed the source code as part of the XLS file? Does Visual Studio
Tools for office already allow this?

Thanks Alex

 

[Chip Pearson]

At present, VBA is the only embedded language you can use in
Excel (or any other Office program). MS hasn't announced any
plans to support other languages without VSTO.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[gianni]

Hi,

I have notice that Office 12, end-2006 release of office will support VSTA
(visual studio tool for application), that is now presented as next
generation of VBA. With VSTA it will possible programme Excel macro in .Net
code, but I don't knows if VSTA will be enbedded like VBA or not.
I hope that Microsoft will clarify as soon as possible the future scenario
around tool for programming office, to make possible right coice for
programmer that now must start programme Office with VBA or VTSO
alternative.
By
Gianni Chiappero

 

[Maarten van Stam [MVP VSTO]]

Developments on Office 12 now are subject to change and under NDA (Non
Disclosure). I would definitely advice you not to make any decisions on
where Office 12 is going right now.

Beta 2 will be 'public' and will give some more insight in what the final
version may look like. But even with Beta 2 you'll have to keep in mind that
features will be added, removed or removed before going final.

-= Maarten=-
MVP - Visual Developer - VSTO
http://blogs.officezealot.com/maarten

 

[Patrick Smith [MSFT]]

To clarify on this point, VSTA will not be available for Excel in Office 12.
VSTA is being implimented into InfoPath only. For Excel and other office
applications, VBA is the built in macro language and VSTO is the managed
solution.

Hope this helps,

 

[gianni]

thank you Patrick for information.
My e-mail reported information that I have read in a reportage form PDC 2005
conference in L.A., pubblished by Italian "VB & .Net Journal" (sept/oct
2005).
sorry for possible confusion that I have created.
By
Gianni