How do you get the cell value from Visual FoxPro? It should be possible to get the value through Automation. In this case, it shouldn't matter whether the spreadsheet is saved or not.

>I have made the programme for stock broking company and its price are directly connected to foreign-exchange server through router in the open excel sheet
>rates are refreshed in 2-3 seconds and on the other hand they open my vfp programme where all the client list and other data is stored and when the transaction is being done they just click on my programme save button and my programme get the excel sheet current cell value from A1 cell and stored into a database along with the other details and at the end of the day they make account for the same.
>
>Now if the excel sheet is opened and refreshing data every 2-3 seconds but not saved every time we can't get the A1 cell value proper because vfp programme only get the value which first time at the time of last saved but not the flashed on screen so we need to save first and then click on the save button.
>
>That is the problem so i put the oworkbook.save() command but it could not work.
>
>otherwise they are working with first click on save button in the excel sheet and then click on vfp programme save button.
>
>But i wanted to do it from vfp so that there is no need to save from excel sheet and vfp save button.
>
>Thanks in Advance