How to open a file by pressing a button ???

[Just4fun]

Hi All,

hope one of you can help me.

I would like to open a file by pushing a button.
Oke..I know how to.
for instance:
Workbooks.Open Filename:= _
"C:\My documents\dowcument.xls"


But it's a little more difficult.

say I ask for a 4 digits numeric input in a cell.


as an example: 1300 is entered.


Now, by (double)clicking the cell or
selecting the cell and pressing a button.
I would like to open this file:

"C:\My documents\1300_document.xls"




Your help would do me a great favor.

Thanks in advance, Theo.

 

[Juan Sanchez]

Theo

Try This, Just4fun:

Dim MyFile As String
MyFile = "C:\My Documents\" & ActiveCell.Value
& "_document.xls"
Application.Workbooks.Open MyFile

Cheers
Juan