What is this all about ?
This excel program checks the status of a range of SRC numbers using the USCIS online status check facility and store the 485
numbers in the excelsheet for future checks of status changes.
The credit of first writing this ingenious VB/excel
macro goes to OFF_PATIENCE
And then other fellow forum members have modifed it since.
Individual Scan results have then been consolidated and stored in 1 common file - all_cons.xls.
Please see the summary sheet to understand it.
How to Scan?
These are Instructions to run the macro for the 1st Time to scan a New SRC Range
1> Download the attached Excel file.
2> Inform here which date you are going to scan and make sure that you are not doing the scan for same date some one else is doing or has not done.
3> Before you run the macro check the security level of your Excel
file.
Security Level tab is found at (Tools menu, Macro
submenu, Security command).
The level cannot be at High, it should be changed to Medium
or Low.
Now you are ready to run the macro.
4> To run the macro you have to go to the menu at the top of the
screen and look for Tools,
then look for the submenu Macro and then Macros.
It will pop up a box titled Macro.
You can see 4 Macros listed (I485Scan, MakeChart, MultiScan & Sort485).
Select I485Scan and hit the Run button at the right.
Another box will pop up titled Excel.
There, you have to enter the first five digits corresponding to
the SRC range you want to check.
for eg - 01-001 and press OK.
Another box will pup up and enter the range of the last five
digits to check.
Start from 50000 to 51000 and go all the way to 56000.
Note - at a time, you can only scan for 1000 cases from the
same IP address before
'We are sorry' message. After that you have to change
your IP or wait for 24 hours
before you can scan again.
Important Note - When you try to scan more than
3 invalid SRCs, you get blocked as well.
So be wise in choosing the right range of SRC numbers.
5> The usual range starts from 50001-55999. Don't exceed 1000 at a time for a single IP address.
6> The macro will run and will show the results found.
It will create a excel sheet with SRC and write down only the
485 cases.
7> After your 1st run is complete, for next set of 1000 nos,
rename the excel sheet by double clicking on the excel sheet tab.
It will allow you to rename the sheet.
Then repeat step 4>.
After this scan is over combine the 2 results.
Repeat this until you have exhausted finding the date range
or you feel exhausted..
9> You can use proxy servers if you would like to scan more on the same day. You can get some proxies for free if you search internet eg:-
www.atomintersoft.com
To change proxy open internet explorer or other browser. Goto Menu
Tools..Internet options...Connections...Lan Settings...click Use proxy and then enter Ip address and port info say ok and repeat from step 4.
And don't forget to post your results here or add to the consolidated file.
Note - Please feel free to suggest any changes
This excel program checks the status of a range of SRC numbers using the USCIS online status check facility and store the 485
numbers in the excelsheet for future checks of status changes.
The credit of first writing this ingenious VB/excel
macro goes to OFF_PATIENCE
And then other fellow forum members have modifed it since.
Individual Scan results have then been consolidated and stored in 1 common file - all_cons.xls.
Please see the summary sheet to understand it.
How to Scan?
These are Instructions to run the macro for the 1st Time to scan a New SRC Range
1> Download the attached Excel file.
2> Inform here which date you are going to scan and make sure that you are not doing the scan for same date some one else is doing or has not done.
3> Before you run the macro check the security level of your Excel
file.
Security Level tab is found at (Tools menu, Macro
submenu, Security command).
The level cannot be at High, it should be changed to Medium
or Low.
Now you are ready to run the macro.
4> To run the macro you have to go to the menu at the top of the
screen and look for Tools,
then look for the submenu Macro and then Macros.
It will pop up a box titled Macro.
You can see 4 Macros listed (I485Scan, MakeChart, MultiScan & Sort485).
Select I485Scan and hit the Run button at the right.
Another box will pop up titled Excel.
There, you have to enter the first five digits corresponding to
the SRC range you want to check.
for eg - 01-001 and press OK.
Another box will pup up and enter the range of the last five
digits to check.
Start from 50000 to 51000 and go all the way to 56000.
Note - at a time, you can only scan for 1000 cases from the
same IP address before
'We are sorry' message. After that you have to change
your IP or wait for 24 hours
before you can scan again.
Important Note - When you try to scan more than
3 invalid SRCs, you get blocked as well.
So be wise in choosing the right range of SRC numbers.
5> The usual range starts from 50001-55999. Don't exceed 1000 at a time for a single IP address.
6> The macro will run and will show the results found.
It will create a excel sheet with SRC and write down only the
485 cases.
7> After your 1st run is complete, for next set of 1000 nos,
rename the excel sheet by double clicking on the excel sheet tab.
It will allow you to rename the sheet.
Then repeat step 4>.
After this scan is over combine the 2 results.
Repeat this until you have exhausted finding the date range
or you feel exhausted..
9> You can use proxy servers if you would like to scan more on the same day. You can get some proxies for free if you search internet eg:-
www.atomintersoft.com
To change proxy open internet explorer or other browser. Goto Menu
Tools..Internet options...Connections...Lan Settings...click Use proxy and then enter Ip address and port info say ok and repeat from step 4.
And don't forget to post your results here or add to the consolidated file.
Note - Please feel free to suggest any changes
Last edited by a moderator:
