Hello Naomi,
thank you very much for your answer. You are right of course. I forgot to “EXTERNAL” the array. After adding EXTERNAL it works like expected.
You made my day or better to say you made my week!
Best
Gerhard
>>Hello,
>>
>>I export a VFP table to XLSX using VFPXWorkBookXLSX.SavetabletoworkbookEx.
>>
>>That works really good. But when I try to use an array for the field titles in the first row I get an error
>>
>>=> "File 'tafields.prg' does not exist."
>>
>>in line 59 of SavetabletoworkbookEx.
>>
>>Can someone please help with that problem?
>>
>>TIA
>>Gerhard Schmidbauer
>
>
>Hi Gerhard,
>
>You need to have external array command for this (to exclude compile error). I made some modifications in that program a while ago when I was incorporating it into our application. I think I made this change and also added a list of columns to exclude. I did communicate a bit with the developer but I don't know where exactly we stand and if he added these changes in his version or not.
>
>If you want send me your email in PM and I'll email you the version I have.
>
>UPDATE. I think I used the save from Excel to VFP table program, as this is what I needed. Boris was the person who introduced me to that program some time ago - many thanks to him for that and to the author.
Gerhard Schmidbauer
URANUS Software GmbH