>The links are referencing other sheets within the workbook. I guess I will need to use the copy() - astespecial() method. Can you assist me with this process?
>
>How did you go about learning all of the Excel automation syntax?
>The book "Microsoft Office Automation with VFP" can be purchase from http://www.hentzenwerke.com

---

FUNCTION _ExcelSavePasteSpecial
LPARAMETERS tcOriginal, tcSaveAs, tcSheet
#DEFINE xlPasteValues  -4163
oExcel = CREATEOBJECT('excel.application')
WITH oExcel
  .WorkBooks.Open(tcOriginal)
  .ActiveWorkbook.WorkSheets(tcSheet).Cells.Select
  .Selection.Copy
  .ActiveWorkbook.Saved = .t.
  .WorkBooks.Add
  .Selection.PasteSpecial(xlPasteValues)
  WITH .ActiveWorkbook.ActiveSheet
    .Name = lcSheet
    .Range("A1").Select
    .SaveAs(tcSaveAs)
  ENDWITH
  .Quit()
ENDWITH

I'm still learning using Excel VBA help file. Whenever I can't determine how to do something I record a macro, copy-paste macro code to VFP and retouch to fit VFP calling scheme. I think these should be covered well enough in the book.
Cetin