I want to load the FORMULAE from Excel cells not the values

[sarahallen1]

Is this possible?  I want to define fields etc in my LOAD statement as usual, but for the field values I want to read in the formula in each Excel cell, rather than the value.

Any ideas would be very welcome!

Thanks.

[tamilarasu]

Sarah,

       First, you need to take a copy of your source folder and need to run the macro. Hope you need your source files later. So, we can do all the replacing work in a copied files. Once we ran the macro, all files will be replaced with new changes. Now, you can load these files into qlikview without any issues.

I guess we can incorporate the vba into Qlikview and can call them while exection of load script. But I haven't tried this method.

[sarahallen1]

That would be great, thanks Petter.  Much appreciated.

[sarahallen1]

Thanks Tamil that makes sense.

[sarahallen1]

Hi petter-s‌,

This old requirement has resurfaced - I need to analyse the formulae in c. 500 Excel spreadsheets.  Back in 2016 you suggested you might have a sample app as I couldn't get your VBScript for UnZip to work.  Is this something you can provide now or give further help on? Very much appreciated.

Thanks,

Sarah