Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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