I am searching for a way to load data from a macro in the script, without using a temporay file.
I have a macro that extracts data from a specific source, unreachable by the standard connectors. The data is stored in a csv file created on the fly. Then I can read the csv file with the standard script.
I am searching for a direct way to add the data in a Qlikview table with the macro, to avoid the temporary csv file. I could loop on data and create an INLINE line for each row, but it would be ugly and I fear that the perfomance would be low.
Sorry for the delay. I work on this subject evening at home, and a bit during the lunch.
The global variables works, true. But it's VERY difficult to do VB under qlikview (switch between Script and Module, no debug, unexpected and random behavior in the call of subs and functions).
Moreover I have got an amazing issue about global variables "locked" that were randomly unavailable in 1 load.
