• 技術情報
• Path & Date on the layout via Excel and OLE

This document applies to PlotMaker 2.3 (ArchiCAD 7.0).

To do this, you need to have an Excel XLS file in the folder where your layouts are being stored. This layout will have all Layout names listed in one column. This is the most difficult part of it, but if you do your Titleblocks in Excel, then it's a rather simple method. You can even set up a macro for creating a new titleblock on a new sheet for every new layout name that you enter. So type all the layout names you'll have in this project to form a list in column B (e.g. B1: electricalGF.lay; B2: Demo1Story.lay, etc.)

Save your Excel sheet to the folder where your project's layouts are saved!

Now in the first column (column A) type

=INFO("directory")

this will display the Path of the Excel sheet, and as the sheet is in the same place as your layouts, the path will be the same.

In the third column (column C), type:

=CONCATENATE(B1,A1)

This cell will then have the name of your actual layout and the path merged together in one row.

In the fourth column (column D), type

=TODAY()

Now use Excel's drag function feature to have the path amended to each layout's name.

You can then paste the appropriate cells as a linked object into your appropriate layout [it might be better to paste the date on its own if it's not in one row with your filename]. If you move the project, and the Excel sheet is moved with it, you'll have an auto-updating path displayed on the layout. [Of course you'll have to update the hotlinks to find the Excel sheet from PlotMaker]

So, once you set up your project template, this will work. It's even better if you make a macro in Excel for your Titleblocks, that'll speed things up even more...

Note: theOLE functions are only available in PlotMaker 2.3

Note: OLE is not available on OS X yet. "More...".

• カテゴリレイアウト