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

"Alexander Walker" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

[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


"Chip Pearson" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
> "Alexander Walker" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> >
>
>

[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

"gianni" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
> "Chip Pearson" <[email protected]> wrote in message
> news:%[email protected]...
>> 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
>>
>> "Alexander Walker" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>> >
>> >
>>
>>
>
>

[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,
--
Patrick Smith
Program Manager
Microsoft Office


"gianni" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
> "Chip Pearson" <[email protected]> wrote in message
> news:%[email protected]...
>> 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
>>
>> "Alexander Walker" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>> >
>> >
>>
>>
>
>

[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

"Patrick Smith [MSFT]" <[email protected]> wrote in message
news:%23DW%[email protected]...
> 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,
> --
> Patrick Smith
> Program Manager
> Microsoft Office
>
>
> "gianni" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> >
> > "Chip Pearson" <[email protected]> wrote in message
> > news:%[email protected]...
> >> 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
> >>
> >> "Alexander Walker" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > 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
> >> >
> >> >
> >>
> >>
> >
> >
>
>