+ Reply to Thread
Results 1 to 3 of 3

“Object variable or With block variable not set” error while adding data into ArrayList

  1. #1
    Registered User
    Join Date
    08-18-2014
    Location
    Myanmar
    MS-Off Ver
    2010
    Posts
    3

    “Object variable or With block variable not set” error while adding data into ArrayList

    I'm new to VBA so I'm not pretty sure what I'm doing. Please be kind.

    What I'm trying to implement is, user select the files from File Picker and put the selected files' path into ArrayList. I created fileList as global variable then initialize it in Workbook_Open event.

    I'm getting Object variable or With block variable not set error in adding String into the ArrayList.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: “Object variable or With block variable not set” error while adding data into ArrayLis

    You can't use For Each loop.
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: “Object variable or With block variable not set” error while adding data into ArrayLis

    Thanks for the rep.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel VBA error code 91: Object variable or with block variable not set
    By wilnexpc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-24-2013, 11:46 AM
  2. Replies: 4
    Last Post: 07-12-2013, 12:14 PM
  3. Replies: 6
    Last Post: 12-21-2012, 08:03 AM
  4. Error 91 object variable block variable not set when importing a CVS file
    By ReportBuilder2011 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2011, 11:48 AM
  5. Object variable or With block variable not set" error message
    By JoeS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-22-2009, 11:51 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1