using .scr files in autocad from excel vba

Use the Quit method to end the AutoCAD session. This means that all the methods and properties for the Application object are available in the global name space. The application object is also the Global object for the ActiveX interface. For example, you would change CreateObject('AutoCAD.Application') to CreateObject('AutoCAD.Application.20'). If a CreateObject or GetObject function uses a version-independent ProgID, change the function to use a version-dependent ProgID. Now, I need the Excel VBA solution for launching (drag and drop) XYZ.scr to AutoCAD (to create drawing).

Saved XYZ.scr in the same folder as that of Excel file (ABC.xlsx). See the Microsoft Visual Basic 6 documentation for the Running Object Table (ROT) and the GetObject function (for more information about verifying the session returned by GetObject). I have developed an AutoCAD script file (XYZ.scr) from Excel file (ABC.xlsx) using VBA Macro. When running multiple sessions of AutoCAD, the GetObject function will return the first instance of AutoCAD in the Windows Running Object Table. The first step would be to add reference to the Google Earth 1.0 Type Library. Note: The google earth API will only be available if you have Google Earth installed on your computer. If AutoCAD is running, the GetObject function will retrieve the current AutoCAD Application object. This article explains how you can use VBA for Excel to open a KML File. To access the Application object from VB, use the Visual Basic 6 functions GetObject or CreateObject. To access the Application object from VBA, use Thisdrawing.Application. The active document (AutoCAD drawing) can be accessed with the ActiveDocument property. The methods control the loading or listing of the currently loaded external applications and interface objects.

The properties that are associated with the Application object reflect the properties of the main application window.

Using .scr files in autocad from excel vba