version=1.1.0 vdate=10.02.2017 fname=udf_printref.bas ns=%NAMESPACE% fpath=/vba/functions ====== [VBA] printRef() ====== Schreibt die VBA-Referenzen als Liste in lesbarer Form ==Version %%version%% - %%vdate%%== {{%%fname%%|Download %%fname%% (V-%%version%%)}} Diese Funktion verwendet die UDF [[vba:functions:printlist]] ===== Beispiele ===== Ein Beispiel aus einem aktuellen Projekt. Ausgeführt im Direktfenster printref Name | Description | FullPath -------------------|-------------------------------------------------------------|-------------------------------------------------------------------------- VBA | Visual Basic For Applications | C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL Access | Microsoft Access 14.0 Object Library | C:\Program Files (x86)\Microsoft Office\Office14\MSACC.OLB DAO | Microsoft Office 14.0 Access database engine Object Library | C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL VBIDE | Microsoft Visual Basic for Applications Extensibility 5.3 | C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB Office | Microsoft Office 14.0 Object Library | C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\MSO.DLL VBScript_RegExp_55 | Microsoft VBScript Regular Expressions 5.5 | C:\Windows\SysWOW64\vbscript.dll\3 Excel | Microsoft Excel 14.0 Object Library | C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE MSComCtl2 | Microsoft Windows Common Controls-2 6.0 (SP6) | c:\windows\SysWow64\mscomct2.ocx MSComctlLib | Microsoft Windows Common Controls 6.0 (SP6) | C:\Windows\SysWOW64\MSCOMCTL.OCX ADODB | Microsoft ActiveX Data Objects 6.1 Library | C:\Program Files (x86)\Common Files\System\ado\msado15.dll stdole | OLE Automation | C:\Windows\SysWOW64\stdole2.tlb Scripting | Microsoft Scripting Runtime | C:\Windows\SysWOW64\scrrun.dll MSXML2 | Microsoft XML, v6.0 | C:\Windows\System32\msxml6.dll MSScriptControl | Microsoft Script Control 1.0 | C:\Windows\SysWOW64\msscript.ocx ===== Code =====