| Byg Software |
011 |
| How can I create, and work on, an Excel object using VBA> | |
Dim oXL as Excel.Application
With oXL
.Workbooks.Open "c:\Myworkbook.xls"
'' Other calculations here.
.Workbooks(.ActiveWorkbook.Name).Save
.Workbooks(.ActiveWorkbook.Name).Close
End With
Set oXL = Nothing
|
|
| Close | |