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
.