Using the start in function when opening applications

[Mikeauz]

Hi,

I'm trying to use an Excel macro to open Lotus Notes R5. I've tried using the code:
RetVal = Shell("C:\Lotus\Notes\Notes.exe", 1)

but it just flashes up without opening, (As the normal shortcut contains "Startin %APPDATA%\Lotus\Notes\Data" as well as a link to Notes.exe)

Thanking you in advance

 

[hermanlaksko]

When I open an excel workbook I use this:
Set MyXL = GetObject(, "Excel.Application&quot
If Not IsNull(ExArk) Then Workbooks.Open ExArk
If MyXL.Workbooks.Count = 0 Then
MyXL.Workbooks.Add
End If
'and this is what makes excel visible to me:
MyXL.Application.Visible = True