Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: File Search

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Sydney, OZ
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Mat
    Are you using 2000 or 97?
    Tom

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Sydney, OZ
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •