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?

Hi Darren

as long as you don't redefine fName

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

Cheers
JulieD


"Darren" wrote in message
...
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?

dim wb as workbook

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


Tim

"Darren" wrote in message
...
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?

Thanks guys

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.



JulieD wrote:

Hi Darren

as long as you don't redefine fName

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

Cheers
JulieD

"Darren" wrote in message
...
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?

--

Dave Peterson