Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Please Help!!
I have a master file called "All Reports.xls" that opens up various Reports files(Ex: ABC_G016_GPUS.xls, BCD_G027_GPUS.xls, JKL_G034_GPUS.xls). The Report files are in the same network folder as the master file and are updated frequently. The Report files also have names that constantly change when they are updated. The only part of the filename that does not change begins with "G" followed by 3 numbers. By reading previous posts, I was able to figure out how to open the "G016" Report file with the code below. Workbooks.Open ActiveWorkbook.Path & "ABC_G016_GPUS.xls" How do I open the file by only the "G016" part of the filename? I tried the code below, but it did not work: Workbooks.Open ActiveWorkbook.Path & "*" & G016 & "*.xls" I appreciate your help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
opening file from ftp folder | Excel Discussion (Misc queries) | |||
Open and copy all workbook sheets in a folder to a master file | Excel Discussion (Misc queries) | |||
Opening and deleting File with only partial Filename | Excel Programming | |||
Opening and deleting File with only partial Filename | Excel Programming | |||
opening each file in a folder | Excel Programming |