If then

spotsphill · Post by **spotsphill** » Tue Dec 16, 2008 7:38 am

I was wondering how I would have to code the task if I wanted the following:Step 1: I open an Excel spreadsheet (I know how to do that)Step 2: If cell A1 is blank, then Alt+F4Essentially, what I want to do is skip the spreadsheet document if it is blank.How do I set up Step 2? Is it using if/then? Please help. Thanks!- Phill

Post by **Oleg** » Wed Dec 17, 2008 2:05 am

For example you may get the content of cell A1 into the clipboard and analyze the clipboard content

spotsphill · Post by **spotsphill** » Sun Dec 21, 2008 6:55 pm

Ok, so if I copy the contents of the cell, how do I
analyze it?

I want to delete the Excel file if it contains a blank
A1 field.

Help! Thanks

Post by **Oleg** » Mon Dec 22, 2008 1:25 am

how do I analyze it?

For example you may compare it with something.
In your case you have to trim EOL symbols (see "STR Trim") and compare with empty string.

[qute]I want to delete the Excel file if it contains a blank A1 field.
[/quote]
First you must close the file