I pasted here ETA-GC explanation of how to use the attached macro (I modified it a little bit for 485 cases):
"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. I485Scan - the macro has a shortcut Ctrl+q).
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-485 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"
"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. I485Scan - the macro has a shortcut Ctrl+q).
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-485 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"
