View Single Post
Old 03-25-2015, 06:47 AM   #1
Nothing In Moderation
Rx_'s Avatar
Join Date: Oct 2009
Location: Denver, Colorado
Posts: 2,794
Thanks: 635
Thanked 336 Times in 307 Posts
Rx_ has a spectacular aura about Rx_ has a spectacular aura about Rx_ has a spectacular aura about
Question .NET language Walkthrough (training) for MS Office 2013

Does anyone have good suggested sites or training for converting VBA into .NET - with an empasis on MS Office (Excel as the primary target)?

MS Office (including Access) uses VBA.
For Office Automation, the VBA in MS Access for example can be used to create a highly custom Excel workbook, worksheet completely from code.

My plan is to set up a self-training plan for learning VB.Net specifically to automate Excel. Thought I would share a few sites.

If anyone has other suggestions, including paid software, to accomplish this, please contribute ideas.

The older .net / office had different libraries. Take the older versions into context that some of the changes from older .net / office versions may not work as they use to.

Getting Started:
Microsoft Walk-through - step by step with testing at milestones

Excel Release Check List - for .NET language

How to Reference a C# or VB.NET DLL from MSAccess
Other related articles discuss how to create the DLL for Access

A beginner's guide to calling .NET library from MSAccess

C# Excel Tutorial
VB.NET Excel Tutorial - notice not as common now as C#

Older Ken Getz articles - must read for anyone changing VBA to C# or VB.NET Ken Getz was well known in the Access Development. While these articles are older, it might help someone prepare for the conversion task.

50 pages Excel 2003 Object Model Programming using .NET by Ken Getz

Were you lucky enough to get an answer? Please mark your question as [SOLVED] The original poster can go to Thread Tools to mark it as Solved.

Quotation Thomas Jefferson: "Peace is that brief glorious moment in history when everybody stands around reloading."

There are 2 Kinds of Countries on this Planet
1. Those that use the Metric System
2. Those that had a man walk on the moon

Denver, Colorado - The "Mile High City" - non-metric!

Last edited by Rx_; 03-25-2015 at 02:55 PM.
Rx_ is offline   Reply With Quote
The Following User Says Thank You to Rx_ For This Useful Post:
kyle-bos (05-10-2018)