VBA to write cells out to a file

[tmb]

I want to...

open new file
check cell data (If data="xyz" then goto close file or whatever)
write cell data
write a string
move to next cell
check cell data (If data="xyz" then goto close file or whatever)
write cell data
write a string
etc
close file

can anyone give me sample code snippit to...
- create/open a file
- check cell data
- branch on results
- write cell data
- write a string
- close file

thanks for any help

 

[Debra Dalgleish]

You can use the macro recorder to create some of this code as you
perform the steps manually. Then, edit the generated code.

If you get stuck, post another question, with detail about the layout of
your workbook, the code you have created.