Search:

Type: Posts; User: GrayS

Search: Search took 0.02 seconds.

  1. Re: Excel Runtime error 1004 FileName could not be found error

    Got it.
    THANK YOU for your help! Changed the error code line to be:

    Workbooks.Open ThisWorkbook.Path & "\DgetData.xls"

    And it works!
    You're a hero.
  2. Re: Excel Runtime error 1004 FileName could not be found error

    This sounds very hopeful....
    Please could you give me an example of it's usage, as I am not familiar with the syntax of this command? :blush:
    Cheers,
    Gray
  3. Re: Excel Runtime error 1004 FileName could not be found error

    I am very sorry, but why should I now need to specify the full path, when I never needed to previously?

    I swear it used to worked perfectly.....

    Also, I want to distribute these spreadsheets to...
  4. [RESOLVED] Excel Runtime error 1004 FileName could not be found error

    I am a noob to these boards (and fairly new to Excel VBA), so please forgive if this is a dumb question.

    I have an Excel 2003 spreadsheet ("DgetWork.xls") with some VBA to automatically open a...
Results 1 to 4 of 4



Click Here to Expand Forum to Full Width