none
File Path Auto Search RRS feed

  • Question

  • How to get the file path of another file automatically when the file is copied to other folder using excel(formula only in excel not VBA)?Your suggestion is a BIG HELP!Thank You.Hoping for your immediate response.
    Tuesday, September 29, 2015 7:29 AM

Answers

  • How to get the file path of another file automatically when the file is copied to other folder using excel(formula only in excel not VBA)?

    No way, sorry.

    Do not copy the 2nd file, open both files then use SaveAs and save the 2nd file in a different folder.

    All your formulas that refers to that file are updated automatically.

    Andreas.

    Tuesday, September 29, 2015 10:06 AM