Oldest Cases in this forum

Aloshy, here is the macro

I have attached the excel file which contains the macro.
Download it on your computer and click on Tools, Macro.
Choose I485Scan macro.
It will ask for your SRC number and then the range.
Give a range of 100-200 numbers around your SRC.
It will get the online status and record only the 485 cases in the new Excel sheet it creates.
After it finishes, you may want to run Makechart so it gives you a summary & chart and then you can let us all know your findings.
You might want to increase the sample of numbers from 100-200 to more.
On the next run if you use the modifiedscan, it will just scan the numbers listed on the excel sheet.
if you give too many invalid nos or you try to scan for 1000, it will give " too many requests" message.
Don't worry, just wait for 24 hours and try again.
 
Ran script but dissppointing

I ran the script for range of 500 and saw this result.
The two Received status is mine and my wifes. Everything else has some updates.

SRC02065XXXXX Received
SRC0206551155 Insufficient payment
SRC0206551188 Mailed directly
SRC0206551222 Resumed
SRC0206551243 Mailed directly
SRC0206551280 Card ordered
SRC0206551322 Card ordered
SRC0206551352 Approved
SRC02065XXXXX Received
 
Top