-
Shell Command results in Runtime Error 5
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules