View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew Hall NZ Andrew Hall NZ is offline
external usenet poster
 
Posts: 21
Default Problem with Shell command

I want to be able to open some pdf and htm files from Outlook and from xcel.
I am using

Sub testsh()
Dim target As String
target = "C:/vba/copy7.htm"
Shell "Start " & target
End Sub

This fails with "file not found"

Given that I have successfully opened the file to read the text from excel
and also that it runs fine from cmd.exe, I know the path is right. Is there
some security setting or reference that is missing? This problem occurs
regardless of the file I attempt to target. I am running XP in Classic mode.

TIA

Andrew