>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 :)