...
>

>#define xlNormal -4143
>
>oExcel.WorkBooks.Open([...........]) && I didn't use WorkBooks collection in my previuos code.
>oExcel.ActiveWorkBook.SaveAs([Test.XLS],xlNormal)
>

>
>To get all Excel (Word) predefined constants you could use:
>Open Object Browser
>Open XL5EN32.OLB (Program Files\MS Office\Office11\XL5EN32.OLB)
>Open Constant Node of the TreeView
>Open Empty file and Drag & Drop Constant node in it.

These paths don't exist on my PC (VFP7?) I found refs to VB and Excel, got the treeview, and constants, found the approp. constant (e.g. xlNormal or xl97.... etc) but can get no numeric value - they just exist in the tree - don't understand the point of it. Then VFP crashed!

Furthermore, when I went back to the MSDN page where I'd stored the constants as a favourite, I found it was all now in German! I searched again but could not find the same constant definitions as last week.

>
>Other way is to put:
>MsgBox xlNormal
>
>in Macro Editor and run it :-)

With this I get:
Compile error: invalid outside procedure (and help is just blank)

I've had a very frustrating afternoon!!! :-S