LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Opening file by partial name in same folder as master file

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
opening file from ftp folder PBISMaryland Excel Discussion (Misc queries) 1 September 16th 09 11:37 AM
Open and copy all workbook sheets in a folder to a master file [email protected] Excel Discussion (Misc queries) 0 November 2nd 06 04:29 PM
Opening and deleting File with only partial Filename sean_f Excel Programming 0 April 20th 06 04:47 PM
Opening and deleting File with only partial Filename sean_f Excel Programming 0 April 20th 06 04:47 PM
opening each file in a folder JT Excel Programming 3 August 1st 05 06:35 PM


All times are GMT +1. The time now is 04:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"