A simple Excel VB Macro preprocessor to help with the conversion of recorded Excel macro's to a format usable from VFP. Nothing fancy, it just does some of the common repetitive tasks. Note: The form was developed in VFP 6.0 but should run ok in 5.0.

• Detects the "SUB" and "END SUB", Comments them out and encompasses the VB Script code using WITH and ENDWITH.
• Replaces VB Script's "End With" using VFP's "ENDWITH"
• Adds #DEFINE's for True, False
• Adds #INCLUDE for the "Excelcon.h" file

• Start by recording your Excel macro(s).
• From Excel open your macro file in Edit mode and copy the macro(s) you wish to convert. Be sure to include the "SUB" and "END SUB" lines of each macro you copy. If you do not include these lines the preprocessor will do nothing!
• From VFP run the form, select the edit box and paste the code.
• Press the process button and your done.
• From here you may cut and paste the code to your VFP procedure or save the code to a file.

DISCLAIMER: This software is PUBLIC DOMAIN. Software provided by author "AS IS" without any kind of warranties. The author of this software will not take responsibility for any damage that may result from the use of this software.
Excel® and Visual Foxpro® are registered trademarks of the Microsoft Corporation.

Application by: Mike McLain
Release: 1.00  -  05/18/1999