I believe that this problem MAY be due to a lack of
system resources,
If it was, we'd get a common Mac error code. Error 429 is
internal to VBA. It's most likely to be a path problem.
Either you're trying to create a folder instead of a file, or
you've got a filename that includes a colon, which is a Mac no-no
as the colon is the path delimiter. It's the "can't create
object" that makes me think in this direction.
I tried to find the exact meaning of the error message/number
in various places, but MS seems to be quite reluctant to give
out information... I tried the help, the Mactopia site, the
VBA site, you name it!
Gavin