topic Re: Without OLE in AC10, is there a good solution... in Documentation

Without OLE in AC10, is there a good solution...

MMontgomery — Fri, 07 Feb 2025 14:38:35 GMT

... for embedding Word docs and Excel files into our layouts?

I've created an extensive set of notes and schedules in both Excel and Word for use in Plotmaker, which, sadly, are now all defunct.

What is the best approach to circumventing the problem?

Re: Without OLE in AC10, is there a good solution...

TomWaltz — Fri, 07 Jul 2006 20:03:49 GMT

MMontgomery wrote:
... for embedding Word docs and Excel files into our layouts?

I've created an extensive set of notes and schedules in both Excel and Word for use in Plotmaker, which, sadly, are now all defunct.

What is the best approach to circumventing the problem?

Print to PDF then link the PDFs onto your Layouts.

Re: Without OLE in AC10, is there a good solution...

MMontgomery — Fri, 07 Jul 2006 20:43:28 GMT

Thank you for the response.

I've been doing it this way but was hoping there was a better method that didn't require creating more files. Also, being able to open the OLE object directly from plotmaker was very handy.

Re: Without OLE in AC10, is there a good solution...

Scott Bulmer — Fri, 07 Jul 2006 21:14:59 GMT

You can open the Word or Excel document, select & copy text, then in AC Text; double click to open text writing area then paste. The only item I could not get to paste was the grid/cells from Excel.
I think that should work.
S

Re: Without OLE in AC10, is there a good solution...

Anonymous — Fri, 21 Jul 2006 22:09:03 GMT

With Pre AC10 Projects I wold have a Live OLE link to Engineering Spreadsheet information. I came to expect this easy and live link to the Engineering data. Well know I have to create a "non-live" PDF file and link this.

I just traded in my HP DesignJet plotter and analog black line (large format copier) for a used OCE 9400 toner based printer/plotter. I am told that this OCE only supports TIFF images and not PDF. AM I to worry now that the PDF information will not be printed/plotted?

Re: Without OLE in AC10, is there a good solution...

Anonymous — Tue, 25 Jul 2006 04:30:17 GMT

I also miss the OLE functions, but mainly the ones for excel. Any reason why the PDF import couldn't've co-existed with OLE?

Re: Without OLE in AC10, is there a good solution...

Anonymous — Tue, 25 Jul 2006 15:55:02 GMT

I do not know much about API and Add-ons, but could a Add-on for the OLE (I am on a PC) be created for AC10. I would purchase it in a heartbeat.

Re: Without OLE in AC10, is there a good solution...

Link — Tue, 25 Jul 2006 23:14:23 GMT

From what I understand this wasn't a decision Graphisoft made, but a decision that was made for Graphisoft. Other beta tester could probably provide a better insight, but I was under the impression that Microsoft is either not supporting OLE anymore, or that they are not supporting it for GS's intentions.

I could be wrong....

Cheers,
Link.

Re: Without OLE in AC10, is there a good solution...

Anonymous — Wed, 26 Jul 2006 18:24:08 GMT

Link wrote:
...I was under the impression that Microsoft is either not supporting OLE anymore, or that they are not supporting it for GS's intentions.

I could be wrong....

Cheers,
Link.

For What it is worth, I am still using MS Excel 97 (Office 97), which also is not supported my MS (to which I do not care). I checked out a trial version of Office 2003 and Excel 2003, and it did not seem worth it to upgrade. And as far as OLE not be "stable" I have have zero problems with OLE to PM9.

Re: Without OLE in AC10, is there a good solution...

vfrontiers — Mon, 14 Aug 2006 18:32:50 GMT

I have also noticed that embedded PDF's do NOT PLOT! only print... This bites for trying to send your blueprinter plot files...

Also, be careful that your DRAWINGS have the little TRANSPARENT check box checked or your plots will come out as a black rectangle.

Writing PDF files for the blueprinter was an option, but some fonts (such as the ones I am using, do not get embedded....

Re: Without OLE in AC10, is there a good solution...

Anonymous — Mon, 14 Aug 2006 21:24:57 GMT

vfrontiers wrote:
Writing PDF files for the blueprinter was an option, but some fonts (such as the ones I am using, do not get embedded....

I had this problem also. The font was "MrHand".

Also, when Printing/Plotting PDF's the Scaling was not accurate.

Re: Without OLE in AC10, is there a good solution...

Anonymous — Tue, 15 Aug 2006 14:00:54 GMT

Try to use Adobe Distiller.

Re: Without OLE in AC10, is there a good solution...

Anonymous — Tue, 15 Aug 2006 20:00:45 GMT

Archi wrote:
Try to use Adobe Distiller.

Is this Distiller mentioned in the Graphisoft manual or can I find out about it at ArchicadWiki?

Re: Without OLE in AC10, is there a good solution...

Anonymous — Tue, 15 Aug 2006 20:05:29 GMT

Found this article, but seems not to help.

Re: Without OLE in AC10, is there a good solution...

Anonymous — Tue, 15 Aug 2006 21:15:24 GMT

@Jay

I have mentioned hier. It was my experiance with PDF file from AC.

http://archicad-talk.graphisoft.com/viewtopic.php?t=11672

I have feeling, suddenly PDF is now the most important file for AC 10.
I ask, is it good solution?
Many users have in a moment trouble with PDF from AC 10.
As you mentioned, we need nice official manual with this matter- eps, OLE...... now just one file PDF!

Re: Without OLE in AC10, is there a good solution...

Anonymous — Tue, 15 Aug 2006 21:19:13 GMT

I have absolutly no trouble with PDF instead of OLE.
It is actually very sure way to organise with PDF.
But I think, everybody needs Accrobat Professional in order to save data in PDF with Excel or Word.
Than it is no problem.

The actuall problem is with EPS.

Re: Without OLE in AC10, is there a good solution...

vfrontiers — Tue, 15 Aug 2006 23:01:09 GMT

Yes... I just worked a couple of days with a spreadsheet for Lateral Analysis and went to pdf it onto a layout... Oddly, AC10 could not read the file that AMYUNI made... ugh.

Re: Without OLE in AC10, is there a good solution...

Haneef Tayob — Sat, 19 Aug 2006 10:19:23 GMT

My main issue without OLE is that when I need to export my file to another editable format such as dxf.
Pdf's are exported as raster images, whereas the OLE spreadsheet in v9 was conveniently converted to vector elements.
Although we've lost the live link, you can still paste from a spreadsheet and convert to archicad elements and then resize to suit the layout if you don't want to use the pdf option. I find that lines pasted from the spreadsheet are often missing and text is not aligned as you had intended it to.