Sage 100

I use the following code in my Access programs to call a VI job: ChDrive ""S"" ChDir ""S:\Sage100Prem\MAS90\HOME"" strAppName = ""S:\Sage100Prem\MAS90\HOME\PVXWIN32.EXE ..\LAUNCHER\SOTA.INI ..\SOA\STARTUP.M4P -ARG DIRECT UION BSG Password HFA VIWI1C MANUAL"" Call Shell(strAppName, 1) The Customer is currently using 4.3 but we in the process of moving them to Sage 100 2014 Premium. The code works fine with 4.3. When I tested the access programs with Sage 100 2014 Advanced it worked but now while testing with Sage 100 2014 Premium I am getting the following error: Sage 100 ERP The requested program is not installed on this system. Has the string that calls a VI job from outside changed? Thanks in advanced! Bob

Sorry, I should have done more testing. The problem was caused by the job not being compiled in the test system. It' working now.

Good ole VBA. Good stuff.

Robert, Here is a cut and paste from an Access application. I hope this helps. '-------------------------------------------------------------------------------------- 'Run MAS90 VI Imports - NOTES '1. The VI Import must be compiled and work properly from the VI menu. '2. The VI Import must be added to the ""JOBS"" menu in Visual Integrator. ' Select the ""Menu"" button while in the Job Import Maintenance and add it to the menu list. '3. Make sure that the user (sUser) on the command line has access to VI and ' can run the job you have defined. '4. The variable sHomePath must point to the MAS 90 Home folder. ""Q:\masV4\MAS90\Home\"" '5. The variable sUser must be a valid MAS 90 user defined in security. '6. The Variable sPass must be the password for sUser. '7. The variable sComp is the MAS 90 company ID. '8. The variable sProg is the VI program name. ""VIWI0D"" Get the valid name from VI. 'Set current Drive and Folder before launching MAS 90 Dim AppString As String AppString = Left(sHomePath, 1) ChDrive AppString ChDir sHomePath AppString = Chr(34) & sHomePath & ""PVXWIN32.ExE"" & Chr(34) & _ "" ..\launcher\sota.ini ..\soa\startup.m4p -ARG DIRECT UION "" & _ sUser & "" "" & sPass & "" "" & sComp & "" "" & sProg & "" DISPLAY"" 'MsgBox AppString Call Shell(AppString, vbNormalFocus)

Thanks Doug! Hope all is well over your way. Bob and I are twins.

That's xlnt @DougJenkins !

Thanks Doug for taking the time to share this. It is very helpful. Looks like I violated rule number 1. Thanks, Bob

Ron, I see the resemblance. Is Bob holding down the fort while you are out surfing?

Well, he does do all the work but no surfing for me. thanks for the help!