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