Reading from a closed file.

A

aking1987

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 bo
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 becom
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
certain range into my spreadsheet, Without actually having to open th
file?

Many thanks.

Antonio Kin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to select combobx value with vba? 0
How can you generate an Excel file from a query that has parameter 4
EXCEL files and Windows - - an open and shut case? 0
Re-show userform after closing file - code help 3
Relative File Path Name 8
Open files from a file register 9
Userform, ComboBox and Outside data... 1
Path/File Access Close this error then Run-time '75' Error 0

Top