Check
http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspxHi Sergey:
The novel the author of that function wrote was very intertaining. After having a look at the code I became dizzy.
I imagine a high qualified client and a high qualified programmer together and performing such a great solution.
I think about my very low qualified client and a much very low qualified programmer as me together trying to decide what ask for lunch.
I must say the first attempt was discouraging. A window opened and ask me about the obdc file although one moment ago I had downloaded it from Microsoft. "I'm not going to tell Nicky to do this..." I thought but I wanted to see where this finish.
Finally using the alternate connection the author suggested a process was made and I got a solution.
The question is: Did it work because I use MS Office 2010? Would it work if my client has Excel 2003?
I almost forgot it. The article referred to a download for Office 2007 and after I downloaded it it didn't work. Then I tried with another download 2010 and I could work.
Anyway the table obtained has a strange character french accented "a" I'll have to find out what it is and delete it.
I think this time I will do everything. But it's good to know this possibility exists. I wonder: Every new product of Microsoft, every solution on line for great brains. How many articles do you have to read and how many functions you have to write for not keeping back in the time? Do you have time for living?
I thank you very much, the data was very good and fast.
Héctor