Paul - I'm guessing you are using a newer version of Excel. You could mock something up in excel itself and then do the same with automation and compare the two files (or at least the cells of interest) and see if something stands out.
One thought and it is really clutching at straws - do you deselect everything before saving the file ? -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Paul Newton Sent: Friday, 13 September 2013 11:26 PM To: [email protected] Subject: RE: Strange Excel behaviour Nope that doesn't work either ... -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Stephen Russell Sent: 13 September 2013 14:22 To: [email protected] Subject: Re: Strange Excel behaviour On Fri, Sep 13, 2013 at 8:08 AM, Paul Newton <[email protected]>wrote: > Thanks for the suggestion but it makes no difference > > ------------------- > Maybe this instead? \r\n When I have to put in new lines in Notepad ++ that is what I do. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
