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

--
Jak
-----------------------------------------------------------------------
Jako's Profile: http://www.excelforum.com/member.php...nfo&userid=871
View this thread: http://www.excelforum.com/showthread.php?threadid=27169

Hi
as a starting point:
http://www.xldynamic.com/source/xld.Deleting.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Jako" schrieb im Newsbeitrag
...

Please can someone suggest a way to do the followin.

I want to check for the existence of a workbook in a directory
"C:\Audit".

If the workbook(Name not specific) exists i then want to check each
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"
i
then want to delete the entire row.

Obviously there will be a non specific number of rows and will vary
each time, on each sheet.

Having deleted the rows as mentioned i then want to save the workbook
to a folder "C:\Audit\Final".

I would also like the workbook filename to have the date (format
"dd-mm-yy") as part of it.
eg.
"22.10.04 Audits.xls"

Many thanks for any help.


--
Jako
---------------------------------------------------------------------
---
Jako's Profile:
http://www.excelforum.com/member.php...fo&userid=8710
View this thread:
http://www.excelforum.com/showthread...hreadid=271697