I need help.
I have a macro that goes through a daily list of teams and their results, and imports it into a generic template and saves it as the team/rep name in a specific folder on my desktop.
The next time this macro runs, it searches for the report name, and if it has already been created, it opens it up and imports the new data after the older data. This works fine, and has done every day for the last 4 odd months, however today I have an issue.
When the macro tries to create a file for the team name "OCA", it looks to see if it has already created this file (which it hasnt) but returns a true value, and attempts to open it.
What it is doing is trying to open a file with OCA in the title (eg: lOCAtion).
How do I do an obsolute search on a variable?
Currently I have this line in the macro:
.FileName = Report_Name
I have tried using .MatchCase and that doesnt work, and I have tried .MatchTextExactly but that wont work cause Im on a Mac.
Any thoughts would be appreciated.
Cheers.
I have a macro that goes through a daily list of teams and their results, and imports it into a generic template and saves it as the team/rep name in a specific folder on my desktop.
The next time this macro runs, it searches for the report name, and if it has already been created, it opens it up and imports the new data after the older data. This works fine, and has done every day for the last 4 odd months, however today I have an issue.
When the macro tries to create a file for the team name "OCA", it looks to see if it has already created this file (which it hasnt) but returns a true value, and attempts to open it.
What it is doing is trying to open a file with OCA in the title (eg: lOCAtion).
How do I do an obsolute search on a variable?
Currently I have this line in the macro:
.FileName = Report_Name
I have tried using .MatchCase and that doesnt work, and I have tried .MatchTextExactly but that wont work cause Im on a Mac.
Any thoughts would be appreciated.
Cheers.