Simple Macro

[Sam Commar]

I get a cleared checks file from the bank every day

The length of the file is constant. The number of rows might change
depending on the number of checks cleared but the columns remain constant

I want to get certain data out of the file every day -basically the check no
and the amount from the file using a macro and put it in the adjacent
columns e.g. Coolum B and C

Eg the file I get is below

00031901000013500000986010000018278091007
00031901000013500000986080000025185090407

I want to create a macro that will take out the check no ( position 20 to
26) and the amount and put in a decimal place ( position 27 to 32 then put
decimal place
and then position 33 to 34)

E.g. in the file above I would want the macro to
Colum A
( File from bank copied into Colum A)
Coloum B Coloum C
00031901000013500000986010000018278091007 098601 00000182.80
00031901000013500000986080000025185090407 098608 00000251.85



As I am a novice I would really appreciate your help on this.

Thanks

Sam

 

[Dave Peterson]

Check your other post.

I get a cleared checks file from the bank every day

The length of the file is constant. The number of rows might change
depending on the number of checks cleared but the columns remain constant

I want to get certain data out of the file every day -basically the check no
and the amount from the file using a macro and put it in the adjacent
columns e.g. Coolum B and C

Eg the file I get is below

00031901000013500000986010000018278091007
00031901000013500000986080000025185090407

I want to create a macro that will take out the check no ( position 20 to
26) and the amount and put in a decimal place ( position 27 to 32 then put
decimal place
and then position 33 to 34)

E.g. in the file above I would want the macro to
Colum A
( File from bank copied into Colum A)
Coloum B Coloum C
00031901000013500000986010000018278091007 098601 00000182.80
00031901000013500000986080000025185090407 098608 00000251.85

As I am a novice I would really appreciate your help on this.

Thanks

Sam

 

[paul.robinson]

Hi
A couple of worksheet formulas will do it
with the long number in cell A2

=MID(A2,20,6)

will pick out the check number
and
=MID(A2,26,8)&"."&MID(A2,34,2)

the other number. Your description and output numbers are not quite
the same, but i think this is what you want.
regards
Paul