VBA : . -, . !
, Ctrl+J . : , , ActiveX ( ), _, .
, , -, , .. , . -, , , , .. Variant, , . , -, , , . , VBA .
VBA : . . , VBA ( Ctrl+J) .
Object. (), , . , . , , .
, . , , . : GreateObject, , , , . Object, GreateObject Watch . Object.
, , , . Tools References .dll,.ocx .. , Word- Excel-, Microsoft Excel 12.0 Object Library. !
|
|
, , . . . , , FileSystemObject Microsoft Scripting Runtime.
, , . , (. ).
Dim ob as Object, wb as Object Set ob=CreateObject(Excel.Application) Set wb=ob.Workbooks.Open(ras.xsl) | Dim ob as Excel.Application, wb as Excel.Workbook Set ob=CreateObject(Excel.Application) Set wb=ob.Workbooks.Open(ras.xsl) |
(ActiveX )
, ActiveX . VBA , Tools Additional Controls. , . , . MSDN.