>>For your first problem you have to set Fomat property to be "Text" before (not after) entering a value.
>
>Nadya, there is another - and slightly simpler - option: To put a single quotation mark in front of the text. Something like this:
>
>...Cells(nrow, ncol).Value = ['] + MyField

Thanks, this worked.

Unfortunately, I still don't know how to fire Record Macro option from Excel 2007 - could not find this menu option anywhere.