aks999 said:
can someone please point me to the place where the tracking tool is?? I will try to run from my machine. Appreciate, if you can also write few lines on how to use it.
Thanks,
aks
Sorry I missed this earlier. Here's the "raw" scan macro (attached).
Make sure you have macros enabled in Excel. Under Tools->Macro->Macros select the macro you want to run (e.g. I140Scan).
Click Run.
Enter yy-ddd to scan. Note that the year starts on Oct. 1 and that ddd only seems to include working days (more or less). The date comes from the Notice Date (ND) for the cases.
So, to scan for cases with a ND of 10/01/03, I've been using 04-001. For 10/23/03 (my own ND), I'd use 04-016 (not 04-023 since ddd is the number of work days).
Now you'll be asked for the case # range. These usually seem to be in 50000 - 54000 or thereabouts. Don't specify more than about 250 cases -- after this you will be locked out for your IP (or perhaps your entire company / ISP IP) for some period of time).
If there are "hits" (e.g. an I-140 case is found), the results will be pasted into the spreadsheet. This should show the case EAC#, it's status and last updated date.
Afaik, there's no easy way to find all cases for a given day apart from the way I've been doing it (probe all case #'s from 50000 through 54000 in groups of 250).
Note, if you run the scan and then run it again for the same yy-ddd (or save the results from a search and load the scan again, it won't ask for a range -- it will use the EAC #'s which are already present from the previous scan.
This is good if you want to repeat a scan for previously found cases.
Otherwise, you can delete the sheet (right click on the tab at the bottom and delete it) and the scan will be done anew.
ETA