6 Replies Latest reply: Feb 5, 2014 10:32 AM by Friedrich Hofmann RSS

    Loading Data from Password Protected Excel Documents

      I'm trying to find a tidy way of loading Data from an Excel protected workbook. I've seen the solution in the link below but cannot get this to work?

       

      load a Password protected Excel File to QlikView

       

      Ive checked command line options and had a play with vba code, opening a documentand trying to save a temp unprotected version but

       

      a) I cannot get it to work

      b) want to avoid any vba as it causes difficulties for support?

       

      I am using QV 11.2 SR4   and Excel 2013 on windows 8 (IE 10)

       

      Any ideas?

       

      Thank You?