>>>>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.
>
>rtfm, perhaps that helps.
>
>Fortunately for me <g>, I don't have Office 2007 installed on my computer.
Yeah, I did :) After considering for a moment sending an e-mail to someone and asking this question :)
If it's not broken, fix it until it is.
My Blog