Hi all,

currently I'm busy with creating a link between Excel and Minitab by setting up a shell command.
First I just pasted the Windows path of the Minitab program, which worked perfectly. After that I wanted to go one step further: Opening a specific Minitab-file.
Therefore I created this code:

Private Sub Image2_Click()
'analysis - open Minitab

Dim WinPath As Range
Set WinPath = ThisWorkbook.Sheets("Hypothesis").Range("K7")

If IsEmpty(WinPath.Value) = True Then
MsgBox "Go to the dashboard and click the Six Sigma Tool button twice to enter your Minitab path."
Else
Call Shell(WinPath, 1)

End If
End Sub

So the user fills in the Mintab path into cell K7, which then shall be opened.
The error message I receive is:
Run-time error 5: Invalid procedure call or argument

Thanks in advance for your help!

Greets,
Sari