Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete row in Excel 2002 worksheet
In VFP 7, my application can perform the following command correctly using
Excel 2000, but not in Excel 2002: goExcel = CREATEOBJECT("Excel.Application") WITH goExcel .Workbooks.Open(lcXlsName) .Rows("5:5").Delete ENDWITH If I record this task in an Excel Macro and edit it using the Macro Editor, I get the following: .Rows("5:5").Select .Selection.Delete Shift:=PxlUp .Range("A5").Select If I add <spaceShift:=PxlUp after the Delete command, the compiler returns a syntax error. How can I run Excel commands in VFP 7 like this? What is the correct syntax for it? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Can I delete tabs at one go ? | Excel Discussion (Misc queries) | |||
Excel 2002 sp3 Worksheet Password | Excel Discussion (Misc queries) | |||
Excel 2002 Worksheet: Can I sort the columns ? | Excel Discussion (Misc queries) | |||
Excel 2002 worksheet | Excel Worksheet Functions | |||
I cannot delete rows or columns in Excel 2002. How do I fix this? | Setting up and Configuration of Excel |