01-05-2024
08:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
01-05-2024
08:23 AM
And sometimes this strategy can work better for when you need to start a new instance of the Excel application, but I do not use this one that much. Below is a very simple example rule, just for testing, to see if it will work for you, without any errors.
AddReference "Microsoft.Office.Interop.Excel.dll"
Imports Microsoft.Office.Interop
Imports Microsoft.Office.Interop.Excel
Dim oExcel As New Microsoft.Office.Interop.Excel.ApplicationClass
oExcel.Visible = True
oExcel.DisplayAlerts = False
MsgBox("Notice that a 'New' instance of Excel just opened." & _
vbCrLf & "And when you close this message, that instance of Excel will be closed.", _
vbInformation, "iLogic")
oExcel.Quit
oExcel = Nothing
Wesley Crihfield
(Not an Autodesk Employee)