none
evaluate and workbookname with space RRS feed

  • Question

  • Hello;

    I want to evaluate a refernce in a workbout which has a space in its name, but this fails.

    When I save the workbook without spaces then evaluate works.

    Not working:

    evaluate("[HFilter Example.xlsx]Sheet1!J3")

    Working:

    evaluate("HFilter_Example.xlsx]Sheet1!J3")

    How must I handle the space so that evaluate works ?

    tia

      Hendrik

    Monday, March 25, 2019 2:19 PM

Answers

  • Enclose the workbook+sheet name in straight single quotes:

    Evaluate("'[HFilter Example.xlsx]Sheet1'!J3")


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by h_schmieder Tuesday, March 26, 2019 10:28 AM
    Monday, March 25, 2019 7:59 PM