Copy and paste OLE

[Daryl]

I want to be able to copy a table layout as an OLE object and paste it into a CAD application. It appears I can do that from layout view but the table is converted to an image object and not editable in the CAD application. Is it possible to copy a table view as an OLE object and paste it as an editable object. This would be similar to copying a range of spreadsheet cells and pasting them into the CAD drawing.

Thanks,

Daryl

[Lee Smith]

Hi Daryl

If I'm understanding you correctly, you are going to say Duh on this one. All you need to do is go to the layout you want to copy and Choose copy (Cmd C on a Mac) [color:"red"] do not select any fields.

This should copy all of the information within all of the fields on the layout.

HTH

Lee

[Lee Smith]

[color:"blue"] P. S. In Browse Mode

[Daryl]

Thanks Lee, but in browse mode, only the record that is current is copied. I want the whole table with the column titles and all the found records. I can get it to work from layout view but then the full page is pasted as an image and not just the table. Also, it is an image and not an editable table within the CAD file. I can make this work fine in excel.

Does this make any more sence?

Daryl

[Lee Smith]

To copy the found set, Use the script step "Copy All Records"

Lee

[Daryl]

Thanks Lee for trying. Your suggestion does paste all the records but they are not formated in a table like they are in FM. I was hoping there was a way to select the table and copy it like I can in Excel. I suppose the next best thing is to export to Excel and select the table there. I now that works.

Thanks again,

Daryl

[BobWeaver]

The format depends on how you have your fields arranged in the layout you are copying. It should copy them as a table if the fields are arranged correctly.

[Lee Smith]

Hi Darel,

That's funny, it works for me (no labels of course), but the field contents are pasted into Excel just as it appears in FM.

I use this script step in one solution all of the time. It's attached to a list view. I just tried this in a new solution and chose the Table View and it too worked like a charm too.

Lee

[Daryl]

Lee, I can get the data in a table ok, it just doesn't have the grid lines of a table nor the field titles. I want it all so that it looks just like the table itself. I can make it work by accepting the copy as a metafile graphic but the graphic includes the whole page and not just the table portion.

I'm a home builder and I use filemaker to store all the information about each window in the house. I then want to build a table schedule that can be pasted into my paper layouts in my CAD program for reference on a blueprint.

I could do this in my old database application very cleanly by copying the view which contained everything.

Daryl

[Lee Smith]

Hi Daryl,

I think that as far as getting it done in native FileMaker goes, my thoughts have pretty much explained your options

One thing I know little about is if there is a plugin that can do this, as I I don't use plugins, so I don't know much about them. You might check for the text editing plugins and see any of them will do it.

AFAIK the only way to get the Field Names out of FileMaker is by using the "Merge" export. In any event, the formatting of the table is not exportable.

Sorry,

Lee