Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 67
Default Using VB.NET w/VBA

does anyone know if vb.net can be used when using VBA with Excel 2002?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default Using VB.NET w/VBA


"ibeetb" wrote in message
...
does anyone know if vb.net can be used when using VBA with Excel 2002?



VB.NET objects can be exported as COM objects, which can be used by VBA in
all recent Excel versions.

Jens.


--
Jens Thiel * Willy-Brandt-Allee 10 * D-53113 Bonn * +49 228 5400124
http://jens-thiel.de/ http://ManagedXLL.net/ http://QuantLib.net/
Replace MSDN with my first name when replying to my email address!


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 67
Default Using VB.NET w/VBA

what about the syntax....can vb.net syntax be used with vba?
"Jens Thiel" wrote in message
...

"ibeetb" wrote in message
...
does anyone know if vb.net can be used when using VBA with Excel 2002?



VB.NET objects can be exported as COM objects, which can be used by VBA in
all recent Excel versions.

Jens.


--
Jens Thiel * Willy-Brandt-Allee 10 * D-53113 Bonn * +49 228 5400124
http://jens-thiel.de/ http://ManagedXLL.net/ http://QuantLib.net/
Replace MSDN with my first name when replying to my email address!




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default Using VB.NET w/VBA

"ibeetb" wrote in message
...
what about the syntax....can vb.net syntax be used with vba?


VBA stays VBA :-(


--
http://jens-thiel.de/ | http://ManagedXLL.net/ |
http://QuantLib.net/
Replace MSDN with my first name when replying to my email address!


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 459
Default Using VB.NET w/VBA

If you want to see lots of VS.NET (VB and C# side-by-side) code which
uses MS Office VBA, take a look at the following MSDN article:

Programming Office Applications Using Microsoft Visual C#:
http://msdn.microsoft.com/library/de.../OffCSharp.asp

--

"ibeetb" wrote in message ...
what about the syntax....can vb.net syntax be used with vba?
"Jens Thiel" wrote in message
...

"ibeetb" wrote in message
...
does anyone know if vb.net can be used when using VBA with Excel 2002?



VB.NET objects can be exported as COM objects, which can be used by VBA in
all recent Excel versions.

Jens.


--
Jens Thiel * Willy-Brandt-Allee 10 * D-53113 Bonn * +49 228 5400124
http://jens-thiel.de/ http://ManagedXLL.net/ http://QuantLib.net/
Replace MSDN with my first name when replying to my email address!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"