Visual Basic for Applications – Winthrop Development Consultants Blog

Development, Dexterity, GP Power Tools, Products, Visual Basic for Applications, Visual Studio, Visual Studio Integration Toolkit

#VSIT Custom Forms Module added to Visual Studio Integration Toolkit Build 18

Aug 29, 2023 Tagged with Development, Dexterity, GP Power Tools, GPPT, Visual Basic for Applications, Visual Studio Integration Toolkit, Visual Studio Tools, VSIT No Comments

The release of Build 18 of Visual Studio Integration Toolkit fulfills a long-term plan to add advanced modules to the product that extend its functionality beyond the original menu navigation that was offered by its predecessor, Menus for Visual Studio Tools for Microsoft Dynamics GP.

The last big jump in functionality happened with Build 15 when support for Area Pages was added to the Menus module, and over 260 Helper Functions exposing “Dexterity only” functionality to Visual Studio Tools developers was added to the Helpers module.

Build 18 adds an advanced Custom Forms module which allows Visual Studio Tools developers to create their own Dexterity custom windows. These custom forms have the advantage over WinForms as they will work on the Web Client and all other Microsoft Dynamics GP features.

Conference, Development, Dexterity, Dynamics, GP, GPUG, Microsoft, Modifier, Visual Basic for Applications, Visual Studio

#MySummitNA Materials from my Dynamics GP Development Tools Session

Oct 22, 2021 Tagged with Community Summit 2021, Conference, Development, Development Tools, Dexterity, GPUG, VBA, Visual Studio Tools No Comments

Community Summit Conference 2021, hosted by Dynamic Communities (DC) ran in Houston, Texas, USA last week from 12^th to 15^th October 2021.

I presented a session on Microsoft Dynamics GP development tools. Because I am still unable to leave Australia due to the pandemic border closures, the session was a pre-recorded video presentation.

Conference, Development, Dexterity, Dynamics, GP, GPUG, Microsoft, Modifier, Visual Basic for Applications, Visual Studio

#MySummitNA Don’t miss my Dynamics GP Development Tools Session

Oct 14, 2021 Tagged with Community Summit 2021, Conference, Development, Development Tools, Dexterity, GPUG, VBA, Visual Studio Tools No Comments

Community Summit Conference 2021, hosted by Dynamic Communities (DC), is happening right now in Houston, Texas, USA until from 12^th to 15^th October 2021.

I am presenting a session on Microsoft Dynamics GP development tools as the first session of the day on Friday. As I am still unable to leave Australia due to the pandemic border closures, the session has been pre-recorded and will be run as a video presentation.

However, I will be online in a Microsoft Teams Meeting for the duration of the session and would love for anyone attending the conference (and those just interested in GP Development) to join me and others in the community for a chat and Q & A session.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, Visual Basic for Applications

#GPPT Moving on from the Visual Basic for Applications (VBA) Mindset

Sep 17, 2021 Tagged with Development, GP Power Tools, GPPT, VBA, Visual Basic for Applications No Comments

As a follow on from yesterday’s article on how different languages can be used to drive the Microsoft Dynamics GP user interface, this article discusses the need to move away from the old Visual Basic for Applications (VBA) way of thinking. If you missed yesterday’s article, here is the link.

#MSDynGP Development: Driving the User Interface of Microsoft Dynamics GP using Code

Now that VBA is “End of Life” and many sites are starting to use GP Power Tools – Developer Tools module to replace the VBA business logic with GP Power Tools triggers and scripts. However some developers are still trying to write code as though they were still limited by VBA rather than leveraging the more powerful capabilities of GP Power Tools and Dexterity.

Development, Dexterity, Dynamics, GP, Microsoft, Visual Basic for Applications, Visual Studio

#MSDynGP Development: Driving the User Interface of Microsoft Dynamics GP using Code

Sep 16, 2021 Tagged with Development, Dexterity, VBA, Visual Studio Tools 4 Comments

Over the last couple of months I have been seeing a huge uptake on the sale and use of GP Power Tools – Development Tools module as more and more Microsoft Dynamics GP customer sites move their customizations away for the now “End of Life” Visual Basic for Applications (VBA).

This article explains some of the differences and techniques for the common method driving the user interface using code written in VBA, Dexterity and Visual Studio Tools (C# or Visual Basic .Net).

Conference, Development, Dexterity, Dynamics, GP, GPUG, Microsoft, Modifier, Visual Basic for Applications, Visual Studio

#MySummitNA Dynamics GP Development Tools Session

Aug 12, 2021 Tagged with Community Summit 2021, Conference, Development, Development Tools, Dexterity, GPUG, VBA, Visual Studio Tools No Comments

Dynamic Communities (DC), the team behind GPUG, will be hosting their Community Summit Conference on 12^th to 15^th October 2021. The agenda with sessions has now been posted online and I will be presenting a session on Microsoft Dynamics GP development tools.

Conference, Development, Dexterity, DUG, Dynamics, GP, Microsoft, Modifier, Visual Basic for Applications, Visual Studio

#DynamicsCon Dynamics GP Development Tools Session

Aug 10, 2021 Tagged with Conference, Development, Development Tools, Dexterity, DUG, DynamicsCon, VBA, Visual Studio Tools No Comments

The Dynamics User Group (DUG) will be hosting its DynamicsCon Conference on 20^th to 23^rd September 2021. The agenda with sessions has been posted online after the session voting and selection has been completed and I will be presenting a session on Microsoft Dynamics GP development tools.

Conference, Development, Dexterity, DUG, Dynamics, GP, Microsoft, Modifier, News, Visual Basic for Applications, Visual Studio

#DynamicsCon Last Chance to Vote for Sessions

Jul 28, 2021 Tagged with Conference, Development, Development Tools, DynamicsCon, News No Comments

Today is the last day to vote for your favourite DynamicsCon conference sessions ahead of the conference scheduled for 20^th to 23^rd September 2021.

Make sure that you register and apply your 12 votes today to shape what you want to see at the conference.

Development, Dexterity, DUG, Dynamics, GP, Microsoft, Modifier, News, Visual Basic for Applications, Visual Studio

#DynamicsCon Vote for Session: Microsoft Dynamics GP Development – Choosing the Right Tool

Jul 14, 2021 Tagged with Conference, Development, Development Tools, DynamicsCon, News No Comments

The next installment of DynamicsCon conference is scheduled for 20^th to 23^rd September 2021. The session submission period is over and now we enter the session voting period until 28^th July.

During this voting period all registered attendees have 12 votes to apply to sessions as they wish, then the votes will be tallied and the final session lists published. See this explanation for more details of the process.

Development, Dynamics, GP, GP Power Tools, Microsoft, Modifier, Products, Report Writer, Visual Basic for Applications

#VBA Solving VBA (Visual Basic for Applications) Compatibility Issues

Oct 29, 2020 Tagged with Application, Exception, GP Power Tools, GPPT, Visual Basic for Applications 5 Comments

In recent times many Microsoft Dynamics GP sites have been having issues with VBA (Visual Basic for Applications). Especially with Microsoft Office Updates breaking functionality and incompatibilities with later Windows Server releases.

There have been compatibility issues reported with sending emails via Outlook and more recently issues with VBA on Windows Server 2019.