Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Manipulation
I have an Excel file named "Customer" in G:\Company folder.
Without opening this file in excel, I want to check it's first column cells values of every rows. I used to use a following module when I directly opend Customer Excel worksheet. How can I achieve the same result without opening Customer Excel sheet directly. Or any better idea? I know very little about file manipulation techniques. Thank you. Sub Paid() x =1 Do while Cell(x,1).Value < " " If Cells(x,1).Value = "Paid" Then Cells.Entirerow.Delete. x=x+1 Loop End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value manipulation | Excel Discussion (Misc queries) | |||
Create txt file with data manipulation and reorganization (macro) | Excel Discussion (Misc queries) | |||
Need Help with Cell Manipulation | Excel Discussion (Misc queries) | |||
Code for Access file manipulation from Excel | Excel Programming | |||
Bit manipulation | Excel Programming |