simple contatenation....or so I thought

[Annalyzer]

Can anyone help me see the problem with this string concatenation?

fileName = "'C:\Documents and Settings\" & myName & "\Desktop\UCAN1021001.xls'"

It should be a simple thing, but it won't add the last section onto the string. I get 'C:\Documents and Settings\Annalyzer and nothing else.

[Stewart Ross]

Hi. The concatenation of the three strings appears to be OK, so you need to look at other possibilities.

* Is the length of string filename adequate for the purpose?

* What type is variable myName? It is not a fixed-width string or somesuch?

* Check what the length of the text in variable myName is (using Len(myName)). Is it what you expect? This is to rule out hidden spaces padding the string.

* Has a newline or any other special character been added to the end of the text in myName?

-Stewart

[Annalyzer]

That was it, thanks! myName had one space padded onto the end of it that was somehow preventing the rest of the string from concatenating.

Now if I can figure out why it gives me the error message "Microsoft Office Access can't save the output data to the file you've requested." I find that screaming "Why the h*** not?" at the monitor isn't helping as much as I had hoped. I'll give it a rest and look at it again later and I still can't figure it out, I may post my code and let the experts take a look.

Thanks for your help!