Featured post

Fixed Income Trading: New venues

A simple question came up recently in a conversation – how many new Fixed Income trading venues are there?  I could not think of anywhere th...

Monday, 6 April 2015

Excel VBA - industrialisation...Part Thirteen "Enumerating Connections"

Another way to interact with Excel is through WorkbookConnections from external data sources to an Excel Workbook.  If this data is needed for a spreadsheet then clearly these connections must be enumerated for the Excel Industrialisation process.So to enumerate the WorkbookConnections in a workbook follow these steps:
  1. Download the code from github 
  2. Create a new Excel workbook with one worksheet
  3. Save the new workbook as an xlsm format workbook
  4. Enter the VBA editor
  5. Import the module you just downloaded from github
  6. Execute the "EntryPointGetConnections" method and look in the debug window
  7. Add some data connections to the sheet and re-run the "EntryPointGetConnections" method (see below)
See also
Excel industrialisation...Part One "Code to write code"    
Excel industrialisation...Part Two "Export VBA code to file system"
Excel industrialisation...Part Three "What is Excel Industrialisation?"
Excel industrialisation...Part Four "Enumerate Addin references"
Excel industrialisation...Part Five "Integration with Git"
Excel industrialisation...Part Six "Error Handling"
Excel industrialisation...Part Seven "Central Error Reporting"
Excel industrialisation...Part Eight "Enumerating RTD Servers"
Excel industrialisation...Part Nine "Enumerating DDE Servers"  
Excel industrialisation...Part Ten "Enumerating COMAddins"

Excel industrialisation...Part Eleven "Enumerating OLEObjects"
Excel industrialisation...Part Twelve "Enumerating XL4 Macro Sheets"

No comments:

Post a Comment