How to reload a table? (problem with inputfield)

Thu, 24 Jan 2013 15:29:49 GMT

Hi, All

i am absolute nujbe

i have a table loaded from Excel and a macro changing the table (see applied files)

script for loading is:

SET ThousandSep=' ';
SET DecimalSep=',';
SET MoneyThousandSep=' ';
SET MoneyDecimalSep=',';
SET MoneyFormat='# ##0,00р.;-# ##0,00р.';
SET TimeFormat='h:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY h:mm:ss[.fff]';
inputfield @1;
inputfield @2;
data:
LOAD @1,
@2
FROM
C:\ExcelForVBS_02.xls
(biff, no labels);

macro is:

Sub ChangeTB01

set obj1 = ActiveDocument.GetSheetObject( "TB01" )

obj1.SetInputFieldCell 2,0,"99"

MsgBox "Ok"

End Sub

the problem is that i cannot reload the table, it doesnot changing, i.e. if the macro change the table i cannot return to the previous table by reloading the table from Excel

how to reload the table?

now i can reload only if i make a mistake in the loading script, then TB01 become empty and after removing the mistake i can reload, is there not so stupid way to reload?

QlikView Version 10

topic How to reload a table? (problem with inputfield) in QlikView

How to reload a table? (problem with inputfield)