Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions | |||
Macro for multiple charts | Excel Worksheet Functions |