Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
manudenegri
Contributor III
Contributor III

How to use tables Resident from Macros

Hi I would like to use datas from a resident Table using macros

I have:

GRAPH:

LOAD * INLINE [

nombre, edad

CH22, 55

CH23, 55

CH24, 56

CH25, 57

CH26, 58

CH27, 59

];



And I want to acces to any cell of this table like if I was using "PEEK" function ... this is a very small example I need,

Thx a lot

M

2 Replies
settu_periasamy
Master III
Master III

Hi,

Can you tell what to do you want to achieve?

manudenegri
Contributor III
Contributor III
Author

Hi Settu

I need to read from Macro Module a resident Table loaded in Script

Y would like to have in a vba variabel the value of a cell of the table i.e value 56 from field "edad"

something like:

Dim Dato as Integer

Dato = '..... I don't know this sentence .....'   

msgbox Dato

This is what I need ... later I'll aply this concept to another thing

Thx a lot

M