How to use Windows command within Excel macros
Hi Tom
--From 'Insert' menu select 'Object'
--Select 'Word Pad Document'
--Select 'Display As Icon' if you want..
--Edit,save etc; as you want
--
Jacob (MVP - Excel)
"Tom" wrote:
Hi,
I want to select a bunch of text data separated by commas from a website,
use Windows copy command to copy and paste it into a worksheet in Notepad
and save it as a text file.
How can I do that? That's all.
In case you want to know further, I then can open the text file within
Excel as a comma delimited data and manipulate it as much as I like. Thanks
for any help.
TIA
Tom
.
|