>I have used the following code from "Microsoft Office Automation with Visual Foxpro" by Tamar Granor but I can't it to work
>
>

>loTempWorkBook = CREATEOBJECT("Excel.Application")
>loTempWorkBook.Workbooks.Open("C:\Dev\Questback\Data\Invicta\Repairs(REP)\"+DTOS(DATE()-1)+"RSLSummary.xls")
>loTempWorkBook.Visible = .T.
>loMTWorkBook = CREATEOBJECT("Excel.Application")
>loMTWorkBook.Workbooks.Open("C:\Dev\Questback\Data\Invicta\Repairs(REP)\"+DTOS(DATE()-1)+"RepairURL.xls")
>loMTWorkBook.Visible = .T.
>
>loTempWorkBook.Worksheets(1).Move(loMTWorkBook.ActiveSheet)    && Error on this line
>
>loMTWorkBook.SaveAs = ("C:\Dev\Questback\Data\Invicta\Repairs(REP)\"+DTOS(DATE()-1)+"RepairURL.xls")
>RELEASE loTempWorkBook
>

>
>
>Error Message:
>
>OLE IDespatch exception code 0 from Microsoft Office Excel:
>Unable to get the move property of the Worksheet class
>
>Is there something missing in the move syntax? Can any one help? Is there another way to do this?

Tony,
That doesn't look like correct syntax to me for a move operation and I believe the problem lies in the fact that you are creating 2 excel sessions.

Would you try this:

LOCAL loX,loTempWorkBook,loMTWorkBook, lcXLS1,lcXLS2
lcXLS1 = "C:\Dev\Questback\Data\Invicta\Repairs(REP)\"+DTOS(DATE()-1)+"RSLSummary.xls"
lcXLS2 = "C:\Dev\Questback\Data\Invicta\Repairs(REP)\"+DTOS(DATE()-1)+"RepairURL.xls"

loX = CREATEOBJECT("Excel.Application")
loTempWorkBook = loX.Workbooks.Open(m.lcXLS1)
loMTWorkBook   = loX.Workbooks.Open(m.lcXLS2)
loX.Visible = .T.
loTempWorkBook.Worksheets(1).Move(loMTWorkBook.ActiveSheet)

Cetin