Open a file by clicking a button ???

J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top