Hi,
I get spreadsheets from a system that generates names like "Report_154687.xls"
I cannot predict the serial number at the end, but would like to select the worksheet. Can you use wildcard functions to select sheets?
Please help?
Thanks!
Hi,
I get spreadsheets from a system that generates names like "Report_154687.xls"
I cannot predict the serial number at the end, but would like to select the worksheet. Can you use wildcard functions to select sheets?
Please help?
Thanks!
Hello contra76,
A worksheet is part of the workbook and not a separate file. I think you want to open a workbook using a wild card from a particular directory, don't you? What is the name of the directory where these files are saved?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
actually yes, you're right. I would like to select a workbook as opposed to a worksheet.
Let's say the directory is \\directory\projects\test_123123.xls
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks