Window ("****.xls").Activate

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

I would like to know how to us a named range to provide
the file name vs. hard coding the file name.

Thanks
 
sFile = Range("myWorkbook")

Workbooks.Open Filename:= sFile

etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(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

Help with activating window from Application.GetOpenFilename 4
Put worksheet names from inactive file into cells of active worksh 2
Run macro from active workbook whose name keeps changing 20
Unable to change ActiveSheet within Workbook_Open 2
VBA code to copy named range in closed workbook 2
Help again!!! 1
Insert macro using current workbook 1
Copy Data from Closed File to Existing File 0

Back
Top