File Search

Mat Key · Apr 4th, 2002, 06:18 PM

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.

Tom Schreiner · Apr 4th, 2002, 07:29 PM

Hi Mat
Are you using 2000 or 97?
Tom

Mat Key · Apr 9th, 2002, 03:21 PM

Hi,

Im using Excel 98 for a Mac. I have worked out a way around it using error handlers but it's a bit messy. If there was a better way then that would be good to know.

Mat

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 06:18 PM	#1
Mat Key New Member Join Date: Apr 2002 Location: Sydney, OZ Posts: 4	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.

Apr 4th, 2002, 07:29 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Mat Are you using 2000 or 97? Tom

Apr 9th, 2002, 03:21 PM	#3
Mat Key New Member Join Date: Apr 2002 Location: Sydney, OZ Posts: 4	Hi, Im using Excel 98 for a Mac. I have worked out a way around it using error handlers but it's a bit messy. If there was a better way then that would be good to know. Mat