Wilson WindowWare Tech Support

WinBatch WinBatch+Compiler WebBatch
Home | Tech Database | Tech BBS | White Papers | Purchase


Cutting and Pasting a Cell in Excel

Keywords:   Cutting and Pasting Cells Excel Range

Question:

I was just wondering how to do this. Is it possible w/o looping?

I know how to copy and paste a cell using, e.g.,

zCells1=EAS.Cells(2, 1)
zCells1.Value = "NAME: %cfile%"
but how about a whole chunk at once!?

Answer:

Try something like:
 
ObjXL= ObjectOpen( "Excel.Application" )
ObjXL.Range("A1:D4") 

Article ID:   W14690
Filename:   Cutting and Pasting a Cell in Excel.txt