Selecting Workbooks

[Guest]

After getting the user to select the file to open by:
fName = Application.GetOpenFilename
Workbooks.Open Filename:=fName
Any idea how can i refer to this workbook again later on in my code?

 

[JulieD]

Hi Darren

as long as you don't redefine fName

Workbooks(fName).Activate
or
Workbooks(fName).Sheets("Sheet1").Select
etc

Cheers
JulieD

 

[Tim Williams]

dim wb as workbook

fName = Application.GetOpenFilename
set wb=workbooks.open(fName)


Tim

 

[Guest]

Thanks guys

 

[Dave Peterson]

Watch out.

fName will include the drive\path when it comes back from .getopenfilename.

You could strip the drive\path out of the string, or use a variable like Tim
suggested.