Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
variable file names | Excel Discussion (Misc queries) | |||
referring to a cell containing a file name | Excel Discussion (Misc queries) | |||
Variable File Name | Excel Worksheet Functions | |||
Inport from a variable file name | Excel Discussion (Misc queries) | |||
open file (as variable) from macro | Excel Discussion (Misc queries) |