OLE object

cmason.82472 · 2005-08-04, 09: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, 10:09 PM

Hi

For starters take a look at the information contained within the following couple of threads found in the AutoCAD FAQ forum -

OLE (eg Excel) Objects within drawing file not Plotting correctly

Working with OLE (eg Excel) Objects within a drawing file

Have a good one, Mike

cmason.82472 · 2005-08-05, 02: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, 06: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, 07:43 PM

Quote:

Originally Posted by RobertB

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, 11:17 PM

Quote:

Originally Posted by cmason.82472

Excel 2000 with windows 2000

You are out of luck. Tell your boss you need an upgrade.

2005-08-04, 09:44 PM	#1
cmason.82472 Member Join Date: 2005-02 Posts: 26	OLE object 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 __________________ Chris

2005-08-04, 10:09 PM	#2
Mike.Perry Administrator Join Date: 2001-03 Location: Fenton, MO via the UK Posts: 13,500	RE: OLE object Hi For starters take a look at the information contained within the following couple of threads found in the AutoCAD FAQ forum - OLE (eg Excel) Objects within drawing file not Plotting correctly Working with OLE (eg Excel) Objects within a drawing file Have a good one, Mike __________________ ..........MeWhee

2005-08-05, 02:55 PM	#3
cmason.82472 Member Join Date: 2005-02 Posts: 26	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. __________________ Chris

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problems with selecting objects eg. Only able to select 1 object at a time.	Mike.Perry	AutoCAD FAQ (Read only)	0	2005-07-09 01:27 AM
Select last object selection.	bskripac	AutoCAD General	4	2005-02-10 03:22 PM
reference an object's definition to another object property definition?	JBACHMAN	ACA General	0	2005-02-09 10:08 PM
Quality Drawings; Object Styles, View Temp's & Vis Overr	jacob chavez	Revit Architecture - General	3	2004-12-10 07:23 AM
Dockable Interface, Object Browser, Object handle ideas...	Richard McCarthy	Revit Architecture "Original" Wish List (Archived)	6	2003-10-08 07:49 PM

2005-08-05, 06:44 PM	#4
RobertB Administrator Join Date: 2001-08 Location: Seattle WA US Posts: 4,393	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.