View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
el_peacock el_peacock is offline
external usenet poster
 
Posts: 14
Default open image file from cell value

Hi
I want to be able to open an image file (jpg) based on the value of a cell.
I got as far as:
Sub OpenFileButton1_Click()
Workbooks.Open "C:\myfiles" & ActiveSheet.Range("C2").Value
End Sub

which opens an xls file (e.g. 1.xls) in the c:\myfiles folder. but what
code should I be using if I want to open e.g. 1.jpg in the same folder
Thanks for all your help!
--
---------
Gareth