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

shell(""C:/program files/yourprogram" "C:/music/your mp3"")
this should work

"Phil1982" wrote:

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