Discussion Board for collaboration on QlikView Scripting.
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)
Go to Solution.
if you can get the dpt. to go along with this, just
- unprotect the workbook as a whole
- protect the individual sheets instead
=> QlikView will then read the file without problems.
Thanks DataNibbler (Love the name!)
Will give this a spin and let you know.
DataNibbler - This works a treat. Need to do this in conjunction with DataNibblers Answer. (Note there may be a security issue linking to a hidden workbook sheet from another workbook)
Here is what you do in Excel 2003: (variations also work for 2007,10,13)
Once this is done, the sheet is hidden and cannot be unhidden without the password. Make sense?
(Given Excel's backward compatibility, I'm sure you can do this in 2007)
hiding a sheet was not an option in my instance (the dpt. needs the Excel file themselves), but it sure is a good option.
Thanks for sharing this one!
Maybe, if you have time, you could make this last post into a small document and upload that?
Not too sure what you would like? Let me have a bit more info and I will do it. Also is there anyway i can mark you as correct answer as opposed to helpful?
I have done it already, don't bother ;-)
To mark my answer as correct, you have to unmark it first - and unmark your own answer ;-)