MACRO CHANGEMENT DOCUMENT

[laubriat]

Hi
I open n documents sheet with automatic sqlrequet ( on a mysql base) and i want to copy the result of these requets in a writer document with a macro in BASIC
i cann't activate the writer document to execute the collate

i use following syntaxe to open documents and i don' t want to close an open the writer document each time i want make the collate

thanks if you have a sollution


oDesktop = createUnoService("com.sun.star.frame.Desktop")

sUrl = "file:///D:/mes_docs/rass/effectif.sxc"
oDocument1 = _
oDesktop.LoadComponentFromURL(sUrl,"_blank",0,Args())