J'ai essayé de faire un macro sur open office qui crée une nouvelle feuille, avec "oSheets.insertByName("Link", oLinkSheet)", mais a chaque fois j'ai un message d'erreur " Runtime erreur BASIC Variable d'objet non définie."
Sub Maine()
Dim oLinkSheet As Object
oSheets.insertByName("Link", oLinkSheet)
End Sub
De même quant je lance le macro Dépot (cf i
mage), il y a le même message d'erreur.
Function CheckHistoryControls()
Dim bLocGoOn as Boolean
Dim Firstdate as Date
Dim LastDate as Date
LastDate = CDateFromISO(StockRatesModel.txtEndDate.Date) 'Erreur à cette instruction
FirstDate = CDateFromISO(StockRatesModel.txtStartDate.Date)
bLocGoOn = FirstDate <> 0 And LastDate <> 0
If bLocGoOn Then
If FirstDate >= LastDate Then
Msgbox(sMsgStartDatebeforeEndDate,16, sProductname)
bLocGoOn = False
End If
End If
CheckHistoryControls = bLocGoon
End Function
Alors que la macro Euro fonctionne bien.
Pour résumé : (cf
listes des macros)
[Macros et boîtes de Dialogue OpenOffice.org].Depot --> Erreur ligne 8 " LastDate = CDateFromISO(StockRatesModel.txtEndDate.Date) "
[Macros et boîtes de Dialogue OpenOffice.org].Euro --> Fonctionne
[Macros et boîtes de Dialogue OpenOffice.org].FormWizard --> Erreur ligne 12 " If oDBContext.HasElements Then "
[Macros et boîtes de Dialogue OpenOffice.org].Gimmicks --> Fonctionne
[Macros et boîtes de Dialogue OpenOffice.org].ImportWizard --> Erreur Ligne 5 "lRetValue = RegOpenKeyEx(lBaseKey, sKeyName, 0, KEY_ALL_ACCESS, hKey)" de la fonction "OpenRegKey"
[Macros et boîtes de Dialogue OpenOffice.org].Launcher --> Fonctionne
[Macros et boîtes de Dialogue OpenOffice.org].Schedule --> Erreur à la ligne " oStatusline = oDocument.GetCurrentController.GetFrame.CreateStatusIndicator"
[Macros et boîtes de Dialogue OpenOffice.org].Template --> Erreur avec message " Une erreur s'est produite" sans autre indication
[Macros et boîtes de Dialogue OpenOffice.org].Tools --> Fonctionne
Donc je me demande si il n'y a pas un problème avec les macros d'openOffice.
La question : Il y a une manipulation spéciale a faire pour utiliser les macro sous open office et ainsi utiliser l'instruction "oSheets.insertByName"?
Note :
J'ai la version 2.3 d'OpenOffice
[root@localhost ~]# yum remove openoffice.org-core
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package openoffice.org-core.i386 1:2.3.0-6.11.fc8 set to be erased
--> Processing Dependency: libavmedia680li.so for package: openoffice.org-calc
--> Processing Dependency: libbasegfx680li.so for package: openoffice.org-graphicfilter
--> Processing Dependency: libbasegfx680li.so for package: openoffice.org-calc
--> Processing Dependency: libbf_go680li.so for package: openoffice.org-calc
--> Processing Dependency: libbf_ofa680li.so for package: openoffice.org-calc
--> Processing Dependency: libbf_sb680li.so for package: openoffice.org-calc
--> Processing Dependency: libbf_svx680li.so for package: openoffice.org-calc
--> Processing Dependency: libbf_xo680li.so for package: openoffice.org-calc
--> Processing Dependency: libcomphelp4gcc3.so for package: openoffice.org-writer
--> Processing Dependency: libcomphelp4gcc3.so for package: openoffice.org-graphicfilter
--> Processing Dependency: libcomphelp4gcc3.so for package: openoffice.org-base
--> Processing Dependency: libcomphelp4gcc3.so for package: openoffice.org-math
--> Processing Dependency: libcomphelp4gcc3.so for package: openoffice.org-calc
--> Processing Dependency: libdbtools680li.so for package: openoffice.org-base
--> Processing Dependency: libdbtools680li.so for package: openoffice.org-calc
--> Processing Dependency: libdbu680li.so for package: openoffice.org-base
--> Processing Dependency: libfile680li.so for package: openoffice.org-calc
--> Processing Dependency: libgo680li.so for package: openoffice.org-graphicfilter
--> Processing Dependency: libgo680li.so for package: openoffice.org-calc
--> Processing Dependency: libi18nisolang1gcc3.so for package: openoffice.org-base
--> Processing Dependency: libi18nisolang1gcc3.so for package: openoffice.org-calc
--> Processing Dependency: libjvmaccessgcc3.so.3 for package: openoffice.org-graphicfilter
--> Processing Dependency: libjvmaccessgcc3.so.3(UDK_3.1) for package: openoffice.org-graphicfilter
--> Processing Dependency: libjvmaccessgcc3.so.3(UDK_3_0_0) for package: openoffice.org-graphicfilter
--> Processing Dependency: liblegacy_binfilters680li.so for package: openoffice.org-calc
--> Processing Dependency: liblegacy_binfilters680li.so(UDK_3_0_0) for package: openoffice.org-calc
--> Processing Dependency: libsb680li.so for package: openoffice.org-writer
--> Processing Dependency: libsb680li.so for package: openoffice.org-calc
--> Processing Dependency: libsd680li.so for package: openoffice.org-draw
--> Processing Dependency: libsd680li.so for package: openoffice.org-impress
--> Processing Dependency: libsfx680li.so for package: openoffice.org-writer
--> Processing Dependency: libsfx680li.so for package: openoffice.org-base
--> Processing Dependency: libsfx680li.so for package: openoffice.org-math
--> Processing Dependency: libsfx680li.so for package: openoffice.org-calc
--> Processing Dependency: libso680li.so for package: openoffice.org-writer
--> Processing Dependency: libso680li.so for package: openoffice.org-base
--> Processing Dependency: libso680li.so for package: openoffice.org-calc
--> Processing Dependency: libsoffice.so for package: openoffice.org-draw
--> Processing Dependency: libsoffice.so for package: openoffice.org-writer
--> Processing Dependency: libsoffice.so for package: openoffice.org-impress
--> Processing Dependency: libsoffice.so for package: openoffice.org-calc
--> Processing Dependency: libsot680li.so for package: openoffice.org-writer
--> Processing Dependency: libsot680li.so for package: openoffice.org-base
--> Processing Dependency: libsot680li.so for package: openoffice.org-math
--> Processing Dependency: libsot680li.so for package: openoffice.org-calc
--> Processing Dependency: libstlport_gcc.so for package: openoffice.org-graphicfilter
--> Processing Dependency: libstlport_gcc.so for package: openoffice.org-impress
--> Processing Dependency: libstlport_gcc.so for package: openoffice.org-pyuno
--> Processing Dependency: libstlport_gcc.so for package: openoffice.org-calc
--> Processing Dependency: libstlport_gcc.so for package: openoffice.org-base
--> Processing Dependency: libstlport_gcc.so for package: openoffice.org-writer
--> Processing Dependency: libstlport_gcc.so for package: openoffice.org-math
--> Processing Dependency: libsvl680li.so for package: openoffice.org-writer
--> Processing Dependency: libsvl680li.so for package: openoffice.org-base
--> Processing Dependency: libsvl680li.so for package: openoffice.org-math
--> Processing Dependency: libsvl680li.so for package: openoffice.org-calc
--> Processing Dependency: libsvt680li.so for package: openoffice.org-writer
--> Processing Dependency: libsvt680li.so for package: openoffice.org-graphicfilter
--> Processing Dependency: libsvt680li.so for package: openoffice.org-base
--> Processing Dependency: libsvt680li.so for package: openoffice.org-math
--> Processing Dependency: libsvt680li.so for package: openoffice.org-calc
--> Processing Dependency: libsvx680li.so for package: openoffice.org-draw
--> Processing Dependency: libsvx680li.so for package: openoffice.org-graphicfilter
--> Processing Dependency: libsvx680li.so for package: openoffice.org-impress
--> Processing Dependency: libsvx680li.so for package: openoffice.org-calc
--> Processing Dependency: libsvx680li.so for package: openoffice.org-base
--> Processing Dependency: libsvx680li.so for package: openoffice.org-writer
--> Processing Dependency: libsvx680li.so for package: openoffice.org-math
--> Processing Dependency: libsw680li.so for package: openoffice.org-writer
--> Processing Dependency: libtk680li.so for package: openoffice.org-writer
--> Processing Dependency: libtk680li.so for package: openoffice.org-base
--> Processing Dependency: libtk680li.so for package: openoffice.org-math
--> Processing Dependency: libtk680li.so for package: openoffice.org-calc
--> Processing Dependency: libtl680li.so for package: openoffice.org-writer
--> Processing Dependency: libtl680li.so for package: openoffice.org-graphicfilter
--> Processing Dependency: libtl680li.so for package: openoffice.org-base
--> Processing Dependency: libtl680li.so for package: openoffice.org-math
--> Processing Dependency: libtl680li.so for package: openoffice.org-calc
--> Processing Dependency: libucbhelper4gcc3.so for package: openoffice.org-writer
--> Processing Dependency: libucbhelper4gcc3.so for package: openoffice.org-base
--> Processing Dependency: libucbhelper4gcc3.so for package: openoffice.org-math
--> Processing Dependency: libucbhelper4gcc3.so for package: openoffice.org-calc
--> Processing Dependency: libuno_cppu.so.3 for package: openoffice.org-graphicfilter
--> Processing Dependency: libuno_cppu.so.3 for package: openoffice.org-impress
--> Processing Dependency: libuno_cppu.so.3 for package: openoffice.org-pyuno
--> Processing Dependency: libuno_cppu.so.3 for package: openoffice.org-calc
--> Processing Dependency: libuno_cppu.so.3 for package: openoffice.org-base
--> Processing Dependency: libuno_cppu.so.3 for package: openoffice.org-writer
--> Processing Dependency: libuno_cppu.so.3 for package: openoffice.org-math
--> Processing Dependency: libuno_cppu.so.3(UDK_3.1) for package: openoffice.org-calc
--> Processing Dependency: libuno_cppu.so.3(UDK_3_0_0) for package: openoffice.org-graphicfilter
--> Processing Dependency: libuno_cppu.so.3(UDK_3_0_0) for package: openoffice.org-impress
--> Processing Dependency: libuno_cppu.so.3(UDK_3_0_0) for package: openoffice.org-pyuno
--> Processing Dependency: libuno_cppu.so.3(UDK_3_0_0) for package: openoffice.org-calc
--> Processing Dependency: libuno_cppu.so.3(UDK_3_0_0) for package: openoffice.org-base
--> Processing Dependency: libuno_cppu.so.3(UDK_3_0_0) for package: openoffice.org-writer
--> Processing Dependency: libuno_cppu.so.3(UDK_3_0_0) for package: openoffice.org-math
--> Processing Dependency: libuno_cppuhelpergcc3.so.3 for package: openoffice.org-graphicfilter
--> Processing Dependency: libuno_cppuhelpergcc3.so.3 for package: openoffice.org-impress
--> Processing Dependency: libuno_cppuhelpergcc3.so.3 for package: openoffice.org-pyuno
--> Processing Dependency: libuno_cppuhelpergcc3.so.3 for package: openoffice.org-calc
--> Processing Dependency: libuno_cppuhelpergcc3.so.3 for package: openoffice.org-base
--> Processing Dependency: libuno_cppuhelpergcc3.so.3 for package: openoffice.org-writer
--> Processing Dependency: libuno_cppuhelpergcc3.so.3 for package: openoffice.org-math
--> Processing Dependency: libuno_cppuhelpergcc3.so.3(UDK_3.1) for package: openoffice.org-base
--> Processing Dependency: libuno_cppuhelpergcc3.so.3(UDK_3.1) for package: openoffice.org-calc
--> Processing Dependency: libuno_cppuhelpergcc3.so.3(UDK_3.2) for package: openoffice.org-base
--> Processing Dependency: libuno_cppuhelpergcc3.so.3(UDK_3_0_0) for package: openoffice.org-graphicfilter
--> Processing Dependency: libuno_cppuhelpergcc3.so.3(UDK_3_0_0) for package: openoffice.org-impress
--> Processing Dependency: libuno_cppuhelpergcc3.so.3(UDK_3_0_0) for package: openoffice.org-pyuno
--> Processing Dependency: libuno_cppuhelpergcc3.so.3(UDK_3_0_0) for package: openoffice.org-calc
--> Processing Dependency: libuno_cppuhelpergcc3.so.3(UDK_3_0_0) for package: openoffice.org-base
--> Processing Dependency: libuno_cppuhelpergcc3.so.3(UDK_3_0_0) for package: openoffice.org-writer
--> Processing Dependency: libuno_cppuhelpergcc3.so.3(UDK_3_0_0) for package: openoffice.org-math
--> Processing Dependency: libuno_sal.so.3 for package: openoffice.org-graphicfilter
--> Processing Dependency: libuno_sal.so.3 for package: openoffice.org-impress
--> Processing Dependency: libuno_sal.so.3 for package: openoffice.org-pyuno
--> Processing Dependency: libuno_sal.so.3 for package: openoffice.org-calc
--> Processing Dependency: libuno_sal.so.3 for package: openoffice.org-base
--> Processing Dependency: libuno_sal.so.3 for package: openoffice.org-writer
--> Processing Dependency: libuno_sal.so.3 for package: openoffice.org-math
--> Processing Dependency: libuno_sal.so.3(UDK_3.1) for package: openoffice.org-math
--> Processing Dependency: libuno_sal.so.3(UDK_3.1) for package: openoffice.org-calc
--> Processing Dependency: libuno_sal.so.3(UDK_3.3) for package: openoffice.org-graphicfilter
--> Processing Dependency: libuno_sal.so.3(UDK_3.3) for package: openoffice.org-impress
--> Processing Dependency: libuno_sal.so.3(UDK_3.3) for package: openoffice.org-pyuno
--> Processing Dependency: libuno_sal.so.3(UDK_3.3) for package: openoffice.org-calc
--> Processing Dependency: libuno_sal.so.3(UDK_3.3) for package: openoffice.org-base
--> Processing Dependency: libuno_sal.so.3(UDK_3.3) for package: openoffice.org-writer
--> Processing Dependency: libuno_sal.so.3(UDK_3.3) for package: openoffice.org-math
--> Processing Dependency: libuno_sal.so.3(UDK_3_0_0) for package: openoffice.org-graphicfilter
--> Processing Dependency: libuno_sal.so.3(UDK_3_0_0) for package: openoffice.org-impress
--> Processing Dependency: libuno_sal.so.3(UDK_3_0_0) for package: openoffice.org-pyuno
--> Processing Dependency: libuno_sal.so.3(UDK_3_0_0) for package: openoffice.org-calc
--> Processing Dependency: libuno_sal.so.3(UDK_3_0_0) for package: openoffice.org-base
--> Processing Dependency: libuno_sal.so.3(UDK_3_0_0) for package: openoffice.org-writer
--> Processing Dependency: libuno_sal.so.3(UDK_3_0_0) for package: openoffice.org-math
--> Processing Dependency: libutl680li.so for package: openoffice.org-writer
--> Processing Dependency: libutl680li.so for package: openoffice.org-graphicfilter
--> Processing Dependency: libutl680li.so for package: openoffice.org-base
--> Processing Dependency: libutl680li.so for package: openoffice.org-math
--> Processing Dependency: libutl680li.so for package: openoffice.org-calc
--> Processing Dependency: libvcl680li.so for package: openoffice.org-writer
--> Processing Dependency: libvcl680li.so for package: openoffice.org-graphicfilter
--> Processing Dependency: libvcl680li.so for package: openoffice.org-base
--> Processing Dependency: libvcl680li.so for package: openoffice.org-math
--> Processing Dependency: libvcl680li.so for package: openoffice.org-calc
--> Processing Dependency: libvos3gcc3.so for package: openoffice.org-base
--> Processing Dependency: libvos3gcc3.so for package: openoffice.org-calc
--> Processing Dependency: libxo680li.so for package: openoffice.org-writer
--> Processing Dependency: libxo680li.so for package: openoffice.org-graphicfilter
--> Processing Dependency: libxo680li.so for package: openoffice.org-base
--> Processing Dependency: libxo680li.so for package: openoffice.org-math
--> Processing Dependency: libxo680li.so for package: openoffice.org-calc
--> Processing Dependency: openoffice.org-core = 1:2.3.0-6.11.fc8 for package: openoffice.org-draw
--> Processing Dependency: openoffice.org-core = 1:2.3.0-6.11.fc8 for package: openoffice.org-graphicfilter
--> Processing Dependency: openoffice.org-core = 1:2.3.0-6.11.fc8 for package: openoffice.org-impress
--> Processing Dependency: openoffice.org-core = 1:2.3.0-6.11.fc8 for package: openoffice.org-pyuno
--> Processing Dependency: openoffice.org-core = 1:2.3.0-6.11.fc8 for package: openoffice.org-calc
--> Processing Dependency: openoffice.org-core = 1:2.3.0-6.11.fc8 for package: openoffice.org-langpack-en
--> Processing Dependency: openoffice.org-core = 1:2.3.0-6.11.fc8 for package: openoffice.org-base
--> Processing Dependency: openoffice.org-core = 1:2.3.0-6.11.fc8 for package: openoffice.org-writer
--> Processing Dependency: openoffice.org-core = 1:2.3.0-6.11.fc8 for package: openoffice.org-math
--> Processing Dependency: openoffice.org-core = 1:2.3.0-6.11.fc8 for package: openoffice.org-xsltfilter
--> Processing Dependency: openoffice.org-core = 1:2.3.0-6.11.fc8 for package: openoffice.org-langpack-fr
--> Running transaction check
---> Package openoffice.org-langpack-fr.i386 1:2.3.0-6.11.fc8 set to be erased
---> Package openoffice.org-draw.i386 1:2.3.0-6.11.fc8 set to be erased
---> Package openoffice.org-impress.i386 1:2.3.0-6.11.fc8 set to be erased
---> Package openoffice.org-pyuno.i386 1:2.3.0-6.11.fc8 set to be erased
---> Package openoffice.org-xsltfilter.i386 1:2.3.0-6.11.fc8 set to be erased
---> Package openoffice.org-math.i386 1:2.3.0-6.11.fc8 set to be erased
---> Package openoffice.org-graphicfilter.i386 1:2.3.0-6.11.fc8 set to be erased
---> Package openoffice.org-calc.i386 1:2.3.0-6.11.fc8 set to be erased
---> Package openoffice.org-writer.i386 1:2.3.0-6.11.fc8 set to be erased
---> Package openoffice.org-langpack-en.i386 1:2.3.0-6.11.fc8 set to be erased
---> Package openoffice.org-base.i386 1:2.3.0-6.11.fc8 set to be erased
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================
Package Arch Version Repository Size
=============================================================================
Removing:
openoffice.org-core i386 1:2.3.0-6.11.fc8 installed 205 M
Removing for dependencies:
openoffice.org-base i386 1:2.3.0-6.11.fc8 installed 4.5 M
openoffice.org-calc i386 1:2.3.0-6.11.fc8 installed 20 M
openoffice.org-draw i386 1:2.3.0-6.11.fc8 installed 2.9 M
openoffice.org-graphicfilter i386 1:2.3.0-6.11.fc8 installed 460 k
openoffice.org-impress i386 1:2.3.0-6.11.fc8 installed 4.8 M
openoffice.org-langpack-en i386 1:2.3.0-6.11.fc8 installed 21 M
openoffice.org-langpack-fr i386 1:2.3.0-6.11.fc8 installed 34 M
openoffice.org-math i386 1:2.3.0-6.11.fc8 installed 3.4 M
openoffice.org-pyuno i386 1:2.3.0-6.11.fc8 installed 395 k
openoffice.org-writer i386 1:2.3.0-6.11.fc8 installed 7.2 M
openoffice.org-xsltfilter i386 1:2.3.0-6.11.fc8 installed 257 k
Google et le forum sont resté muette sur mon problème
