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 =====