>>Hi everybody,
>>
>>I got this email from my former boss:
>>
>>I did some more testing and here is the interesting point.
>>
>>If I take the program xlsxfile and run it from the command window I get the correct results. If I make the routine a project and call it from my main program it returns the first column label in all the fields.
>>
>>There must be some setting that is causing the routines not to retrieve the correct values in the individual cells.
>>
>>I suspect it may be 'SET EXACT and SET ANSI' settings, but I think there is a way to get all these settings somehow saved, but I just don't remember how.
>>
>>Do you know how to get all the settings from IDE vs. run-time?
>>
>>Thanks in advance.
>
>Going just a step further from the Help file (but I'll be really embarrassed if there is a simpler solution...):
>
>

>LOCAL regfile, oReg
>LOCAL ARRAY aFoxOptions[1,2]
>LOCAL Option
>
>m.regfile = HOME(2)+"classes\registry.prg"
>SET PROCEDURE TO (m.regfile) ADDITIVE
>m.oReg = CreateObject("FoxReg")
>m.nErrNum = m.oReg.EnumFoxOptions(@m.aFoxOptions) 
>
>SET ALTERNATE TO "Settings.txt"
>SET ALTERNATE ON
>
>FOR m.Option = 1 TO ALEN(m.aFoxOptions, 1)
>	? m.aFoxOptions[m.Option, 1],"=",m.aFoxOptions[m.Option, 2]
>ENDFOR
>
>SET ALTERNATE OFF
>SET ALTERNATE TO
>
>MODIFY FILE Settings.txt
>

Somewhat relatedly, ISTR there is/was a keyboard combination that would dump all these values into either a Debugger window or the Command window (?) Anyone recall what that was? I thought I might have seen a post from Tore Bleken about that but I can't find it.