Unfortunately a script will work properly. On the "Pastespec" menu you should use "Paste Link" and you either have to press the radio button manually or press "Alt+L".
However you can accomplish this with VBA in excel with ease!
Open excel, Press "Alt+F11" to open VBA.
Insert > Module
Paste this code:
Sub sbACAD()
Dim objAutoCAD As Object
On Error Resume Next
Set objAutoCAD = GetObject(, "AutoCAD.Application")
On Error GoTo 0
If objAutoCAD Is Nothing Then
Application.CutCopyMode = False
MsgBox "AutoCAD is not running", vbOKOnly, "Error"
Cells(3, 5).Select
Else: AppActivate "AutoCAD"
objAutoCAD.WindowState = 3
SendKeys ("pastespec")
SendKeys "{ENTER}"
Application.Wait Now + TimeValue("00:00:01")
SendKeys ("%(L)")
SendKeys "{DOWN}"
SendKeys "{ENTER}"
End If
End Sub
You can even have the table placed automatically with this: Make sure to change the coordinates to what you want.
Application.Wait Now + TimeValue("00:00:12")
SendKeys ("13.767{TAB}21.044")
SendKeys "{ENTER}"I inserted a wait time because for me Datalinks are a bit slow.
Once you save the macro press "Alt+F8" to open the macro window.
Dont forget to highlight your cells and press "Ctrl+C" before running the macro!!!
