>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?
AFAIK, no.
>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).