easy vba question

[anhn]

Make it clearer, you should write:

If (CurrentTitle = "DOM" Or CurrentTitle = "USA") And (HeaderNum = "2") Then

From VBA (in Access, Excel or Word, ...) you cannot create EXE but you can compile the code from menu [Debug]>[Compile VBA Project].