 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2007How 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. 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 <Computercallmeifyouhaveaprob...@discussions.microsoft.com> wrote: > I copy data into Excel from a website on the Web. > [quoted text clipped - 7 lines] > How can I call up the Text Import Wizard via keyboard or place it on a bar > so it is in a static position. > Why don't you record a macro while you do it once to see what you end > up with? [quoted text clipped - 18 lines] > > How can I call up the Text Import Wizard via keyboard or place it on a bar > > so it is in a static position. 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. > Why don't you record a macro while you do it once to see what you end > up with? [quoted text clipped - 18 lines] > > How can I call up the Text Import Wizard via keyboard or place it on a bar > > so it is in a static position. The Text Import Wizard = Data>Text to columns  SignatureRegards, Peo Sjoblom >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 [quoted text clipped - 29 lines] >> > bar >> > so it is in a static position. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.