View Single Post
  #13   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

That is great Luc, thanks. I now have two solutions both of which work with
spaces in file and folder names, the shorter one being:

target = """C:\vba\test this\VB & VBA in a Nutshell (VB6).1998.OReilly.pdf"""
Shell "cmd /cStart """" " & target

The longer one is given in my second post

Andrew