>I have some code that evidently worked in VFP6 a few years ago, but when copied into VFP9, it will not compile. (I actually wrote the code as a one time fix for a customer, but I've no idea where I got it from, and did the whole thing in a rush with no docs. Now a customer wants it retrofitted into the new version of the system) The code is supposed to bring up Excel and create a graph in a worksheet.
>
>It starts with oExcel=CreateObject("Excel.Application")
>
>the problem code is in this - it does not like ExcelColumn
>

>	with oBook.Sheets[1]
>		IF pType=1
>			SELECT (pWorkarea)
>			GO top
>			for x = 1 to fcount()
>				cCol=ExcelColumn(x)
>				.Range(cCol+"1").Value = FIELD(x)
>			ENDFOR
>

>I stuck in DIMENSION ExcelColumn[99] && Just guessing to make it compile
>
>and it then compiles and runs, but gets some run time error messages and only create the graph frame in Excel
>
>I could do with a link to somewhere where I can figure out what is going on and fix the code.

I think ExcelColumn function could be made based on
Re: How to end a copy on Excel Thread #958704 Message #958988