GitHub

atman-33/excel-db-tool-vba

対象のExcelを開いた状態でExportを実行すること（Excelを閉じたままExportするとExcelが壊れて開けなくなる可能性有り） XlsWxgから提供されているOracleのデータ取得Excelを改造しました。 改造内容 ...
GitHub

ole-db-for-olap-properties-used-by-excel.md

OLE DB for OLAP properties used by Excel Microsoft Excel uses an OLE DB for OLAP (OnLine Analytical Processing) provider to connect to OLAP cubes. When connecting to an OLAP cube, Excel reads and sets ...
Investopedia

Visual Basic for Applications (VBA): Definition, Uses, and Examples

Will Kenton is an expert on the economy and investing laws and regulations. He previously held senior editorial roles at Investopedia and Kapitall Wire and holds a MA in Economics from The New School ...
Ars Technica

Access DB crashing while VBA code runs (w/ODBC connection)

I've inherited support of a DB to help out with our bank recon processing.<BR><BR>This DB was originally an access 2000 DB (I believe). It has a Titan ODBC connection with a table on our MS SQL 2000 ...