Run command from within VBA

[ttratl]

Hi there,

Anyone know how to get this run command to work from with a macro?

"C:\Program Files\Microsoft Office 2007\Office12\OUTLOOK.EXE" /ical E:\profile\Desktop\P&AEvalDate.ics

I've been searching all morning and I think it's somehow connected to the Shell command, but I've tried various syntax - and got nowhere so far.

Thanks.

 

[Sektor]

Sub R()
    Shell "C:\Program Files\Microsoft Office 2007\Office12\OUTLOOK.EXE /ical E:\profile\Desktop\P&AEvalDate.ics", vbNormalFocus
End Sub

 

[Ruddles]

I imagine it would be:-

Shell [B][COLOR=blue]"[/COLOR][COLOR=red]""[/COLOR][/B]C:\Program Files\Microsoft Office 2007\Office12\OUTLOOK.EXE[COLOR=red][B]""[/B][/COLOR] /ical E:\profile\Desktop\P&AEvalDate.ics[COLOR=blue][B]"[/B][/COLOR][COLOR=#000000], vbNormalFocus
[/COLOR]

(Not tested.)

 

[ttratl]

Thanks Ruddles, Sektor - they both work!

Thanks for speedy replies!