vbs to macro > Otto

Thanks for your input. i had thought a fairly simple sub subRoutine could be
crafted to increment from an excel spreadsheet (1 column list) and loop thru
the process. that would NOT have completed the process but would have
eliminated much of the tedium and bought me time to learn and modify/improve
the structure. as i received this project, it had taken 3 weeks to finish
updating a single serial number. i have it down to 3 days, and want it down
to 3 minutes. old system & old software, but i know it can be done. i can tie
several macros together, but i have got to get to that list. i do appreciate
your help and consideration.
ayeFayze

ayeFayze wrote:
> Thanks for your input. i had thought a fairly simple sub subRoutine could be
> crafted to increment from an excel spreadsheet (1 column list) and loop thru
> the process. that would NOT have completed the process but would have
> eliminated much of the tedium and bought me time to learn and modify/improve
> the structure. as i received this project, it had taken 3 weeks to finish
> updating a single serial number. i have it down to 3 days, and want it down
> to 3 minutes. old system & old software, but i know it can be done. i can tie
> several macros together, but i have got to get to that list. i do appreciate
> your help and consideration.
> ayeFayze

Wouldn't it be faster just to input the data manually :-) 3 days!
Something is seriously wrong with the design. You should be able to
update all 1000 in about 3 seconds. What sort of data takes 3 days to
update for ONE serial number?

gls858

3 wks-3 dys-3 mins-3 secs are all relative to what you are working with. a
year from now, i likely will have the components integrated to the data
source of input directly and this will all have been a bad memory...'til then
i work at it. solve 1 problem at a time.

"gls858" wrote:

> ayeFayze wrote:
> > Thanks for your input. i had thought a fairly simple sub subRoutine could be
> > crafted to increment from an excel spreadsheet (1 column list) and loop thru
> > the process. that would NOT have completed the process but would have
> > eliminated much of the tedium and bought me time to learn and modify/improve
> > the structure. as i received this project, it had taken 3 weeks to finish
> > updating a single serial number. i have it down to 3 days, and want it down
> > to 3 minutes. old system & old software, but i know it can be done. i can tie
> > several macros together, but i have got to get to that list. i do appreciate
> > your help and consideration.
> > ayeFayze
>
> Wouldn't it be faster just to input the data manually :-) 3 days!
> Something is seriously wrong with the design. You should be able to
> update all 1000 in about 3 seconds. What sort of data takes 3 days to
> update for ONE serial number?
>
> gls858
>

You still haven't given me anything that I can work with. I have no idea
what you want to do except loop through a list. What do you want the code
to do with the list as it loops through it? I have no idea what "updating a
single serial number" entails.
If you wish, send me a small file with a sample of what you have and a
sample of what you want to have. Also include a detail explanation of how
you get from one to the other. My email address is [email protected].
Remove the "nop" from this address. Include the version number of Excel
you are using. HTH Otto

"ayeFayze" <bird222(removeThis)@hotmail.com> wrote in message
news:[email protected]...
> Thanks for your input. i had thought a fairly simple sub subRoutine could
> be
> crafted to increment from an excel spreadsheet (1 column list) and loop
> thru
> the process. that would NOT have completed the process but would have
> eliminated much of the tedium and bought me time to learn and
> modify/improve
> the structure. as i received this project, it had taken 3 weeks to finish
> updating a single serial number. i have it down to 3 days, and want it
> down
> to 3 minutes. old system & old software, but i know it can be done. i can
> tie
> several macros together, but i have got to get to that list. i do
> appreciate
> your help and consideration.
> ayeFayze