I need to save some information from an Excel Workbook into a VFP table whenever the excel workbook is closed.

I have created an excel workbook_ beforesave macro, which includes CreateObject("VisualFoxPro.Application"), followed by use of the DoCmd. to open the relevant table, seek the correct record and save the information.

This works fine on any PC's with the development version of VFP loaded but not where only the runtime libraries are present. Is there a way of instantiating a CreateObject reference to the VFP7 runtime library instead of the development version?

I want to keep it simple and avoid creating a separately compiled automation server because of the difficulty of ensuring that it is registered correctly on every PC (there are several hundred of these spread across several sites).