|
急求 ,网上找到的代码,但是我装的Office里面没有这个.dll,谁有,麻烦上传!
First, we will embed the Microsoft Data Analyzer ActiveX control into a UserForm in Excel 2002 and manipulate it with VBA code. To do so, on a computer with Data Analyzer installed:
Start Excel 2002 and create a new, blank workbook.
On the Tools menu, point to Macro, and then click Visual Basic Editor to switch to the Visual Basic Editor (VBE).
On the Insert menu, click UserForm.
In the Properties window for the UserForm, replace the text in the Name property with frmControl and the text in the Caption property with Microsoft Data Analyzer ActiveX control—Sample.
In the Toolbox (View menu), right-click, and click Additional Controls.
In the Additional Controls dialog box, check the Max3Ax Class box, and then click OK.
Finally, drag the Max3ax Class control onto the frmControl form. |
|