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...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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))