J
Jako
Please can someone suggest a way to do the followin.
I want to check for the existence of a workbook in a director
"C:\Audit".
If the workbook(Name not specific) exists i then want to check eac
worksheet for the occurence of the string "Green" or "Red" or "Yellow"
If Column F contains any of the strings "Green" or "Red" or "Yellow"
then want to delete the entire row.
Obviously there will be a non specific number of rows and will var
each time, on each sheet.
Having deleted the rows as mentioned i then want to save the workboo
to a folder "C:\Audit\Final".
I would also like the workbook filename to have the date (forma
"dd-mm-yy") as part of it.
eg.
"22.10.04 Audits.xls"
Many thanks for any help
I want to check for the existence of a workbook in a director
"C:\Audit".
If the workbook(Name not specific) exists i then want to check eac
worksheet for the occurence of the string "Green" or "Red" or "Yellow"
If Column F contains any of the strings "Green" or "Red" or "Yellow"
then want to delete the entire row.
Obviously there will be a non specific number of rows and will var
each time, on each sheet.
Having deleted the rows as mentioned i then want to save the workboo
to a folder "C:\Audit\Final".
I would also like the workbook filename to have the date (forma
"dd-mm-yy") as part of it.
eg.
"22.10.04 Audits.xls"
Many thanks for any help