7 Replies Latest reply: Jun 6, 2016 3:19 AM by Marcus Sommer RSS

    Load an Excel Table (ListObject)

    Jonathan Poyer

      Dear community,


      Loading Excel is so much fun. Though since 2003 we began to see a new type of object called ListObject. This object is quite similar to a named range but is in fact publicly named a Table. Since then many users are using this object. I can't find another parameter in the statement for file definition.


      While loading Named range is totally fine, loading a Table (or ListObject in VBA) seems impossible. Have you encounter this type of issue. How did you deal with that?


      Much thanks in advance.