How do I call up the Text Import Wizard via a macro.
 

I copy data into Excel from a website on the Web.

The only place I can find the Text Import Wizard option is in the paste
options box which is a drop down box that appears after I have pasted the
data into a cell.

The paste options box appears only after I have pasted and I have been
unable to call it up via a macro since the position of the box changes.

How can I call up the Text Import Wizard via keyboard or place it on a bar
so it is in a static position.

How do I call up the Text Import Wizard via a macro.
 

Why don't you record a macro while you do it once to see what you end
up with?

Alternatively, you could consider using Data | Text-to-columns.

Hope this helps.

Pete

On Oct 11, 7:38 pm, Computer, call me if you have a problem
soft.com wrote:
I copy data into Excel from a website on the Web.

The only place I can find the Text Import Wizard option is in the paste
options box which is a drop down box that appears after I have pasted the
data into a cell.

The paste options box appears only after I have pasted and I have been
unable to call it up via a macro since the position of the box changes.

How can I call up the Text Import Wizard via keyboard or place it on a bar
so it is in a static position.

How do I call up the Text Import Wizard via a macro.
 

"Pete_UK" wrote:

Why don't you record a macro while you do it once to see what you end
up with?

Alternatively, you could consider using Data | Text-to-columns.

Hope this helps.

Pete

On Oct 11, 7:38 pm, Computer, call me if you have a problem
soft.com wrote:
I copy data into Excel from a website on the Web.

The only place I can find the Text Import Wizard option is in the paste
options box which is a drop down box that appears after I have pasted the
data into a cell.

The paste options box appears only after I have pasted and I have been
unable to call it up via a macro since the position of the box changes.

How can I call up the Text Import Wizard via keyboard or place it on a bar
so it is in a static position.

How do I call up the Text Import Wizard via a macro.
 

I did try to do it via macro. Since the position of the box changes, I
cannot use the mouse. I need the data on one line, that is why I do not use
text to columns. Also, I need to do other changes on that the Text Import
wizard does.

So, back to my question... how do I call up the Text Import Wizard or the
PasteOptions via keyboard or have it on a bar.

"Pete_UK" wrote:

Why don't you record a macro while you do it once to see what you end
up with?

Alternatively, you could consider using Data | Text-to-columns.

Hope this helps.

Pete

On Oct 11, 7:38 pm, Computer, call me if you have a problem
soft.com wrote:
I copy data into Excel from a website on the Web.

The only place I can find the Text Import Wizard option is in the paste
options box which is a drop down box that appears after I have pasted the
data into a cell.

The paste options box appears only after I have pasted and I have been
unable to call it up via a macro since the position of the box changes.

How can I call up the Text Import Wizard via keyboard or place it on a bar
so it is in a static position.

How do I call up the Text Import Wizard via a macro.
 

The Text Import Wizard = DataText to columns


--


Regards,


Peo Sjoblom



"Computer, call me if you have a problem"
soft.com wrote in message
...
I did try to do it via macro. Since the position of the box changes, I
cannot use the mouse. I need the data on one line, that is why I do not
use
text to columns. Also, I need to do other changes on that the Text Import
wizard does.

So, back to my question... how do I call up the Text Import Wizard or the
PasteOptions via keyboard or have it on a bar.

"Pete_UK" wrote:

Why don't you record a macro while you do it once to see what you end
up with?

Alternatively, you could consider using Data | Text-to-columns.

Hope this helps.

Pete

On Oct 11, 7:38 pm, Computer, call me if you have a problem
soft.com wrote:
I copy data into Excel from a website on the Web.

The only place I can find the Text Import Wizard option is in the paste
options box which is a drop down box that appears after I have pasted
the
data into a cell.

The paste options box appears only after I have pasted and I have been
unable to call it up via a macro since the position of the box changes.

How can I call up the Text Import Wizard via keyboard or place it on a
bar
so it is in a static position.