Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to activate a workbook through a cell reference. the workook
name is stored in cell A1 as "pnlreport_060321.xls". This name automatically changes daily based on the date. This is how I wrote the code to activate the workbook: Sub import() Dim fileA As String fileA = Range("A1").Value windows("fileA").Activate End Sub Please HELP. How would I activate a workbook which is already open. I cannot use the file name in the code because the name changes every day. Thanks : ) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Working within a workbook without activating it? | Excel Programming | |||
Working within a workbook without activating it? | Excel Programming | |||
Open workbook without activating it | Excel Programming | |||
Activating workbook with variable Name | Excel Programming | |||
Activating a workbook help | Excel Programming |