Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would like to know the code (to put within some other code), which will
run the Open file dialogue, & pointing to the desktop, so that a text file can be selected. (Then, I need that selected text file opened so that the macro will do some action on that file and revert back to the workbook for mor action.) I found something in help, which opens the dialogue box, but it does not open the file, just brings up a message box that tells me the file I've selected. Furthermore, is there a way for that code to point to any desktop no matter where it is located in the Windows Explorer tree? (As I plan to use the workbook on various machines.) Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open last file with certain file name | Excel Discussion (Misc queries) | |||
Macro syntax to open file in current explorer folder | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
How to stop file open macro prompt after deleting all macros? | Excel Worksheet Functions | |||
Macro to open specific File | Excel Discussion (Misc queries) |