Page 1 of 1
If then
Posted: Tue Dec 16, 2008 7:38 am
by spotsphill
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
If then
Posted: Wed Dec 17, 2008 2:05 am
by Oleg
For example you may get the content of cell A1 into the clipboard and analyze the clipboard content
If then
Posted: Sun Dec 21, 2008 6:55 pm
by spotsphill
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
If then
Posted: Mon Dec 22, 2008 1:25 am
by Oleg
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