>>>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 :)
LOL, I had just gone back through the thread to see how that had happened.