Please HELP ME with macro.
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 ?
Thanks
Enrico
