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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Manipulation
Are you opposed to opening the file via code, deleting the "Paid" rows, then
closing the file in the same procedure? This would take less time than you could see it happen. "Jay" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Manipulation
You will not be able to delete rows without opening the file.
"Jay" wrote: 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 |
Reply |
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 |