Excel to notepad

[juleshsol]

Hi,

I wish to copy data from excel into notepad. Is there a way to do this?
I have opened excel, opened notepad but it appears none of the options within Excel VBO seem to match what I want. I have tried 'Write to Clipboard' but am unsure what the Input value would be.

Please help

Thank you

 

[Anjaneyareddy]

Yes..we can Copy Data From Excel to Notepad.

1)use Excel VBO
2)Create Instance
3)OpenExcel(Give Path)
4)SaveAs(here give the extension .txt)

it will save the Data as a txt file


Thanks
best regards,
reddy