shell関数で、指定したファイル名をCalcで開くマクロの実験 [LibreOffice Calc Basic]
shell関数で、指定したファイル名をCalcで開くマクロの実験
以前作った指定したファイル名でCalcを開くマクロが、何故かエラーを出すので、新しくShell関数で試してみて出来たのでメモ
ubuntu12.04 LibreOffice4.2.3では
Sub sonetBlog_Open()
'Shell関数を使用してファイルを開く
Shell("libreoffice -calc", 1,"/home/telstar/ドキュメント/LibreOffice/Calc/So-netBlog統合管理.ods")
End Sub
ubuntu10.04 LibreOffice4.1.5 では
Sub sonetBlog_Open()
'Shell関数を使用してファイルを開く
' Shell("libreoffice -calc", 1,"/home/telstar/ドキュメント/LibreOffice/Calc/So-netBlog統合管理.ods")
Shell("libreoffice4.1 -calc", 1,"/home/telstar/ドキュメント/LibreOffice/Calc/So-netBlog統合管理.ods")
End Sub
動作確認環境
- PC 東芝DynabookSatelliteJ11
- OS ubuntu12.04
- LibreOffice4.2.3.3
- PC 富士通FMV-830NU/L
- OS ubuntu10.04
- LibreOffice 4.1.5
Sub FileOpen_sonetblog()
'マクロでファイルを開く
Dim oDoc as object
'パスとファイル名
folder_Path="file:///home/telstar/ドキュメント/Libreoffice/Calc"
file_Name="So-netBlog統合管理.ods"
file_open=folder_Path & "/" & file_Name
'ファイルを開く
print file_open
oDoc=StarDesktop.loadComponentFromURL(file_open,"_blank",0, Array())
End Sub
追記
動作したマクロ
Sub LoadURL
'ファイルを開く
'参考サイト https://wiki.openoffice.org/wiki/JA/Documentation/BASIC_Guide/StarDesktop
Dim Doc As Object
Dim Url As String
Dim Dummy() 'It is an (empty) array of PropertyValues
Url = "file:////home/telstar/ドキュメント/LibreOffice/Calc/マクロ実験.ods"
Doc = StarDesktop.loadComponentFromURL(Url, "_blank", 0, Dummy)
End Sub
Hello!
http://v4professional.com/ , , http://c4professional.com/ , , http://v4sildenafil.com/ , , http://c4tadalafil.com/ , ,
by tadalafil (2016-04-13 03:01)
Side Effects Cephalexin Canine <a href=https://abuycialisb.com/#>Buy Cialis</a> Cialis Fatto In Casa <a href=https://abuycialisb.com/#>generic cialis online</a> Cialis Y Lactancia
by Janinsessy (2020-04-24 13:59)
Pills information. Short-Term Effects.
<a href="https://crestor4u.top">crestor for sale</a> in the USA
Some information about medicines. Read information now.
https://amp.en.vaskar.co.in/translate/1?to=ru&from=en&source=Pills%20prescribing%20information.%20Generic%20Name.%20%0D%0A%3Ca%20href%3D%22https%3A%2F%2Frisperdal4u.top%22%3Eonline%20risperdal%3C%2Fa%3E%20in%20Canada%20%0D%0AEverything%20information%20about%20drugs.%20Read%20information%20now.%20%0D%0A%20%0D%0Ahttps%3A%2F%2Fahimkh-yuluyuu-tny.blog.ss-blog.jp%2F2013-03-15%3Fcomment_success%3D2021-01-10T00%3A09%3A03%26time%3D1610204943%20Best%20news%20about%20pills.%20https%3A%2F%2F1m2i3k-f.blog.ss-blog.jp%2F2012-06-22%3Fcomment_success%3D2021-01-09T23%3A49%3A10%26time%3D1610203750%20Best%20trends%20of%20medicine.%20http%3A%2F%2F34bit.ru%2Fproducts%2Ftelefon-nokia-lumia-800%23comment_383055%20Actual%20news%20about%20medicament.%20%20a3c01d9%20&result=%D0%A2%D0%B0%D0%B1%D0%BB%D0%B5%D1%82%D0%BA%D0%B8%2C%20%D0%B2%D1%8B%D0%BF%D0%B8%D1%81%D1%8B%D0%B2%D0%B0%D1%8E%D1%89%D0%B8%D0%B5%20%D0%B8%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%86%D0%B8%D1%8E.%20%D0%A0%D0%BE%D0%B4%D0%BE%D0%B2%D0%BE%D0%B5%20%D0%98%D0%BC%D1%8F.%20%3Ca%20href%3D%22https%3A%2F%2Frisperdal4u.top%22%20%3E%20%D0%BE%D0%BD%D0%BB%D0%B0%D0%B9%D0%BD%20risperdal%3C%20%2F%20a%3E%20%D0%92%20%D0%9A%D0%B0%D0%BD%D0%B0%D0%B4%D0%B0%20%D0%B2%D1%81%D1%8F%20%D0%B8%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%86%D0%B8%D1%8F%20%D0%BE%20%D0%BD%D0%B0%D1%80%D0%BA%D0%BE%D1%82%D0%B8%D0%BA%D0%B0%D1%85.%20%D0%A7%D0%B8%D1%82%D0%B0%D0%B9%D1%82%D0%B5%20%D0%B8%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%86%D0%B8%D1%8E%20%D0%BF%D1%80%D1%8F%D0%BC%D0%BE%20%D1%81%D0%B5%D0%B9%D1%87%D0%B0%D1%81.%20https%3A%2F%2Fahimkh-yuluyuu-tny.blog.ss-blog.jp%2F2013-03-15%3Fcomment_success%3D2021-01-10T00%3A09%3A03%26time%3D1610204943%20%D0%BB%D1%83%D1%87%D1%88%D0%B8%D0%B5%20%D0%BD%D0%BE%D0%B2%D0%BE%D1%81%D1%82%D0%B8%20%D0%BE%20%D1%82%D0%B0%D0%B1%D0%BB%D0%B5%D1%82%D0%BA%D0%B0%D1%85.%20https%3A%2F%2F1m2i3k-f.blog.ss-blog.jp%2F2012-06-22%3Fcomment_success%3D2021-01-09T23%3A49%3A10%26time%3D1610203750%20%D0%BB%D1%83%D1%87%D1%88%D0%B8%D0%B5%20%D1%82%D0%B5%D0%BD%D0%B4%D0%B5%D0%BD%D1%86%D0%B8%D0%B8%20%D0%BC%D0%B5%D0%B4%D0%B8%D1%86%D0%B8%D0%BD%D1%8B.%20http%3A%2F%2F34bit.ru%2Fproducts%2Ftelefon-nokia-lumia-800%23comment_383055%20%D0%B0%D0%BA%D1%82%D1%83%D0%B0%D0%BB%D1%8C%D0%BD%D1%8B%D0%B5%20%D0%BD%D0%BE%D0%B2%D0%BE%D1%81%D1%82%D0%B8%20%D0%BE%20%D0%BA%D0%BE%D0%BC%D0%BF%D0%B0%D0%BD%D0%B8%D0%B8%20medicament.%20a3c01d9 Actual what you want to know about pills. http://barcelonaforum.ru/obschii-2/bryan-slater-621/#post200559 Some information about medicines. http://anatili.kazgazeta.kz/news/32389 Best news about medicament. 2efefa4
by DavidOta (2021-01-11 20:19)