Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
; Winbatch 2004F - UDF to describe Excel 'References' ; includes suggestion to add reference ; ; Stan Littlefield - September 5, 2004 ;/////////////////////////////////////////////////////// #DefineSubroutine getrefs() VBPRef = oXL.ActiveWorkbook.VBProject.References cTxt = StrCat("Name,","Description,","GUID,","Major,","Minor,","Full_path",@CRLF) For i = 1 to VBPRef.Count cTxt = StrCat( cTxt,VBPRef.Item(i).Name,",") cTxt = StrCat( cTxt,VBPRef.Item(i).Description,",") cTxt = StrCat( cTxt,VBPRef.Item(i).GUID,",") cTxt = StrCat( cTxt,VBPRef.Item(i).Major,",") cTxt = StrCat( cTxt,VBPRef.Item(i).Minor,",") cTxt = StrCat( cTxt,VBPRef.Item(i).fullpath,@CRLF) Next VBPRef = 0 FilePut(cRef,cTxt) #EndSubRoutine BoxOpen("Collecting Excel References","Please Wait") cRef = Strcat( dirscript(),"XLRefs.txt") oXL = ObjectOpen( "Excel.Application" ) oXL.Visible = @FALSE oXL.DisplayAlerts = @FALSE oWK = oXL.workbooks oWK.add() ;or open a previously saved workbook to check it's references ;oWK.Open("C:\temp\book1.xls") getrefs() oWK = 0 oXL.Quit() oXL =0 If FileExist(cRef) Then Run("notepad.exe", cRef) Exit ;///////////////////////////////////////////////// ; how to add individual references ; use the GUID ; in this example, add a reference for the Outlook Library ID = oXL.VBProject.references ID.AddFromGuid("{00062FFF-0000-0000-C000-000000000046}",7,0) ; you should include an error-check as an error will ocur if the ; GUID is already added
XLREFS.TXT
Name,Description,GUID,Major,Minor,Full_path VBA,Visual Basic For Applications,{000204EF-0000-0000-C000-000000000046},4,0,C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL Excel,Microsoft Excel 11.0 Object Library,{00020813-0000-0000-C000-000000000046},1,5,C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE stdole,OLE Automation,{00020430-0000-0000-C000-000000000046},2,0,C:\WINDOWS\System32\stdole2.tlb Office,Microsoft Office 11.0 Object Library,{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52},2,3,C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL AcrobatPDFMaker,Acrobat PDFMaker 6.0 For Excel,,0,0,C:\Documents and Settings\Stan\Application Data\Microsoft\Excel\XLSTART\PDFMaker.xla AddInMgr,,,0,0,C:\Program Files\Microsoft Office\Office10\Addins\Add-ins\Addinmgr.xla AdobePDFMakerX,,{CBD71DF4-5AED-11D2-BC74-0060979C3633},1,0,C:\Program Files\Adobe\Acrobat 6.0\PDFMaker\Common\AdobePDFMakerX.tlb ASAPUtilities,,,0,0,C:\Program Files\ASAP Utilities\ASAP Utilities.xla atpvbaen.xls,,,0,0,C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis\ATPVBAEN.XLA funcres,,,0,0,C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis\FUNCRES.XLA Internet_Assistant,,,0,0,C:\Program Files\Microsoft Office\OFFICE11\Library\HTML.XLA MSForms,Microsoft Forms 2.0 Object Library,{0D452EE1-E08F-101A-852E-02608C4D0BB4},2,0,C:\WINDOWS\System32\FM20.DLL IasHelperLib, IAS Helper COM Component 1.0 Type Library,{6BC096BB-0CE6-11D1-BAAE-00C04FC2E20D},1,0,C:\WINDOWS\System32\iashlpr.dll IASRadiusLib, IAS RADIUS Protocol 1.0 Type Library,{6BC09890-0CE6-11D1-BAAE-00C04FC2E20D},1,0,C:\WINDOWS\System32\iasrad.dll VSFlex7,:-) VideoSoft VSFlexGrid 7.0 (OLEDB),{D76D7128-4A96-11D3-BD95-D296DC2DD072},1,0,C:\WINDOWS\SYSTEM32\vsflex7.ocx vsSpell,:-) Videosoft vsSpell Control,{E0DFB486-D33C-11D0-884D-0020AF039CA3},1,0,C:\Program Files\ResumeMaker\Vsspell.ocx vsThes,:-) Videosoft vsThesaurus Control,{E0DFB488-D33C-11D0-884D-0020AF039CA3},1,0,C:\Program Files\ResumeMaker\Vsthes.ocx Acrobat,Adobe Acrobat 6.0 Type Library,{78165D71-DF28-11D3-9A89-005004A56D53},1,0,C:\Program Files\Adobe\Acrobat 6.0\Acrobat\Acrobat.tlb AcrobatAccessLib,Acrobat Access 2.0 Type Library,{C523F390-9C83-11D3-9094-00104BD0D535},2,0,C:\Program Files\Adobe\Acrobat 6.0\Acrobat\plug_ins\Accessibility.api ACRODISTXLib,Acrobat Distiller,{317DA881-ECC5-11D1-B976-00600802DB86},1,0,c:\learn\acrobat\sdk5\InterAppCommunicationSupport\Headers\acrodistx.tlb AcrobatWeb2PDF,Acrobat WebCapture 1.0 Type Library,{C154AD8E-5B51-436E-83E2-B04E068C00E2},1,0,C:\Program Files\Adobe\Acrobat 6.0\Acrobat\plug_ins\WebPDF.api AcroIEClient,Acrobat WebCapture IE Toolbar/Favorites 1.0 Type Library,{04C567CB-A52F-41F4-9628-10CC965E7179},1,0,C:\Program Files\Adobe\Acrobat 6.0\Acrobat\AcroIEFavClient.dll ACROIEHELPERLib,AcroIEHelper 1.0 Type Library,{5F226421-415D-408D-9A09-0DCD94E25B48},1,0,C:\Program Files\Adobe\Acrobat 6.0\Acrobat\ActiveX\AcroIEHelper.dll ACSHELLEXTLib,ACShellExt 1.0 Type Library,{4E6DB7E0-2BCE-4572-9320-652F968C969A},1,0,C:\Program Files\Microsoft Plus!\MP3 Audio Converter\AcShellExt.dll ActiveDs,Active DS Type Library,{97D25DB0-0363-11CF-ABC4-02608C9E7553},1,0,C:\WINDOWS\System32\activeds.tlb ASControls,Active Setup Control Library,{CC0918E0-EFE5-11CF-A044-00AA00B6015C},1,0,C:\WINDOWS\System32\asctrls.ocx ActiveBarLibrary,ActiveBar Control,{0F987290-56EE-11D0-9C43-00A0C90F29FC},1,0,C:\Program Files\ResumeMaker\ActBar.ocx QuartzTypeLib,ActiveMovie control type library,{56A868B0-0AD4-11CE-B03A-0020AF0BA770},1,0,C:\WINDOWS\System32\quartz.dll ACTIVESKINLib,ActiveSkin 4.0 Type Library,{90F3D7B3-92E7-44BA-B444-6A8E2A3BC375},1,0,C:\WINDOWS\System32\actskin4.ocx PhotoshopTypeLibrary,Adobe Photoshop 7.0 Type Library,{4B0AB3E1-80F1-11CF-86B4-444553540000},7,0,C:\Program Files\Adobe\Photoshop 7.0\TypeLibrary.tlb AFORMAUTLib,AFormAut 1.0 Type Library,{7CD06992-50AA-11D1-B8F0-00A0C9259304},1,0,C:\Program Files\Adobe\Acrobat 6.0\Acrobat\plug_ins\Acroform.api AHEADAUTOSTARTLib,Ahead AutoStart 1.1 Type Library,{77DD9979-1F87-4430-8232-B5DDD9C2699F},1,1,C:\Program Files\Common Files\Ahead\Lib\apreg.dll AJB,,{8D9C65FF-ED8E-4C86-91C3-80B5CCDB6B63},1,0,C:\Documents and Settings\All Users\Application Data\Individual Software\ResumeMaker\R90\ResumeBanks\ajb.dll AOLFlashObjects,AOL Flash,{C114555B-A454-11D4-9020-00D0B7239081},1,0,C:\PROGRA~1\COMMON~1\AOL\Flasha.ocx TDBShare6,APEX True DBInput 6.0 (Shared Objects),{0ECF1540-FB21-11D1-AF40-006097476B29},1,0,C:\WINDOWS\System32\tishare8.dll QTActiveXPlugin,Apple QuickTime Control,{02BF25D2-8C17-4B23-BC80-D3488ABDDC6B},2,0,C:\Program Files\QuickTime\QTPlugin.ocx ASFCHOPLib,ASFChop 1.0 Type Library,{4D671821-9A5A-11D3-8EDC-00C04F6109CF},1,0,C:\WINDOWS\System32\wmidx.ocx ATContLib,ATCont 2.0 Type Library,{08B5B38B-1DE4-497A-B85A-550D082D7C07},2,0,C:\Program Files\Common Files\Microsoft Shared\Reference 2004\ATCONT.DLL ATFindLib,ATFind 2.0 Type Library,{535E9B88-578C-4ECA-8EB3-0002681BC68F},2,0,C:\Program Files\Common Files\Microsoft Shared\Reference 2004\ATFIND.DLL ATFlightLib,ATFlight 1.0 Type Library,{E677F62B-A233-4D6D-9D42-4C7229234324},1,0,C:\Program Files\Common Files\Microsoft Shared\Reference 2004\ATFLIGHT.DLL ATLLib,ATL 2.0 Type Library,{44EC0535-400F-11D0-9DCD-00A0C90391D3},1,0,C:\WINDOWS\System32\atl.dll ATP2,ATP 2.0 Type Library,{3F98D457-551B-48C5-BDE8-7FDECCD5AFA5},2,0,C:\Program Files\Common Files\Microsoft Shared\Web Components\11\ATP.DLL AUTOLIBLib,AutoLib 1.0 Type Library,{66D25B43-6ECD-11D4-A79F-00104B8D1B54},1,0,C:\Program Files\Iomega\AutoDisk\AutoLib.dll AXMETASTREAMLib,AxMetaStream 1.0 Type Library,{9DBB28C1-1925-11D3-A498-00104B6EB52E},1,0,C:\Program Files\Viewpoint\Viewpoint Media Player\AxMetaStream.dll BankTemplate,,{97C8C7CC-A261-11D1-AEEA-00A0C98E0C68},12,0,C:\Documents and Settings\All Users\Application Data\Individual Software\ResumeMaker\R90\ResumeBanks\BankTemplate.dll BestJobsUSA,,{E1607089-E67A-11D6-AE29-00D0B70E47C2},1,0,C:\Documents and Settings\All Users\Application Data\Individual Software\ResumeMaker\R90\ResumeBanks\bestjobsusa.dll BLOCKDRIVERLib,blockdriver 1.0 Type Library,{B842074C-8E12-4178-A6D8-7C0D7C87C43E},1,0,C:\WINDOWS\System32\hotplug.dll Brassring,,{C0445CF9-9A68-11D7-AD61-0010DC1E3D0B},1,0,C:\Documents and Settings\All Users\Application Data\Individual Software\ResumeMaker\R90\ResumeBanks\brassring.dll BRP_SYSINFOLib,brp_sysinfo 1.0 Type Library,{CA9F6CB1-47F1-4874-90CB-C674E9A86495},1,0,C:\WINDOWS\PCHealth\HelpCtr\Binaries\brpinfo.dll BusinessCalculators,BusinessCalculators Excel Add-in,{5CD55AB6-11E8-4AC9-A088-8F00637E4F0C},43,0,C:\Program Files\BusinessCalculators\BusinessCalculators.dll C1SizerPPGLib,C1Sizer Property Pages Type Library,{C3EF5731-FC46-4467-804E-9E1CC881A525},1,0,C:\WINDOWS\System32\c1sizerppg.dll CALCSTORELib,CalcStore 1.0 Type Library,{E5D0E05F-5309-11D1-A1F0-0000F875A2F0},1,0,C:\Program Files\Common Files\Microsoft Shared\Money\mscps.dll CAPTURELib,Capture 1.0 Type Library,{39AF6187-3468-476A-8E6F-36627D40353F},1,0,C:\PROGRA~1\MICROS~4\OFFICE11\MSWEBCAP.DLL CareerBuilder,,{746BE7AB-29A5-11D8-AD61-0010DC1E3D0B},1,0,C:\Documents and Settings\All Users\Application Data\Individual Software\ResumeMaker\R90\ResumeBanks\careerbuilder.dll Careerjournal,,{7BE8A7EC-A62A-11D7-AD61-0010DC1E3D0B},1,0,C:\Documents and Settings\All Users\Application Data\Individual Software\ResumeMaker\R90\ResumeBanks\careerjournal.dll CareerMag,,{1C772158-A564-11D7-AD61-0010DC1E3D0B},1,0,C:\Documents and Settings\All Users\Application Data\Individual Software\ResumeMaker\R90\ResumeBanks\careermag.dll CareerShop,,{B9EDD129-7636-11D7-AD61-0010DC1E3D0B},1,0,C:\Documents and Settings\All Users\Application Data\Individual Software\ResumeMaker\R90\ResumeBanks\careershop.dll CatalogServerLib,CatalogServer 1.0 Type Library,{E6BE109B-165F-11D1-B22D-00C04FB9473F},1,0,C:\WINDOWS\system32\catsrv.dll CERTCLIENTLib,CertCli 1.0 Type Library,{372FCE32-4324-11D0-8810-00A0C903B83C},1,0,C:\WINDOWS\System32\certcli.dll CERTMGRLib,CertMgr 1.0 Type Library,{53D6AB1C-2488-11D1-A28C-00C04FB94F17},1,0,C:\WINDOWS\System32\certmgr.dll CHILKATUTILLib,Chilkat Util 2.6.0,{246241C8-3F53-42D3-AF90-9FF544117B99},1,0,C:\Program Files\Chilkat Software Inc\Common\ChilkatUtil.dll CHILKATXMLLib,Chilkat Xml 4.1.0,{101F9C56-A0F3-455C-ABBB-191168ABCF94},1,0,C:\Program Files\Chilkat Software Inc\Chilkat XML\ChilkatXml.dll CICLib,cic 1.0 Type Library,{3D5905E0-523C-11D1-9FEA-00600832DB4A},1,0,C:\WINDOWS\System32\cic.dll CMPROPSLib,CMProps 1.0 Type Library,{A1B9E012-3226-11D2-883E-00104B2AFB46},1,0,C:\WINDOWS\System32\cmprops.dll COLBCATLib,COLBCAT 1.0 Type Library,{8C758293-9351-11D1-9D1A-006008B0E5CA},1,0,C:\WINDOWS\System32\clbcatex.dll Collegegrad,,{CC80909F-7ED4-42C4-822A-D60F0EC132C9},1,0,C:\Documents and Settings\All Users\Application Data\Individual Software\ResumeMaker\R90\ResumeBanks\collegegrad.dll COLOADERLib,coloader 1.0 Type Library,{79B1DAD0-D1B1-11D2-9930-00C04F68FDAF},1,0,C:\Program Files\Common Files\Microsoft Shared\VS7DEBUG\COLOADER.TLB COMAdmin,COM + 1.0 Admin Type Library,{F618C513-DFB8-11D1-A2CF-00805FC79235},1,0,C:\WINDOWS\System32\Com\comadmin.dll COMMKCABLib,COM MakeCab 1.0 Type Library,{8E17FFE3-C5BA-11D1-8D8A-0060088F38C8},1,0,C:\WINDOWS\system32\catsrvut.dll\6 COMSVCSLib,COM+ Services Type Library,{2A005C00-A5DE-11CF-9E66-00AA00A3F464},1,0,C:\WINDOWS\System32\COMSVCS.DLL COMEXPLib,ComExp 1.0 Type Library,{CFADAC75-E12C-11D1-B34C-00C04F990D54},1,0,C:\WINDOWS\system32\catsrvut.dll COMEXPSLib,ComExpS 1.0 Type Library,{99847C25-B1B4-11D1-8F10-00C04FC2C17B},1,0,C:\WINDOWS\system32\comuid.dll mscoree,Common Language Runtime Execution Engine 1.0 Library,{5477469E-83B1-11D2-8B49-00A0C9B7C9C4},1,1,C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\mscoree.tlb mscorlib,Common Language Runtime Library,{BED7F4EA-1A96-11D2-8F08-00A0C9A6186D},1,10,C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\mscorlib.tlb COMMSIGENLib,COMMSIGen 1.0 Type Library,{29894293-C0FE-11D1-8D87-0060088F38C8},1,0,C:\WINDOWS\system32\catsrvut.dll\5 COMPATUILib,CompatUI 1.0 Type Library,{233A5627-7755-4B36-AA00-656B8846F501},1,0,C:\WINDOWS\System32\compatui.dll COMReplLib,ComPlus 1.0 Catalog Replication Type Library,{98315905-7BE5-11D2-ADC1-00A02463D6E7},1,0,C:\WINDOWS\System32\comrepl.dll C1AwkLib,ComponentOne C1Awk Control 8.0,{E7F57B23-8EC4-4B47-A3F2-06800D054C07},1,0,C:\WINDOWS\System32\c1awk.ocx DocToHelp,ComponentOne Doc-To-Help Object Library,{DB105D54-FDAB-4501-AB19-937AEC0B33F3},6,0,C:\Program Files\ComponentOne\DocToHelp7\C1D2H70.exe SHGLib,ComponentOne Doc-To-Help Structured Hypergraphics Support Type Library,{A1765334-06C6-43B4-AAE1-8A1978345EB0},1,0,C:\Program Files\ComponentOne\DocToHelp7\C1D2HSHG.dll C1Query80,ComponentOne Query Control 8.0,{605925BE-4799-4093-A2E7-39323147E70E},1,0,C:\WINDOWS\System32\C1Query8.OCX C1SizerLib,ComponentOne Sizer/Tab Controls 8.0,{0AFE7BE0-11B7-4A3E-978D-D4501E9A57FE},1,0,C:\WINDOWS\System32\c1sizer.ocx VSSPELL8Lib,ComponentOne Spell 8.0 Control,{CDF1175F-8D7D-431B-8B61-069CB3A80DD6},1,0,C:\WINDOWS\System32\Spell8.ocx VSTHES8Lib,ComponentOne Thesaurus 8.0 Control,{05BD37E5-B82F-49E6-9A0A-97BE4815460C},1,0,C:\WINDOWS\System32\Thes8.ocx TrueData80,ComponentOne True DataControl 8.0,{7FEC7313-D161-427C-A141-48E17931414B},1,0,C:\WINDOWS\System32\truedc8.ocx TrueDataLite80,ComponentOne True DataControl Lite 8.0,{E8E54757-DFC9-473C-98B3-15D72AB7870B},1,0,C:\WINDOWS\System32\tdcl8.ocx TDBCalendar6,ComponentOne True DBCalendar 8.0,{82392BA0-C18D-11D2-B0EA-00A024695830},1,0,C:\WINDOWS\System32\ticaldr8.ocx TDBContainer3D6,ComponentOne True DBContainer3D 8.0,{1ABFD380-C196-11D2-B0EA-00A024695830},1,0,C:\WINDOWS\System32\ticon3d8.ocx TDBDate6,ComponentOne True DBDate 8.0,{A49CE0E0-C0F9-11D2-B0EA-00A024695830},1,0,C:\WINDOWS\System32\tidate8.ocx TDBDTCalcX6Lib,ComponentOne True DBDateCalcX 8.0,{D882F580-CB02-11D2-8C57-00104BF202C9},1,0,C:\WINDOWS\System32\ticalcx8.dll TDBDateX6Lib,ComponentOne True DBDateX 8.0,{E46EF520-FAFA-11D1-AF40-006097476B29},1,0,C:\WINDOWS\System32\tidatex8.dll TDBFinancialX6Lib,ComponentOne True DBFinancialX 8.0,{BA7F2921-CB00-11D2-8C57-00104BF202C9},1,0,C:\WINDOWS\System32\tifincx8.dll TDBHolidayX6Lib,ComponentOne True DBHolidayX 8.0,{A3519A67-CAF8-11D2-8C57-00104BF202C9},1,0,C:\WINDOWS\System32\tiholyx8.dll TDBMask6,ComponentOne True DBMask 8.0,{66A90C01-346D-11D2-9BC0-00A024695830},1,0,C:\WINDOWS\System32\timask8.ocx TDBNumber6,ComponentOne True DBNumber 8.0,{49CBFCC0-1337-11D2-9BBF-00A024695830},1,0,C:\WINDOWS\System32\tinumb8.ocx TDBNumLite6,ComponentOne True DBNumber Lite 8.0,{9A326101-2FD8-11D2-9BC0-00A024695830},1,0,C:\WINDOWS\System32\tinumbl8.ocx TDBText6,ComponentOne True DBText 8.0,{E2D000D0-2DA1-11D2-B358-00104B59D73D},1,0,C:\WINDOWS\System32\titext8.ocx TDBTime6,ComponentOne True DBTime 8.0,{66A5AC41-25A9-11D2-9BBF-00A024695830},1,0,C:\WINDOWS\System32\titime8.ocx TDBTZoneX6Lib,ComponentOne True DBZoneX 8.0,{6F2B3E84-FD49-11D1-AF40-006097476B29},1,0,C:\WINDOWS\System32\tizonex8.dll VSDraw8Lib,ComponentOne VSDraw 8.0 Control,{D3F92121-EFAA-4B5C-B91B-3D6A8FFD1477},1,0,C:\WINDOWS\System32\vsdraw8.ocx VSFlex8DAO,ComponentOne VSFlexGrid 8.0 (DAO/RDO),{FAD0952A-804F-4061-84BA-88D0F2AA07A8},1,0,C:\Program Files\ComponentOne Studio\VS FlexGridPro 8.0\bin\vsflex8d.ocx VSFlex8L,ComponentOne VSFlexGrid 8.0 (Light),{1C0489F8-9EFD-423D-887A-315387F18C8F},1,0,C:\WINDOWS\system32\vsflex8l.ocx VSFlex8N,ComponentOne VSFlexGrid 8.0 (Light/Unicode),{9DB12C0E-8736-49E6-9CA1-896A1E67D6F3},1,0,C:\Program Files\ComponentOne Studio\VS FlexGridPro 8.0\bin\vsflex8n.ocx VSFlex8,ComponentOne VSFlexGrid 8.0 (OLEDB),{BEEECC20-4D5F-4F8B-BFDC-5D9B6FBDE09D},1,0,C:\WINDOWS\system32\vsflex8.ocx VSFlex8U,ComponentOne VSFlexGrid 8.0 (OLEDB/Unicode),{C115893A-A3BF-43AF-B28D-69DB846077F3},1,0,C:\Program Files\ComponentOne Studio\VS FlexGridPro 8.0\bin\vsflex8u.ocx VSStr8Lib,ComponentOne VSFlexString 8.0,{1C81E0B1-BFC2-42C4-A910-97E0FA9F83C9},1,0,C:\Program Files\ComponentOne Studio\VS FlexGridPro 8.0\bin\vsstr8.ocx VSPDF8Lib,ComponentOne VSPDF 8.0 Control,{1BCC7098-34C1-4749-B1A3-6C109878B38F},1,0,C:\WINDOWS\System32\vspdf8.ocx VSPrinter8Lib,ComponentOne VSPrinter 8.0 Control,{54850C51-14EA-4470-A5E4-8C5DB32DC853},1,0,C:\WINDOWS\System32\vsprint8.ocx VSReport8Lib,ComponentOne VSReport 8.0 Control,{C8CF160E-7278-4354-8071-850013B36892},1,0,C:\WINDOWS\System32\vsrpt8.ocx VSViewPort8Lib,ComponentOne VSViewPort 8.0 Control,{96548BD2-D0BF-46B1-B519-8F2268D49306},1,0,C:\WINDOWS\System32\vsvport8.ocx XArrayDBObject,ComponentOne XArrayDB 8.0 Object,{C10EF3FA-DEBF-4189-8859-C35CA400BBA8},8,0,C:\WINDOWS\System32\xadb8.ocx
Article ID: W16627
File Created: 2005:02:18:12:21:40
Last Updated: 2005:02:18:12:21:40