Thread: Shell function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil1982 Phil1982 is offline
external usenet poster
 
Posts: 10
Default Shell function

Through searching this site I've found out about the handy Shell function.

One thing that has dissapointed me about it though is that I expected you
could tell it to open files.......but it seems you can only tell it to open
the program

For example this didn't do what I'd hoped
Shell("C:\Music\Elvis.mp3", 1)

I hoped this would open winamp/win media player AND open the file


So does anyone know any tricks for opening non-Office files with VBA.
Preferably without having to use the Sendkeys function.

Thanks in advance