Tom,

You're adding steps you don't need. For example, you don't need the
intermediate step of opening Notepad to retrieve delimited text from a web
page to a worksheet.

When you refer to "current (default) web page", do you mean the Internet
Explorer home page or some page already in an open IE window or something
else?


Steve Yandl



"Tom" wrote in message
...
Hi,

How can I use "shell" to move from Excel to the current (default) web page
to copy some comma delimited text data, then open Notepad and save it
there?
I then can open the saved text in Excel with the captured text displayed
as column data and rearrange it. Thanks for any help.

TIA
Tom