> I'm trying to create a function with FM Pro 4.1 where a user can click a
> button on a screen causing a group of five fields to be copied into the
> clipboard, and then switch to Excel to paste the values into horizontally
> consecutive cells. I've created a calculated field that contains the
> concatenated text of the five fields, separated by the "paragraph" mark. I
> also created a button with a script that puts the contents of this field
> into the clipboard. When the user goes to Excel and selects a cell, the
> five values copy to vertically adjacent cells, not horizontally, even though
> I've set the Excel prefs to "move right" with the Return key.
> So I'm thinking if I could separate the data with a TAB key instead of the
> paragraph mark, that might do the trick. So far I can't figure out how to
> do that. Can it be done?
> By the way, my workaround in Excel is to create a macro that places the data
> vertically off to the side of the spreadsheet, and then does a Copy - Paste
> Special - Transpose to the desired cell. It works, but it does have some
> undesireable side effects - like using cells way off to the side, which
> causes the spreadsheet to scroll right when the macro is activated.