Not sure what mean by read access, but you can play with
Application.GetOpenFileName and its filter argument.
If it's an Excel file, you can then .open it Read-Only.

NickHK

"floep" ¼¶¼g©ó¶l¥ó·s»D:floep.2cmy5e_1155736215.1673@excelf orum-nospam.com...

Hi Guys,

I was wondering if there is a simple way to let my users select a
specific file which I will use for read access ? In the rest of the vba
script I will use this path as a parameter to fetch information from
this file. I have found a number of vba scripts for opening files but
they all have so much parameters and I guess I don't need most of them
..

Floep


--
floep
------------------------------------------------------------------------
floep's Profile:
http://www.excelforum.com/member.php...o&userid=36853
View this thread: http://www.excelforum.com/showthread...hreadid=572180