If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to use Windows command within Excel macros
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
How to use Windows command within Excel macros
That's interesting - a text document within Excel. However, I was looking
for a way to save the captured data as a csv file. In which case I wouldn't have to save it as a text file first (under Windows) and then open it with Excel. Thanks for your suggestion. Jacob Skaria" wrote in message ... 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 . |
Thread Tools | |
Display Modes | |
|
|