opening user specified file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have limited knowledge of vba. User enters filename in textbox...clicks
button to open file. What would this code look like and do I do this in an
event procedure?
 
Kate,
If you are trying to open a file (say xls, txt, or even program) you can
use shell command on event click (assuming you have a command button)
shell "test.txt"
or
Shell filename -> filename would be the name of your textbox.

If you are trying to open an Access form use docmd.openform method

Jeff
 
Hi Jeff,

My only other question is...where would I declare the filename to be the
text box so that I can use it in the onclick event? How would I declare this
also?
 
Back
Top