Getting Data from Excel to AutoCad

How do you connect to an open excel spreadsheet.

Thanks in advance

Norman Duke

 

Hi Norman,

Look in the sample files supplied with AutoCAD. There is code for an Excel
Link supplied.

--

Regards,


Laurie Comerford
www.cadapps.com.au

 

Laurie. Thanks for your response. I have tried the samples but they only
refer to an new workbook, and not an existing one.

I have had the sample working. The real question I have is to access the
current open excel workbooks activesheet. Once there I can get the data that
I need.

Norman Duke

 

Norman,

This will check for a running instance of Excel, if not
it will create one. You'll find more in the Connectivity Group.

gl
Paul

'<code>
Sub excelTest()

Dim oExcel As Excel.Application
Dim wasRunning As Boolean

wasRunning = IsExcelRunning

If wasRunning Then
Set oExcel = GetObject(, "Excel.Application.9")
Else
Set oExcel = CreateObject("Excel.Application.9")
oExcel.Visible = True
oExcel.UserControl = True
End If

'grab the active sheet, rip it up!

'close it if you started it.
If Not wasRunning Then
oExcel.Quit
End If

End Sub

Function IsExcelRunning() As Boolean
Dim oExcel As Excel.Application
On Error Resume Next
Set oExcel = GetObject(, "Excel.Application.9")
IsExcelRunning = (Err.Number = 0)
Set oExcel = Nothing
Err.Clear
End Function
'<code/>

 

Thanks Paul
That sent me in the correct direction.

Norman Duke

 

That sent me in the correct direction.
That's a first..;-) Good Luck.

 

Norman,

For a different look you can view my post here..http://discussion.autodesk.com/thread.jspa?threadID=394399

Good luck,

Bob Coward

 

Bob

Thanks for the additional information. There is a lot in there to keep me
busy.

Norman Duke