In itself, this would be easy, BUT .....
1) I don't know in which folder the User keeps that workbook, and
2) The workbook name is only partly known, the rest is wild-card.
That's why - in my code - I ask the user to open one of the workbooks, so that I can determine the path name.
But I need to check whether he/she really did. In plain English, I try to test:
If Workbook "<unknown path-name>\Payroll for <wild-card>.xls" is open, then determine its path....else complain....
I know that wild-card should be " * ", but "\Payroll*.xls" doesn't seem to work.
Any advice?
Hi "Wino", nice to see you again...
Yes, that would work, if I go through 365 possibilities, because the wildcard is actually a date, like "Payroll - Mar 17, 2009.xls"
1) I don't know in which folder the User keeps that workbook, and
2) The workbook name is only partly known, the rest is wild-card.
That's why - in my code - I ask the user to open one of the workbooks, so that I can determine the path name.
But I need to check whether he/she really did. In plain English, I try to test:
If Workbook "<unknown path-name>\Payroll for <wild-card>.xls" is open, then determine its path....else complain....
I know that wild-card should be " * ", but "\Payroll*.xls" doesn't seem to work.
Any advice?
Hi "Wino", nice to see you again...
Yes, that would work, if I go through 365 possibilities, because the wildcard is actually a date, like "Payroll - Mar 17, 2009.xls"