>...
>>
>>#define xlNormal -4143
>>
>>oExcel.WorkBooks.Open([...........])
>>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
The whole routine must looks like:
Sub BlaBla()
MsgBox xlNormal
End Sub
:-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.