Rx_
Nothing In Moderation
- Local time
- Yesterday, 20:37
- 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
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: