.NET language Walkthrough (training) for MS Office 2013 (1 Viewer)

Rx_

Nothing In Moderation
Local time
Today, 06:48
Joined
Oct 22, 2009
Messages
2,803
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.

Versions:
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
https://msdn.microsoft.com/en-us/library/z63ctsh2.aspx?f=255&MSPPError=-2147217396

Excel Release Check List - for .NET language
https://www.add-in-express.com/creating-addins-blog/2013/11/05/release-excel-com-objects/

How to Reference a C# or VB.NET DLL from MSAccess
http://www.geeksengine.com/article/reference-dll.html
Other related articles discuss how to create the DLL for Access

A beginner's guide to calling .NET library from MSAccess
https://richnewman.wordpress.com/2007/08/25/a-beginner%e2%80%99s-guide-to-calling-a-net-library-from-access/

C# Excel Tutorial
http://csharp.net-informations.com/excel/csharp-excel-tutorial.htm
VB.NET Excel Tutorial - notice VB.net not as common now as C#
http://vb.net-informations.com/excel-2007/vb.net_excel_2007_tutorials.htm

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.
https://msdn.microsoft.com/en-us/magazine/cc163853.aspx
https://msdn.microsoft.com/en-us/magazine/cc163994.aspx
https://msdn.microsoft.com/en-us/magazine/cc164083.aspx

50 pages Excel 2003 Object Model Programming using .NET by Ken Getz
https://msdn.microsoft.com/en-us/lib...or=-2147217396
 
Last edited:

Users who are viewing this thread

Top Bottom