ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   visual studio tools for office (https://www.excelbanter.com/excel-programming/328115-visual-studio-tools-office.html)

Art

visual studio tools for office
 
Hi,

Can anyone tell me if visual studio tools for office enables one to do
anything they couldn't do using visal studio? If not, does it make things
easier?

It sounds like an intriguing product, and there's an awful lot of material
to read to find out what it does -- but from the little I've read it seems
like it may merely be bits of code that the developer modifies.

Right now, when I do work on Excel, I use the VB editor in Excel. This is
not nearly as good as the visual studio environment -- additionally, it seems
that classes don't work exactly the same way. I'd appreciate a better way to
do things.

What do you think?

Art

Chip Pearson

visual studio tools for office
 
VTSO creates a DLL file containing a class called
OfficeCodeBehind which is linked via custom properties to a
particular workbook. Once this connection is established, you can
use all the tools in VSNET. I don't use VTSO very often, because
it doesn't really provide much more than does VBA and VB6.


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




"Art" wrote in message
...
Hi,

Can anyone tell me if visual studio tools for office enables
one to do
anything they couldn't do using visal studio? If not, does it
make things
easier?

It sounds like an intriguing product, and there's an awful lot
of material
to read to find out what it does -- but from the little I've
read it seems
like it may merely be bits of code that the developer modifies.

Right now, when I do work on Excel, I use the VB editor in
Excel. This is
not nearly as good as the visual studio environment --
additionally, it seems
that classes don't work exactly the same way. I'd appreciate a
better way to
do things.

What do you think?

Art





All times are GMT +1. The time now is 09:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com