Go Back   Access World Forums > Apps and Windows > VB.NET

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-25-2015, 06:47 AM   #1
Rx_
Nothing In Moderation
 
Rx_'s Avatar
 
Join Date: Oct 2009
Location: Denver, Colorado
Posts: 2,745
Thanks: 606
Thanked 327 Times in 299 Posts
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.

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/lib...or=-2147217396

Excel Release Check List - for .NET language
https://www.add-in-express.com/creat...l-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/200...y-from-access/

C# Excel Tutorial
http://csharp.net-informations.com/e...l-tutorial.htm
VB.NET Excel Tutorial - notice VB.net not as common now as C#
http://vb.net-informations.com/excel..._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

__________________
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
Reply

Tags
access 2013 , automation , c## , excel , vb.net

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
No Thin Border Style in Office 2013 Zymos Forms 0 12-04-2014 01:56 PM
Installing Office 2007 after 2013 ions General 25 08-20-2014 05:42 AM
Office 365 Home Premium (Access) Vs the MS Office 2013 disk Mike375 General 3 02-27-2014 09:47 AM
MS Office 2013... no mention of new Access capabilities mdlueck General 2 01-29-2013 10:37 AM
Office 2013 ScottXe General 6 07-27-2012 08:39 AM




All times are GMT -8. The time now is 11:16 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World