Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Macro
Check your other post.
Sam Commar wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Macro
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 On Apr 15, 1:54*pm, "Sam Commar" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Very Simple Macro | Excel Discussion (Misc queries) | |||
Simple Macro? | Excel Programming | |||
Simple Macro - I think | Excel Programming | |||
Need help with simple macro | Excel Programming | |||
Simple Macro IMO | Excel Programming |