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?
