I'm having to repost this as my original one was deleted due to not being able to ask questions in the main article.

I am using Rabbit's code from https://bytes.com/topic/access/insig...m-vba-vbscript and I have had two problems, the first was the Nz function which excel doesn't seem to have included so I had to write a small function to deal with this. Now I am getting an invalid procedure...