PDA

View Full Version : OLE object



cmason.82472
2005-08-04, 07:44 PM
I am trying to insert an Excel spreadsheet into Acad '04 Electrical.
The max size it will insert is. 16x50, and my spreadsheet is around 20x140.

I was able to connect to it useing dbconnect, but I don't know how to display it or plot it.
Any help, I would be grateful.
thanks

Mike.Perry
2005-08-04, 08:09 PM
Hi

For starters take a look at the information contained within the following couple of threads found in the AutoCAD FAQ (http://forums.augi.com/forumdisplay.php?f=189) forum -

OLE (eg Excel) Objects within drawing file not Plotting correctly (http://forums.augi.com/showthread.php?t=16799)

Working with OLE (eg Excel) Objects within a drawing file (http://forums.augi.com/showthread.php?t=16801)

Have a good one, Mike

cmason.82472
2005-08-05, 12:55 PM
I don't think OLE objects are going to work for what I need to do, unless I do some piecing together. I was able however, to set up my spreadsheet as an ODBC and bring it in using db connect. I was wondering if it is possible to display that in my drawing. And plot a large spreadsheet all at once.

RobertB
2005-08-05, 04:44 PM
What version of Excel? You need to be running Excel XP or 2003, along with Win2k or WinXP, in order to get large OLE areas from Excel.

cmason.82472
2005-08-05, 05:43 PM
What version of Excel? You need to be running Excel XP or 2003, along with Win2k or WinXP, in order to get large OLE areas from Excel.
Excel 2000 with windows 2000

RobertB
2005-08-05, 09:17 PM
Excel 2000 with windows 2000
You are out of luck. Tell your boss you need an upgrade.