Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have a qvw file only for reload and execute macros.
After execute all I want to drop all tables.
I have that sub but i don't know how ho drop tables:
Sub Droptables
set doc=ActiveDocument
for i=0 to doc.GetTableCount-1
name = doc.GetTableName(i)
'doc.deletetable(name)
next
end sub
Why don't you do it in the script:
DROP TABLE YourTable;
or
DROP TABLES YourTable1, YourTable2;
HTH
Peter
Hi,
Not sure you can do this via the API. However, what is stopping you doing it at the end of your script?
Regards,
Stephen
Dear,
after reload, I'm executing a Macro that is doing some export.
After that, I want to clear all the data and save the file.
File is loading from another QVW and it's near 2 Gigs, and I don't want to have all the data on the file because it's reloading every day and i don't need the data.
Best regards.
Dear Luis,
thanks for your answer but How I can execute macro OnClose (I don't have that option to select on document propierties)
Saludos desde Barcelona.