Sage 100

We have the following and know the following bat file works for Sage 100 2016 Premium. We would like this to be in a macro for excel. I would rather not call the bat file but actually modify this to a shell command to work directly in a excel macro. I have one working for Standard as a VB in excel. We are having difficulty getting an equivalent to work in macro for Premium. S: cd\version2016\MAS90\Home pvxwin32.EXE -hd ..\launcher\sota.ini ..\SOA\Startup.m4p -ARG DIRECT UION ""odbc"" ""cbdo2008"" Z02 VIWI12 MANUAL

i have never worked with premium but you can run a VI job from vbscript/VBA using the shell object. Tested this on Advanced. ----------------------------------------- Set objShell = WScript.CreateObject(""WScript.Shell"") objShell.CurrentDirectory = ""\\SRV2012R2\Sage\Sage 100 Advanced ERP\MAS90\Home"" nRetval = objShell.Run(""pvxwin32.EXE -hd ..\launcher\sota.ini ..\SOA\Startup.m4p -ARG DIRECT UION """"user"""" """"password"""" company VIWX03 MANUAL"", 1, true) set objShell = nothing ----------------------------------------- This page https://ss64.com/vb/run.html has a good break down on the last two arguments of the Run method. EDIT: if using this in VBA/Excel use Set objShell = CreateObject(""WScript.Shell"") instead of Set objShell = WScript.CreateObject(""WScript.Shell"")

@MoiraGoggin This is a good one for the evernote KB.

**Done** Here it is: http://www.evernote.com/l/AQ4YP_tie4NJTKB-YDkVOWTzuTa5VBShbEM/