| View previous topic :: View next topic |
| Author |
Message |
laurentiu
General User
Joined: 26 Feb 2003
Posts: 26
|
 Posted: Tue Jul 18, 2006 11:53 pm Post subject: macro translation |
 |
|
hello!
i have an macro in my excel book and i don't know how to translate this on oomacro:
ActiveWorkbook.Save
ActiveWorkbook.SaveAs Filename:= _
"ftp://10.9.1.10/depot/real.xls"
the recorded macro in oo require some parameters but i don't know how to put that.
thanks a lot |
|
| Back to top |
|
 |
uros
Super User
Joined: 22 May 2003
Posts: 601
Location: Slovenia
|
| Posted: Wed Jul 19, 2006 9:36 pm Post subject: |
|
|
Hi laurentiu!
Simple save under the same name - file have to be saved before:
| Code: | | ThisComponent.store |
File can be "saved as", in this case parameters are required. File can be save under new name:
| Code: | sUrl = ConverToURL("C:/mydir/myfile.sxc" ' if you use OOo 1.1.x
ThisComponent.storeAsURL(sUrl, Array())
|
File can be exported to some other file type:
| Code: | sUrl = ConverToURL("C:/mydir/myfile.sdc"
mFileProperties(0).Name = "Overwrite"
mFileProperties(0).Value = TRUE
mFileProperties(1).Name = "FilterName"
mFileProperties(1).Value = "StarCalc 5.0"
ThisComponent.storeAsURL(sUrl, mFileProperties())
|
Hope this helps!
Uros |
|
| Back to top |
|
|
|
