AutoCAD LT General Discussion

AutoCAD LT General Discussion

Reply
Active Member
SolarCadTech
Posts: 8
Registered: ‎05-05-2011
Message 1 of 3 (283 Views)

OLE object (Excel sheet) to report ?

283 Views, 2 Replies
06-22-2011 07:38 AM
after i insert an excel sheet into a drawing and fill it with the relevant data, can i somehow export that into another excel sheet as a report ? in other words, is there a way to link what i type into an ole object into an independent MS Excel sheet ? of course i'm looking for a streamlined method to do this, so the data entry is only done once. thanks!

autocadLT2011
i7-M620@2.67GHz
8GB ram
64bit
*Expert Elite*
pendean
Posts: 22,907
Registered: ‎11-06-2003
Message 2 of 3 (273 Views)

Re: OLE object (Excel sheet) to report ?

06-22-2011 11:39 AM in reply to: SolarCadTech

"insert an excel sheet" how exactly did you do this?

Dean Saadallah Blog | Facebook | Google+ | Twitter | PINS
Active Member
SolarCadTech
Posts: 8
Registered: ‎05-05-2011
Message 3 of 3 (270 Views)

Re: OLE object (Excel sheet) to report ?

06-22-2011 11:45 AM in reply to: pendean

"insert" as in ole object..

however, i found a way around it (or a reverse way around it).

 

i use a "chart" which is data-linked to a specific excel sheet.

i enter the data into 'that' excel sheet and update the chart in acad.

that way i get my excel reports, and autocad drawing done with one data-entry menouver.

cheers!


autocadLT2011
i7-M620@2.67GHz
8GB ram
64bit
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.