Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Automation
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00553231
Message ID:
00554742
Vues:
16
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform