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

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

.