.NET language Walkthrough (training) for MS Office 2013

mercredi 25 mars 2015

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

http://ift.tt/1y6E8Sh



Excel Release Check List - for .NET language

http://ift.tt/1y6E8Sm



How to Reference a C# or VB.NET DLL from MSAccess

http://ift.tt/1y6E8So

Other related articles discuss how to create the DLL for Access



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

http://ift.tt/1y6Eatq



C# Excel Tutorial

http://ift.tt/1y6Eatv

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

http://ift.tt/1y6E8Sw



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.

http://ift.tt/1CYd0wn

http://ift.tt/1y6E98M

http://ift.tt/1CYd2Ep

.NET language Walkthrough (training) for MS Office 2013

0 commentaires:

Enregistrer un commentaire

Labels