View Excel Files from MS Access

[herd]

What I want to do is be able to open excel files (TA1, TA2, TA3, etc) by typing the file name into a text box on a ms access form and then click a button and the excel file opens.

Help please....Gary

 

[hymn]

Have you thought of Hyperlink

Hope this helps
Hymn

 

[herd]

There serveral files be added in this folder all the time, so I need to type the coorect file name to open the file. (example file names FA1, FA2, etc...

 

[PHV]

You may consider the Dir function to populate a ComboBox.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244