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

[Guest]

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.

 

[Pete_UK]

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

 

[Guest]

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

 

[Guest]

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.

 

[Peo Sjoblom]

The Text Import Wizard = Data>Text to columns


--


Regards,


Peo Sjoblom



"Computer, call me if you have a problem"