I recently had a project that included converting bazillions of rows from flat text files to Notes Documents. Given the high volume of repetitive junk like 'Dim xyz as String' and 'doc.Firstname = FIRSTNAME'... I began using Microsoft Excel to compose code then copy and pasted to the Designer IDE. Using Excel formula language to concatenate strings together and then "Autofilling" the formulas down a column saved me hours of tedious writing and clicking...
Here's a simple example: In an Excel spreadsheet list Variable in Column A and field names from Notes forms in Column B.
Column A FIRSTNAME LASTNAME etc... Column B FirstName LastName etc. Now in column C, create a simple formula like this: ' ="Dim "&A1&" as String" ' Autofill this formula down the column to create all of your lines" Dim FIRSTNAME as String Dim LASTNAME as String A formula in column D: ' ="doc."&a1&" = "&B1 ' will Autofill down to give you these: doc.FirstName = FIRSTNAME doc.LastName = LASTNAME Copy and paste these columns to the Designer IDE. Very easy and very effective! I now use this trick all the time... Most often to propogate lines that use multiple string handling functions like this: VARIABLENAME = Trim(Mid$(VARx(250,15))
This was first published in July 2002