Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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