I want to use C# instead of VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alexander Walker - 20 Jan 2006 21:20 GMT

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

Reply to this Message

Chip Pearson - 20 Jan 2006 21:25 GMT

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.

Signature

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

> Hello
>
[quoted text clipped - 15 lines]
>
> Thanks Alex

Reply to this Message

gianni - 23 Jan 2006 14:37 GMT

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

> At present, VBA is the only embedded language you can use in
> Excel (or any other Office program). MS hasn't announced any
[quoted text clipped - 19 lines]
> >
> > Thanks Alex

Reply to this Message

Maarten van Stam [MVP VSTO] - 23 Jan 2006 19:48 GMT

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

> Hi,
>
[quoted text clipped - 34 lines]
>> >
>> > Thanks Alex

Reply to this Message

Patrick Smith [MSFT] - 24 Jan 2006 00:04 GMT

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,

Signature

Patrick Smith
Program Manager
Microsoft Office

> Hi,
>
[quoted text clipped - 34 lines]
>> >
>> > Thanks Alex

Reply to this Message

gianni - 24 Jan 2006 08:15 GMT

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

> 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
[quoted text clipped - 40 lines]
> >> >
> >> > Thanks Alex

Reply to this Message