Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
opening files
Brian,
What you need is the GetOpenFileName function. Use it like TheFileToOpen = Application.GetOpenFileName TheFileToOpen will contain a string Look in the help menu as you can use filters with it (among other things) (ie only look for xls or txt files) OpenWhat = Application.GetOpenFilename("Microsoft Excel Spreadsheets (*.xls), *.xls") Dan E "Brian" wrote in message ... How do I write the VBA code to prompt the user to select a file to open? In other words, I want the code to make the Excel 'Open' window appear in order for the user to browse for the appropriate file to open. Thanks in advance! Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show most recent files first when opening excel files | Excel Discussion (Misc queries) | |||
Opening Quattro Pro for Windows files (*.WB1 Files) using Excel 20 | Excel Discussion (Misc queries) | |||
How can I view files chronologically when opening multiple files | Excel Discussion (Misc queries) | |||
Opening Files with the Same Name | Excel Discussion (Misc queries) | |||
Opening files | Excel Programming |