>>And building from that I just solved my problem. I double checked the GETWORDCOUNT function and saw that leaving it like this:
>>
>>

NumberRecords = GETWORDCOUNT(m.bnin)

>>
>>meant that it was looking for something delimited by a space, hence why I tried using a space and not a comma. Then I changed it to this:
>>
>>

NumberRecords = GETWORDCOUNT(m.bnin, ",")

>>
>>and watched it pick both record numbers up while debugging. I checked my test folder and both Excel files were there. You may have mentioned this in an earlier post but I may have misunderstood.
>>
>>Thanks for all your help, I really appreciate it. Likewise to everyone else who gave me tips.
>>
>
>Success!
>
>As soon as I saw your previous message I went back and looked at the GETWORDCOUNT() and realised you hadn't specified the comma as the delimiter. Glad you worked it out.
>
>I had asked you to check what GETWORDCOUNT() was returning and you mentioned it was 2, not sure how you checked that :)


That was in the command window itself, and I had the comma in there. It didn't dawn on me until I went back through and checked for the 50th time that I had no comma in my actual code :)