dasarihp_newid
Registered Users (C)
I have an excel file which runs the required macro for scanning I-140's from BCIS website. It opens a browser and runs the query on the website like you do manually.. It then prints the results for the range of cases that is provided..
open the excel,
press Alt-F8 ,
it will ask for which case day, you can give something like, 03-256, press ok
it will ask for which case # range, give something like 50000-52000.. press ok..
The macro will kick of, opens a browser and runs the scan for that day's case range you have given.. You will see live as the cases gets added to the excel.
Once you have the cases, the next time you run on the same day's cases, it will only run on the cases that are listed in the excel, so it won't run on 2000 cases, and will run only on probably 50 I-140 cases in your excel, and will be pretty fast..
the first time you run it will take long time(depending on the range).//
THERE IS BIG WARNING FOR YOU GUYS IF YOU WANT TO RUN YOURSELF, IF THERE ARE MORE THAN 5-10 I-140 CASES IN YOUR RANGE WHICH ARE NOT THERE IN THE BCIS SYSTEM, or IF YOU SCAN MORE THAN 1000 CASES, THEN YOUR IP ADDRESS WILL BE BANNED FOR 24 HOURS. YOU WILL HAVE TO WAIT FOR ONE DAY TO CONTINUE..
/////
The credit for this excel goes to kashmir, kenboo, etc..
http://boards.immigrationportal.com/showthread.php?s=&threadid=88822&highlight=scan
I modified the code to include, LIN #'s instead of WAC #'s//
FOR MORE INFO YOU CAN GO TO THAT FORUM..
I am attaching the excel below in the 4 th reply in this thread.. If you guys want to run your own scans, you can do so, and add your range to the master SCAN excel !! ..
Let me know if you have any questions.. !!
==================
open the excel,
press Alt-F8 ,
it will ask for which case day, you can give something like, 03-256, press ok
it will ask for which case # range, give something like 50000-52000.. press ok..
The macro will kick of, opens a browser and runs the scan for that day's case range you have given.. You will see live as the cases gets added to the excel.
Once you have the cases, the next time you run on the same day's cases, it will only run on the cases that are listed in the excel, so it won't run on 2000 cases, and will run only on probably 50 I-140 cases in your excel, and will be pretty fast..
the first time you run it will take long time(depending on the range).//
THERE IS BIG WARNING FOR YOU GUYS IF YOU WANT TO RUN YOURSELF, IF THERE ARE MORE THAN 5-10 I-140 CASES IN YOUR RANGE WHICH ARE NOT THERE IN THE BCIS SYSTEM, or IF YOU SCAN MORE THAN 1000 CASES, THEN YOUR IP ADDRESS WILL BE BANNED FOR 24 HOURS. YOU WILL HAVE TO WAIT FOR ONE DAY TO CONTINUE..
/////
The credit for this excel goes to kashmir, kenboo, etc..
http://boards.immigrationportal.com/showthread.php?s=&threadid=88822&highlight=scan
I modified the code to include, LIN #'s instead of WAC #'s//
FOR MORE INFO YOU CAN GO TO THAT FORUM..
I am attaching the excel below in the 4 th reply in this thread.. If you guys want to run your own scans, you can do so, and add your range to the master SCAN excel !! ..
Let me know if you have any questions.. !!
==================
Last edited by a moderator: