Referring to a variable file name
 

With Bob Phillips help I can create a variable filename. The filename is
contained in a cell called Filename_Finance. When I try to activate the
window I can't make it work. I've tried the following code:

Windows.Range("Filename_Finance").Activate
Windows(Range("Filename_Finance")).Activate
Workbooks.Range("Filename_Finance").Activate
Workbooks(Range("Filename_Finance")).Activate

but none of these work. When using the workbooks option I was mindful to add
the .xls.

Can someone help please?

Referring to a variable file name
 

Try

Activesheet.Range("Filename_Finance").Activate

if the sheet with that range is not yet activated, you have to activate it
first.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Brettjg" wrote in message
...
With Bob Phillips help I can create a variable filename. The filename is
contained in a cell called Filename_Finance. When I try to activate the
window I can't make it work. I've tried the following code:

Windows.Range("Filename_Finance").Activate
Windows(Range("Filename_Finance")).Activate
Workbooks.Range("Filename_Finance").Activate
Workbooks(Range("Filename_Finance")).Activate

but none of these work. When using the workbooks option I was mindful to
add
the .xls.

Can someone help please?

Referring to a variable file name
 

I put Book2 in cell E9 and gave it the name
FILENAME_FINANCE
I made sure Book2.xls was already open and ran:

Sub brettjg()
Workbooks(Range("FILENAME_FINANCE").Value).Activat e
End Sub

and it ran just fine.

Must make sure the argument to Workbooks is a string and not a range.
--
Gary's Student
gsnu200708


"Brettjg" wrote:

With Bob Phillips help I can create a variable filename. The filename is
contained in a cell called Filename_Finance. When I try to activate the
window I can't make it work. I've tried the following code:

Windows.Range("Filename_Finance").Activate
Windows(Range("Filename_Finance")).Activate
Workbooks.Range("Filename_Finance").Activate
Workbooks(Range("Filename_Finance")).Activate

but none of these work. When using the workbooks option I was mindful to add
the .xls.

Can someone help please?

Referring to a variable file name
 

Thanks again Bob

"Bob Phillips" wrote:

Try

Activesheet.Range("Filename_Finance").Activate

if the sheet with that range is not yet activated, you have to activate it
first.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Brettjg" wrote in message
...
With Bob Phillips help I can create a variable filename. The filename is
contained in a cell called Filename_Finance. When I try to activate the
window I can't make it work. I've tried the following code:

Windows.Range("Filename_Finance").Activate
Windows(Range("Filename_Finance")).Activate
Workbooks.Range("Filename_Finance").Activate
Workbooks(Range("Filename_Finance")).Activate

but none of these work. When using the workbooks option I was mindful to
add
the .xls.

Can someone help please?

Referring to a variable file name
 

Thanks again GS. Bob replied with a solution as well, so I'll try them both
when I finish the current task. I'm putting the finishing touched on a
ridiculously complex suite of books that create up to five loan applications
and all the paperwork that goes with them in about 10 minutes. It's a blast,
but a pain in the neck at the minute!!

"Gary''s Student" wrote:

I put Book2 in cell E9 and gave it the name
FILENAME_FINANCE
I made sure Book2.xls was already open and ran:

Sub brettjg()
Workbooks(Range("FILENAME_FINANCE").Value).Activat e
End Sub

and it ran just fine.

Must make sure the argument to Workbooks is a string and not a range.
--
Gary's Student
gsnu200708


"Brettjg" wrote:

With Bob Phillips help I can create a variable filename. The filename is
contained in a cell called Filename_Finance. When I try to activate the
window I can't make it work. I've tried the following code:

Windows.Range("Filename_Finance").Activate
Windows(Range("Filename_Finance")).Activate
Workbooks.Range("Filename_Finance").Activate
Workbooks(Range("Filename_Finance")).Activate

but none of these work. When using the workbooks option I was mindful to add
the .xls.

Can someone help please?