Status Scanner tool ?

[gc4health]

Is there any tool to track the list of EAC numbers from an XLS file instead of giving the RANGE ???

I think scanning with range is redundent, if you already have the list

-- Thanks

 

[m78768]

Good question.. I have the same question and looking for answer.. Could someone please help?

 

[Jharkhandi]

I think people have attached the Excel file many times. Run 'Macro 140 scan' in it. Provide your date/range. Just bear this point in mind range >500 gives errors.

 

[m78768]

Originally posted by Jharkhandi
I think people have attached the Excel file many times. Run 'Macro 140 scan' in it. Provide your date/range. Just bear this point in mind range >500 gives errors.

Thanks but you didnt understand the question... We know that we can scan the number ranges, but the question is how to scan the list of EAC numbers instead of scanning number ranges.

 

[Jharkhandi]

You will have to get the macro code and modify it to suit your need. (Create array instead of using range.).

 

[I140_2003]

The macro already does it. When scanned the first time it creates a worksheet with the name of yy-ddd with all the I140 cases.

The next time you want to scan do not delete that worksheet, just run the macro again - it will scan only the case numbers in the worksheet that are not approved.

In case, you are using a different one, here's the one I am using.

 

[hmd]

Updated the xls to work with new website

DON't ABUSE IT

Jharkhandi is right modify it the way you want it. Hey you got all the subs and the structure . To edit press Alt+ F8 and then click on Edit