Thread: [Solved] C# / vb.net & vba?
View Single Post
 
Old 02-03-2012, 03:56 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi tinfanide,

The various versions of VBA can be likened to dialects of VB6. Because VBA is application-specific, Word, Excel, Access, etc will each have will have methods, etc that aren't found in the others. VB6 won't have any of these application-specific extensions.

The MSDN pages will provide examples in various languages, because MS supports them (eg via Visual Studio), not because they're interchangeable.

Whilst you could add C# code to a VBA module, VBA wouldn't know what to do with it; you'd have to pass the C# code as a string or a series of strings to a C# compiler. And that entails automating the C# compiler.

Code written in C#, VB6, VB.NET, etc, can be used to control Office Applications by hooking into the application's VBA.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote