MS Query - Case Statements, Excel Data file

hi,

Yes, Case statements can work in Excel's VBA code but the syntax differs - check out the examples in http://www.ozgrid.com/VBA/select-case.htm
However, I think you could achieve the same thing without resorting to code... highlight the cells in the author column & apply Conditional Formatting [alt + O + D], select "cell value is" & "not equal to" & type "me" in the dropdown, then click on Format & choose a colour.

hmmm...
The more I look at your post alongside its title, the more I think I've misunderstood & given a poor answer above, so I'll try again...

You may find something of use at the below links but I hope with this "bump" that someone more knowledgeable will be able to give you a definitive answer.
http://help.lockergnome.com/office/M...ict754381.html (see pbbellri's last post)

http://www.advanced-excel.com/import_data.html

hth
Rob