>>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.
If it's not broken, fix it until it is.
My Blog