No, but I haven't searched very hard for a solution.

I think your best bet is to add extra intelligence to the spreadsheet.
 Make a "Paste new record" button which examines the contents of the
windows clipboard (cut and paste functionality), removes the extra new
lines, and then imports the record itself.  This VBA macro shouldn't
be overly difficult to make, even for an excel beginner.  You could
simplify it by having it examine the clipboard, remove all new lines,
and put the data back into the clipboard so you don't have to
manipulate the spreadsheet at all (3-5 lines of code).  Just tell
users to press it before pasting the data, and it'll take care of the
problem.

Users can copy the data from the email, and most may be able to paste
it directly in, but those that have issues can use the special button
for it.

This is the simple version (no pasting - it just removes new lines
from the clipboard):

Sub test()
    Dim DataObj As New DataObject
    Dim clipBoardText As String
    DataObj.GetFromClipboard
    clipBoardText = DataObj.GetText

    clipBoardText = Replace(clipBoardText, vbCrLf, "")
    clipBoardText = Replace(clipBoardText, vbCr, "")
    clipBoardText = Replace(clipBoardText, vbLf, "")

    DataObj.SetText clipBoardText
    DataObj.PutInClipboard
End Sub

You'll need to open the visual basic editor (Tools --> Macro -->
Visual Basic editor) then right click on the VBAProject on the left,
and add a userform (blank, you won't use it, but it ensures you have
the necessary references to use the clipboard), and then add a module.
 Double click on new module Module1 and paste:

Sub FormatClipboard()
    Dim DataObj As New DataObject
    Dim clipBoardText As String
    DataObj.GetFromClipboard
    clipBoardText = DataObj.GetText

    clipBoardText = Replace(clipBoardText, vbCrLf, "")
    clipBoardText = Replace(clipBoardText, vbCr, "")
    clipBoardText = Replace(clipBoardText, vbLf, "")

    DataObj.SetText clipBoardText
    DataObj.PutInClipboard
End Sub

You can add a button to the spreadsheet to execute this function by
displaying the Control Toolbax toolbar, adding a button to the
spreadsheet, double click it to go to the code it'll execute, and add
the function name to it:

Private Sub CommandButton1_Click()
    FormatClipboard
End Sub

Now you can close the Visual basic editor, and click the upper left
icon in the control toolbox toolbar to exit design mode.

The button is clickable, and when clicked will remove all carraige
returns and, line feeds from the text in the clipboard.

-Adam

On Mon, Jul 27, 2009 at 11:41 AM, Harold
Hallikainen<harold@hallikainen.org> wrote:
> Genuinely off topic, but I know there are some experts here!
>
> I've got an application where a simple database is kept using Excel. I
> have a web form where people enter data that will then be added to the
> Excel spreadsheet as another row. This is basic data. Additional columns
> are filled in by the person keeping track of the data. I COULD do
> something with MySql, but right now stuff is manually entered in Excel, so
> I thought I'd build upon that.
>
> I currently have a script that emails the form data as a pipe delimited
> string. This can then be imported in to a row in Excel. It's not
> super-elegant, but it seems to work so far. One problem, however, is line
> wraps in the email. It appears the wrap is done on the receive end.
> SquirrelMail wraps the lines when displaying the email, but when I
> download the mail, the wrap is not there. So, depending on the user's
> email client, it may or may not be possible to just copy and paste out of
> the email.
>
> Does anyone know of a better way to send an email of data that can just be
> copied and pasted in to an Excel row? Maybe XML or something?
>
> THANKS!
>
> Harold
>
>
> --
> FCC Rules Updated Daily at http://www.hallikainen.com - Advertising
> opportunities available!
>
>
>
> --
> http://www.piclist.com PIC/SX FAQ & list archive
> View/change your membership options at
> http://mailman.mit.edu/mailman/listinfo/piclist
>
-- 
http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist