在VBS或VBA中读写EXCEL文件,只需要在代码中添加下面的语句即可实现: Dim App, Book, Sheet Set App = CreateObject("excel.application") '创建excel进程,VBS中为:Set App = Wscript.CreateObject("excel.application") Set Book = App.workbooks.Open("D:\Users\123.xlsx") '打开指定路径的文件 Set Sheet = Book.Shee...
利用VBA对CATIA进行二次开发,第一步就是要获取CATIA的应用程序对象(Application Object)。如果是在VBA内部,直接用GetObject函数即可,CATIA Automation 对象的类名为CATIA.Application,代码如下所示:Function GetCATIA() As Object Dim CATIA As Object Set CATIA = GetObject(, "CATIA.Application") If CATIA Is N...