VBA Launch Navision Version 3.56

[superkris95]

Hello guys,

I have a task at work that is beyond my capabilities, and I of course already looked for inspiration..
At my work we can connect to our client from any computer at the location, so I guess we are using RDS (Remote Desktop Service).

I want excel VBA to launch Navision (version 3.56.A) ((c) 1987-1998 Navision Software a/s).
I have this as a shortcut on the desktop when I log in - its called Navision Server 7.

When I've figured out the launching, I also want to build in some steps where Excel extract different files from Navision.

What do I do and what do you need from me?


Kind regards,
Thomas

 

[sijpie]

Right click on your shortcut to edit it and copy the command line shown.

lets assúme it reads C:\\ProgramFiles\Navision.exe
If there is any text after the Navision.exe then that is an argument.

In Excel VBA copy the following macro:

Sub ShellNavision()
    Dim Arg As String
    Arg = "MyArgument"
    Shell "C:\Program Files\Navision.exe" & " " & Arg
End Sub

In the above replaceMyArgument with whatever argument was in the shortcut and on the Shell line replace the required text to open the Navision

Getting Navu=ision to do something will be more difficult. You can pass it keystrokes, but that is cumbersone to program, but doable