We have a standard excel template which needs to be populated with data. The data is held in a number of foxpro tables. Therefore what I would like is for the user to click a macro within the excel document which will invoke my foxpro application. From this it will prompt the user for a particular record when they click ok the data will be imported onto a new sheet in the original excel document. From here I then use this data on my excel sheet.
Does anybody know how best to do this. The foxpro side is pretty easy its the invoking the excel exectuable and importing the data within a new sheet that I am unfamliar with. Any help would be really appreciated
Many Thanks
Neil Lewis
IT R&D Manager
Velmore Ltd