| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Opening a file
Trying to create a macro that prompts the user to open a txt file.
FileName = InputBox("Please enter the Text File's name, e.g. test.txt") FileNum = FreeFile() Open FileName For Input As #FileNum But in place of having them enter the file name, I want to have them browse for the file then select it. This would be identical to File - Open, and the Open Browser window appears. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem opening Excel file | Excel Discussion (Misc queries) | |||
| Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
| Formula related Crash on Opening File | Excel Worksheet Functions | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| Opening a file with a Macro | Excel Discussion (Misc queries) | |||
Threaded Mode
