Hello all,
Trying to copy a sheet within a book.
The excel VBA code for this is :
Sheets("Sheet1").Select
Sheets("Sheet1").Copy Before:=Sheets(1)
the bit I'm struggling to translate to VFP is the:
Before:=Sheets(1)
so can anyone tell me what I should out after:
oexcel.Sheets("Sheet1").Copy
Cheers
Simon
Trying to copy a sheet within a book.
The excel VBA code for this is :
Sheets("Sheet1").Select
Sheets("Sheet1").Copy Before:=Sheets(1)
the bit I'm struggling to translate to VFP is the:
Before:=Sheets(1)
so can anyone tell me what I should out after:
oexcel.Sheets("Sheet1").Copy
Cheers
Simon