Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00553231
Message ID:
00554742
Views:
21
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           && works but copy's the formulas
   *.activesheet.pastespecial( xlPasteValues) && this won't work
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform