I'm testig DynamicUpdateCommand for a Budget application.
I would like to update some fild applying personalized functions.
This is my first test, but it return me a Blank msg box
-------------------------
sub enrico
set docprop = ActiveDocument.GetProperties docprop.EnableDynamicDataUpdate=true ActiveDocument.SetProperties docprop
SET Result = ActiveDocument.DynamicUpdateCommand("UPDATE Products SET Prezzo=0") if Result = false then MsgBox Result.ErrorMessage else MsgBox("FATTO") end if ActiveDocument.Save end sub
------------------------------
The load script:
Inputfield Prezzo; Inputfield Quantita;
products: LOAD Prodotto, Prezzo, Quantita FROM sorgente_test_frutta.xlsx (ooxml, embedded labels, table is Foglio1);
-------------------------------
Where is the error ?
What is the best way for top->bottom or bottom->top functions ?
