Thanks that Worked Fine!!!
I guess I was just blind. :-)
Now I am working with the Paste Portion of the procedure.
I want to just paste the values and not the formulas of the cells
I was trying to use a pasteSpecial but That's not working.
We are trying to copy a range of cells (c1:d42) and copy them to
another group of cells 2 columns over but I don't need the Formulas, I need the
Values. This is what I have
WITH THISFORM.obj_excel
.APPLICATION.workbooks.OPEN( "mystuff")
.worksheets( "page 2").ACTIVATE
.VISIBLE = .T.
.APPLICATION.activesheet.RANGE('c1:d42').SELECT
.SELECTION.COPY
.APPLICATION.RANGE("g1").SELECT
.activesheet.paste
ENDWITH
Question:
How can I paste just the values to the places I want to paste them to?
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide
LeRoy Jackson