Hi Akash,

Am Mon, 4 Mar 2013 10:31:11 -0800 (PST) schrieb Akash:

Moreover, Its transferring the Tex of first cell but not naming the
file

After the first run its giving Runtime Error.

I tested the code with your 4 examples.
4 documents have been created, the text from column B inserted and named
with the path and the name from column A.
Did you suit the path? Did you start the macro from the correct sheet?


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2