Posted to microsoft.public.excel.programming
|
|
Creating a macro to use the text import wizard
abxy
Have a look here for instructions on recording and running a macro.
http://support.microsoft.com/default...ault.asp#chap2
Gord Dibben Excel MVP
On Sat, 10 Jan 2004 18:06:32 -0600, abxy
wrote:
Ok, Major thanks. this has gotten me off on the right foot, however,
I'll be the first to tell you, I don't know a thing about the process
of getting a macro written out in VB to naming it and using it as a
"ctrl+" hot key in my workbook.
As I said before I'm trying to create a macro to paste my text, which
is already on the clipboard, and use text import wizard, or perform
it's function at least, which is, in this case, breaking up my pasted
text into columns. This is as far as I've gotten:
Worksheets("Sheet1").Activate
ActiveSheet.Paste
I looked into the "texttocolumns" command in VB, and it's exactly what
I need. I know it's exactly what I need because i read the description
of what it does. The problem is, I don't know the first thing about how
to go about using it and making a macro out of it. So i'm here asking
for help on how to create this macro i need, from start to finish. If
it'll help you all any the image below is how my text needs separated
into columns. How do I this?
Attachment filename: example.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=403657
---
Message posted from http://www.ExcelForum.com/
|