VS Tools and VBA

(0) Share

Report

Posted on by Community Member

is it possible call a VBA Form window from VS Tools? Example in VSTools I have a form with a button and if I click it I would like to call a VBA form. So the same thing with VSIT when creating a new menu I would like to call a VBA form. I'm using Dynamics GP 2015 R2.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

No, I don't think so.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (2)

Report

I couldn't find a way to call VBA forms from VSTools but I could Add a link Menu in Dynamics GP 2015 using Visual Studio Integration Tool to Call a VBA Form which is more practical. All Documentation I've found was for Dynamics GP 10 and not for 14. I could find the eureka point after writing the author of VSIT - David M. So I would like to document my experience of How To Call VBA form Using VSIT For Dynamics GP 2015 it's very similar for Dynamics GP 2016.

1. (Required) Get Visual Studio Integration Toolkit here and it's blog is here then install it and yes it's free but need registration and it's easy process.

2. Get GP Power Tools here get registration 30 days trial. This tool have a lot of useful features that worth check out. For this purpose we are going to use it to unhide an internal windows in gp.

3. Once you get these tools, we need to unhide an internal window in Dynamics GP so, add it to VBA, and Add some field so we can call a VBA form. Follow these steps here and download sample code package.

4. So now, add the windows to VBA, import the package sample provided in the link in step 3 and after that in the VBA, look for the project Visual_Studio_Integration_Tool expand the folder Microsoft Dynamics GP Objects and you can see the API Windows.

5. Run the sample, maybe you need re login to Dynamics GP to see sample VBA links in Cards --> Inventory. So far you can add your own modifications in the code and export the package and the only step to do is install Visual Studio Integration Toolkit and import the package to the user you need to see your modified menu and links.

Note: In my case, I've created a module where my VBA forms are located by default. All these modifications are in Forms folder under Microsoft_Dynamics_GP in VBA. In this new module I've written functions to call form and verify some securities before open up a form instead of write all those in the API window code. Then reference in the Visual Studio Integration Tool, the Microsoft Dynamics GP and call from. In fact, I could not call a form directly even referenced, but I coud see the module then call the function.

Well, hope it works.

Was this reply helpful? Yes No
Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

That's a nice post. Thank you.

Was this reply helpful? Yes No