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.

I figured out how to do this without using VBA

jarvisrose wrote:
>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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...dules/200604/1