opening a workbook without knowing its exact location

  • Thread starter Thread starter Johan
  • Start date Start date
J

Johan

hello,

I'm trying to write code to open a workbook of which I don't know the exact
location.

Can anybody help me?

Thanks, Johan
 
Hi Johan
so you're looking for a file search mechanism (which scans through
subdirectories)?
 
Johan,

Take a look at the GetOpenFilename method in help. It gives a file browser
type dialog to go and find the file.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Unwanted workbooks on startup 2
How to Unlock Excel Workbook protected by MACRO Password 6
How to change a sheet name without opening the workbook 3
button for saving all workbooks 6
Excel Protection 2
values from workbook without opening it 5
Prevent Copying of Excel Workbooks in 2000 and 2003. 2
Open a Workbook using VB 2

Back
Top