| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a file for read access
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting a file for read access
Someone please ? Floep -- floep ------------------------------------------------------------------------ floep's Profile: http://www.excelforum.com/member.php...o&userid=36853 View this thread: http://www.excelforum.com/showthread...hreadid=572180 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting a file for read access
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change a file from read only back to total access? | New Users to Excel | |||
| When opening Excel - get Access (Read-Only) file and error | Setting up and Configuration of Excel | |||
| tricky SQL problem using VBA Excel to read Access File | Excel Programming | |||
| i cannot open excel file error Cannot access read-only document me | Excel Worksheet Functions | |||
| Network access to file - read only property | Excel Discussion (Misc queries) | |||
![floep[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
