VB Script for status check

Could someone pls. work on this........., I changed all the wac entries to eac, but it did not work...... sounded logical, but as I dont have a clue about programming, effort was in vain:(
 
I too don't know much about this scripts. But I think you are right hedgehog... this would be great. With this we would get to know how many 485's approved on any given day. Then we neednot depend
on individual postings of approval or even rupnet!!! as all know some of them don't come back to update ....
It would really great if someone with knowledge on these scripts comes forward to do it ..
Thanks....
 
Here is the Excel sheet. Added buttons to respective macros. Could someone take a look at the VB code, I changed all WAC entries to EAC, but it doesn't work, for reasons mentioned earlier. Could someone pls. correct the code and repost the file.
 
Last edited by a moderator:
in the procedure
Public Sub StartScan()

you have the following condition

If Mid(eacRange, 6, 1) <> "-" Or Err <> 0 Then
MsgBox "Incorrect value"
Exit Sub
End If
SaveSetting "I485", "Settings", "eacRange", eacRange
End If
If MsgBox("Are you sure you want to start scan process?", vbYesNoCancel) = vbYes Then

In the If condition you are checking for "-" and in the eacrange after 50000- it is hypen so it displays the msg and stops. if you take that condition out it works.

I hope this helps. But i did not go thru the whole code to check what it does.

I will once I go thru whole thing
 
GC012002

could you post the corrected file. Did you run a query based on the new file - what results?? could you post that too.......

Thnaks
 
Corrected file

Here is the corrected file. Pls. post your results on this site for all to see.

Thanks

PS: Run at your own risk - do not know if INS logs IP addresses - this may violate some law...........
 
Last edited by a moderator:
it worked

This one worked, suppose you have xml open the file, and click tools |macro |run *.StartScan and then *MakeChart

thanks to the other guys!
 
U guys are free to edit and make changes to make this file more user friendly. I suggest people that run queries post their findings on this site, and should also update Rupnet. That way the INS server will not be over burdened............ and it will help others in tracking their cases.

Njoy..........
 
Guys, u rock

eac0208250007 Resumed 4/18/02 Resumed/FP recvd
eac0208250019 Resumed 6/5/02 Resumed/FP recvd
eac0208250021 Resumed 5/8/02 Resumed/FP recvd
eac0208250023 Resumed 6/26/02 Resumed/FP recvd
eac0208250028 Received 1/10/02 Received
eac0208250036 Resumed 5/17/02 Resumed/FP recvd
eac0208250043 Resumed 5/8/02 Resumed/FP recvd
eac0208250050 Resumed 5/17/02 Resumed/FP recvd
eac0208250061 Received 1/10/02 Received
eac0208250069 Received 1/10/02 Received
eac0208250071 Resumed 5/17/02 Resumed/FP recvd
eac0208250073 Resumed 5/17/02 Resumed/FP recvd
eac0208250091 Received 1/10/02 Received
eac0208250093 Resumed 4/2/02 Resumed/FP recvd
eac0208250094 Received 1/10/02 Received
eac0208250097 Received 1/10/02 Received
eac0208250115 Received 1/10/02 Received
eac0208250120 Resumed 8/30/02 Resumed/FP recvd
eac0208250133 Resumed 8/30/02 Resumed/FP recvd
eac0208250136 Resumed 2/20/02 Resumed/FP recvd
eac0208250147 Resumed 5/17/02 Resumed/FP recvd
eac0208250148 Received 1/10/02 Received
eac0208250156 Resumed 3/15/02 Resumed/FP recvd
eac0208250161 Received 1/10/02 Received
eac0208250171 Resumed 4/2/02 Resumed/FP recvd
eac0208250186 Resumed 7/24/02 Resumed/FP recvd
eac0208250192 Received 1/10/02 Received
eac0208250200 Resumed 5/8/02 Resumed/FP recvd
 
st8

I think your link is a general disclaimer. I am not sure if using the program violates any laws, since you are not getting any information that you couldn't get by entering numbers randomly and manually. However, this is my opinion.

Users use this program at their own risk - U are free not to use it if you so wish.Perhaps Mr. Khanna could comment on the use of this program

Anyhow, once again, use at your own risk. One could use a proxy anonymyzer, if desired.
 
The link is for the whole INS site. As long as no abuse occurs with overloading of the system and errant crashes, it should be OK. If that were to happen and INS considers the checking as an abuse, they would probably come up with an alternative. Maybe case number + name + DOB, etc. Who knows?

$.0175
 
Sorry Folks

I decided to remove the file. It seems from reading other posts that this file may come back to haunt me in the future........ have enough worries and would like to avoid any more.

Anyhow, last count I saw 126 downloads.......... someone else may want to repost the file..... entirely up to them.
 
do't worry about it guys there were plenty of scan which were run on CSC make sure one ppl run it preferably at night .
Look in california thread there r plenty of updates from this. Rest is up to u.
 
hedgehog!

Would it be possible for you to tune the script. Initial scan for a range (which is already present in the file). Following scans to just check/update the status of the entries in the file. This would limit the check to the 485 filings and hence not a big load.
 
STOP

Please refrain from these ventures. This will ot help getting your approvals any sooner. Why are we concerned about what's happening to others cases. The whole purpose of the INS service was to help us stay better informed and need not wait on the phone. Respect their initiative and please do not abuse it.
Respect the fact that you guys are smart and can wite a VB script, however from an INS perspective, you guys would not considered smart but would only prove to be a nuisance. Don't mean to be rude, but this sounds absurd.
 
You must log in or register to reply here.
Top