li pan wrote:
Hi, I tried to create a database use macro like this:
Sub Main
sDBUrl = "private:factory/sdatabase"
oDoc = StarDesktop.loadComponentFromURL(sDBUrl,"_blank",0,Array())
oDoc.URL = ""
End Sub
but OO said that the URL property is readonly and can't be modified.
if I comment out that line
Sub Main
sDBUrl = "private:factory/sdatabase"
oDoc = StarDesktop.loadComponentFromURL(sDBUrl,"_blank",0,Array())
End Sub
the database will open but I can't modify anything of it.
the table wizard, the query wizard are disabled. and the url property
of it can't be modified too.
I have tried private:factory/sdatabase?Interactive, but the problem is
that I can't set the file name of it by macro, the wizard always ask
for a file name in the last step.
How can I create a empty database by macro? please help.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Il,
I believe your problem is that you must save the file before you can
actually change anything in it. ( might be wrong on that...I am often
enough )
You might want to grab the document AndrewBase.odt by Andrew Pitonyak at
http://www.pitonyak.org/oo.php
The first example macro shows how to do this.
Sincerely
Drew
|