My company has an ActiveX application used by more than 50000 customers paying customers. The data people need to input into the ActiveX application is coming from Excel (actually csv or XLS files, which they open in Excel). What we would like to do is to create functionality where the customer can input "=" in a textbox in the ActiveX component, then click on a cell in an Excel sheet. Our ActiveX textbox should then automatically show something like: ='[c:\export.csv]rawdata'!$A$3
In this way our VB6 application would be integrated with their files in a way that is transparent to the customer. Is this possible?