Re: Exporting records

[Bob Duncan <duncanr@xxxxxxxxxx>]

At 09:21 AM 10/09/2003 -0500, Elizabeth Thomsen wrote:
>We're happy to finally have the ability to export records from a review 
>file to our PCs.  This works fine to get delimited files for importing 
>into Access, Excel, etc., although we do wish that we could set our own 
>defaults in Settings.
>
>What I'm trying to figure out now, however, is how to save a file in the 
>simplest possible format, with each field starting on a new line and a 
>blank line between records.  I can use Control Character 13 to get the 
>return at the end of each field, but is there any way to get a blank line 
>between records?


If you're exporting to Excel 2000/2002, this macro will do the trick once 
there:

         <http://support.microsoft.com/default.aspx?scid=kb;[LN];213318>

(Microsoft Knowledgebase article # 213318.)

Bob Duncan


~!~!~!~!~!~!~!~!~!~!~!~!~
Robert E. Duncan
Systems Librarian
David Bishop Skillman Library
Lafayette College
Easton, PA  18042
duncanr@xxxxxxxxxx
http://www.library.lafayette.edu/