>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
MS-Excel uses VBA (Visual Basic for Applications) as a developer's language. Excel is both a COM server and a COM (Automation) client. So's VFP. Therefore you could have a button or other way to trigger in Excel that calls VBA code embedded in the spreadsheet then uses CreateObject() to call a VFP-based EXE (in VFP you compile to COM standards using OlePublic or marking it so in the Project Manager Build dialog).
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry