You don't need the scripting runtime.

It could be as simple as

Thisworkbook.SavesAs "C:\Myfolder\Myfile.csv", xlCSV

or

http://www.cpearson.com/excel/imptext.htm import/export text files

as an example.

Of course the scripting runtime is a third option.

--
Regards,
Tom Ogilvy



"ashishprem" wrote:


Hi,
I want to copy the records from excel sheets into a txt using macro? Is
there any way to do the same?
Regards,
Ashish


--
ashishprem
------------------------------------------------------------------------
ashishprem's Profile: http://www.excelforum.com/member.php...o&userid=31485
View this thread: http://www.excelforum.com/showthread...hreadid=536743