J
jarvisrose
I am very new to VBA. I would like to do a few of things. I think it is
pretty complicated to do what I am wanting to do, I certainly don't know how
to do it. I have a list of dates and an action code for each date that get
generated automatically in a system that I didn't write and can't change. I
have a computer program written by somebody else that performs a particular
action on a particular date based on an action code. However, it performs it
the evening before the actual item is due. So, the date generated from the
other system is one day off. Plus, not every day of the month is represented
on that list so I have to add dates to the list. Also, the codes in one
system aren't the same as the other system. I am currently doing a lot of
manual work to get all of these things changed.
I would like to have some VBA code go in and change the actions codes from 1
code to another. For instance All 3s become 4s, then all 2s become 3s, and
finally all 1s become 2s. Then I want every date that is not represented on
the list to be inserted into the list. (i.e. 4/2/2006, 4/5/2006 becomes
4/2/2006, 4/3/2006, 4/4/2006, 4/5/2006) Then, all of those dates that had
been inserted should be assigned an action code of 1. I would then like the
entire list of dates to subtract 1 day. (So 4/2/2006 becomes 4/1/2006 etc).
Finally, I need to have the list in a tab delimite text file so I can copy it
into my other computer system.
pretty complicated to do what I am wanting to do, I certainly don't know how
to do it. I have a list of dates and an action code for each date that get
generated automatically in a system that I didn't write and can't change. I
have a computer program written by somebody else that performs a particular
action on a particular date based on an action code. However, it performs it
the evening before the actual item is due. So, the date generated from the
other system is one day off. Plus, not every day of the month is represented
on that list so I have to add dates to the list. Also, the codes in one
system aren't the same as the other system. I am currently doing a lot of
manual work to get all of these things changed.
I would like to have some VBA code go in and change the actions codes from 1
code to another. For instance All 3s become 4s, then all 2s become 3s, and
finally all 1s become 2s. Then I want every date that is not represented on
the list to be inserted into the list. (i.e. 4/2/2006, 4/5/2006 becomes
4/2/2006, 4/3/2006, 4/4/2006, 4/5/2006) Then, all of those dates that had
been inserted should be assigned an action code of 1. I would then like the
entire list of dates to subtract 1 day. (So 4/2/2006 becomes 4/1/2006 etc).
Finally, I need to have the list in a tab delimite text file so I can copy it
into my other computer system.