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
|