Breaking the 1.000 scan limit

E

eb2_I485_RD0901

Registered Users (C)
Hello All,

Recently I have been trying to find some novel ways of overcoming the 1,000 scan limit.

BCIS says that they record the IP etc to protect their servers; what I have discovered is that they do not record the "exact" IP but also some kind of "subnet". Some members have mentioned that when they use dial up and disconnect & reconnect they get a new IP ; I am not sure if this works because the new IP will probably be from the same subnet. ( If anybody can please verify this , let us know ) ..of course if the new IP is from a different subnet then it will work.

Another way that I have tried is using the "Free " Proxy server on the internet.
Most proxy servers on the internet do not allow to do the HTTPS for free , after some research I found www.proxyweb.net site which allows you to do the "secure" HTTPS for free. This has worked wonderfully !! now the only problem is to get the "MACRO" to do this.


check out the site: www.proxyweb.net

Can anybody help in modifying the marco
 
Originally posted by eb2_I485_RD0901
Hello All,

Recently I have been trying to find some novel ways of overcoming the 1,000 scan limit.

BCIS says that they record the IP etc to protect their servers; what I have discovered is that they do not record the "exact" IP but also some kind of "subnet". Some members have mentioned that when they use dial up and disconnect & reconnect they get a new IP ; I am not sure if this works because the new IP will probably be from the same subnet. ( If anybody can please verify this , let us know ) ..of course if the new IP is from a different subnet then it will work.

Another way that I have tried is using the "Free " Proxy server on the internet.
Most proxy servers on the internet do not allow to do the HTTPS for free , after some research I found www.proxyweb.net site which allows you to do the "secure" HTTPS for free. This has worked wonderfully !! now the only problem is to get the "MACRO" to do this.


check out the site: www.proxyweb.net

Can anybody help in modifying the marco
Click to expand...

eb2_I485_RD0901 , I have done this many many times.
You don't have to change macro but change your internet settings after each 1000 hits.
http://atomintersoft.com/products/alive-proxy/proxy-list/?ap=1

i don't know if you could change your Macro to change your internet settings though.

but i believe instead if all os us we split & share the effort we could achieve more.
 
eb2_I485_RD0901 , were you able to use the scanning using proxy server Ip?
let me know if you still need help.
In the meantime, it occurred to me that instead we can change the macro to scan multiple sheets instead of just 1 sheets.
 
The Proxy worked

Hi goastros,

The proxy worked , but I like your suggestion of modifying the MACRO to do multiple sheets . Since we are modifying the MACRO here are a few things we can do to improve it:

1. Scan multiple sheets.
2. Skip "Transferred" cases as well (thier status never changes)
3. include a counter to count 1000 cases scanned.
4. At the end of the scan display the "last scanned" sheet along with the case number (or row number ) ..(this will help determine the last scanned case )

Anybody has any comments please add to this thread.

Any MACRO expert want to help ??

This week is tight for me . I can work on it next week.
 
valid points

i have some

in summary sheet

1. Show # of pending cases instead of Total cases (or keep this column too)
2. some sheets have very few entries. probably these were not scanned originally for all entries(50000-59999). It'd be nice if macro can record range of SRC# used during scanning of that page. This will help others, to add more ranges later

In indiv. sheets
3. Delete all Approved cases that had been approved during 2002. Isn't the purpose of this, to track the current progress ?
 
Re: The Proxy worked

Originally posted by eb2_I485_RD0901
Hi goastros,

The proxy worked , but I like your suggestion of modifying the MACRO to do multiple sheets . Since we are modifying the MACRO here are a few things we can do to improve it:

1. Scan multiple sheets.
2. Skip "Transferred" cases as well (thier status never changes)
3. include a counter to count 1000 cases scanned.
4. At the end of the scan display the "last scanned" sheet along with the case number (or row number ) ..(this will help determine the last scanned case )

Anybody has any comments please add to this thread.

Any MACRO expert want to help ??

This week is tight for me . I can work on it next week.
Click to expand...

Pradha has done it , pretty cool changes to the macro.
You can download the latest zip file and run it and see the changes. The macro can now scan multiple sheets and while doing so he turns off all the Updates to the Summary Sheet.

tx140, Agreed that the approved cases from 2002 don't have anything to do with the current progress but if you delete them, you would get a incorrect results for a particular SRC.
for eg - if you delete approved cases for say SRC01-271, you might get the approval % for this SRC lot different.
In my opinion there are not harming anything then why delete it.
 
You must log in or register to reply here.
Top