View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Computer, call me if you have a problem Computer, call me if you have a problem is offline
external usenet poster
 
Posts: 3
Default 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.