Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to remove column in Excel file
Message
 
To
21/10/2005 02:48:07
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6 SP3
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01060993
Message ID:
01061012
Views:
11
>Hi everyone
>
>I want to know the command to remove column in EXCEL
>
#DEFINE xlShiftDown -4121
#DEFINE xlShiftToLeft -4159
#DEFINE xlShiftToRight -4161
#DEFINE xlShiftUp -4162

*** >Q.A to remove column "D"
oExcel = CREATEOBJECT("Excel.Application")
oExcel.Visible = .t.
oBook = oExcel.WorkBooks.Open("d:\Book1.xls")
oBook.ActiveSheet.Columns("D:D").Select
oExcel.Selection.Delete(xlShiftToLeft)

*** >Q.B to remove column "X" TO "AB"
*** In this case from Column C to Column AB
oBook.ActiveSheet.Columns("C:AB").Select
oExcel.Selection.Delete(xlShiftToLeft)
oExcel.Quit()
oExcel = NULL
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform