As the title said, I would like to run and control Enterprise Dynamics through Excel with VBA code. I'm used to work with the following function to open files with the associated program, declared like this:
Code: Select all
Public Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Code: Select all
unused = ShellExecute(0, vbNullString, ThisWorkbook.Path & "/Simulation.mod", vbNullString, ThisWorkbook.Path & "/", vbNormalFocus)
I'm wondering how to achieve this goal and obviously need a clue.
Cheers,
DjZU