help with macro - goastros - reply

D

dinnu

Registered Users (C)
goastros,

Yes, I can tweak the macro. I am not sure which version you are using. I have not been to this forum for quite some time (as I got busy with my work) and i kinda lost touch with the updates.

Why don't you post the version you have so that i can tweak it.

Dinnu
 
dinnu Thanks

Here it is , Dinnu.

This is what I wanted to
write the output of each scan also to a text file.
This text file can be overwriten on each run ( no need to save it for next run).
Also the output of each scan can be very basic -
for eg - SRC number, 1st line of the scan.

I leave the macro running unattended for 1000 numbers and sometimes when I come back I get " Sorry invalid numbers" 2-3 times and I get blocked.
I want to know which number range is when I get blocked, so next time I start further down.
Can you please make the change, Dinnu
 
goastros,

If I understand you correctly, all you want to do is find the invalid receipt numbers so that you can ignore those numbers in your next scan.

The simplest thing that came to my mind was to update the excel with the status "Invalid" (in bold) for these receipt numbers.

Here is the modified macro. If this is not what you were looking for, then let me know.

Dinnu
 
Skip it in the DO LOOP

dinnu,
Why don't you skip it in the do LOOP ??

If the Output is an INVALID number then peg a counter ..If this counter reaches 3 then exit out of the LOOP and write this in the Sheet with status "INVALID"
 
Dinnu, great.

Dinnu,
Close enough
this will work for me.


SRC Status Date Status Group
SRC0108550230 Invalid Receipt Number ??? Invalid
SRC0108550231 Invalid Receipt Number ??? Invalid
SRC0108550232 Invalid Receipt Number ??? Invalid
SRC0108550233 Invalid Receipt Number ??? Invalid
SRC0108550234 Invalid Receipt Number ??? Invalid
SRC0108550235 Invalid Receipt Number ??? Invalid
 
You must log in or register to reply here.
Top