| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Reading from a closed file.
Upon opening my spreadsheet the user is greeted with a userform... They type in a folder name in a txtbox (txtprojno) then select 1 of 4 options from a combobox (combobox1) Upon clicking ok, i would like it to use the txtbox entry and combo box selection as part of the search path.... ie: if they type jim in txtprojno, then the search path will be... p:/blabla/JIM/filename.FILE Moving on furthur, they selection from the combobox will also become part of the search path... p:/blabla/JIM/Option1/filename.FILE Now excel knows where to find the file, how can i open it copy a certain range into my spreadsheet, Without actually having to open the file? Many thanks. Antonio King -- aking1987 ------------------------------------------------------------------------ aking1987's Profile: http://www.excelforum.com/member.php...o&userid=15393 View this thread: http://www.excelforum.com/showthread...hreadid=278302 |
|
#2
|
|||
|
|||
|
http://www.rondebruin.nl/ado.htm
-----Original Message----- Upon opening my spreadsheet the user is greeted with a userform... They type in a folder name in a txtbox (txtprojno) then select 1 of 4 options from a combobox (combobox1) Upon clicking ok, i would like it to use the txtbox entry and combo box selection as part of the search path.... ie: if they type jim in txtprojno, then the search path will be... p:/blabla/JIM/filename.FILE Moving on furthur, they selection from the combobox will also become part of the search path... p:/blabla/JIM/Option1/filename.FILE Now excel knows where to find the file, how can i open it copy a certain range into my spreadsheet, Without actually having to open the file? Many thanks. Antonio King -- aking1987 ---------------------------------------------------------- -------------- aking1987's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=15393 View this thread: http://www.excelforum.com/showthread...hreadid=278302 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| File asks to update when no links were created | Links and Linking in Excel | |||
| File is locked for Editing by user problem | Excel Discussion (Misc queries) | |||
| format question when open csv file | Excel Discussion (Misc queries) | |||
| Convert text file to MS_Excel | Excel Discussion (Misc queries) | |||
Linear Mode
