| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
repetitive text imports
I'm importing many files into excel using text import wizard. I delineate
them all exactly the same but it takes time to do it. I was wandering if there was a way to do it automatically with a macro, etc? thank you for any help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
repetitive text imports
Hi,
Go to Tools Macro Record New Macro... Then go through your import wizrd routine and, when you're finished, click the stop recording button. Post back if you need help from there. -- Ken Hudson "Knox" wrote: I'm importing many files into excel using text import wizard. I delineate them all exactly the same but it takes time to do it. I was wandering if there was a way to do it automatically with a macro, etc? thank you for any help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
repetitive text imports
ok i thought that would work, and it did. thank you!
"Ken Hudson" wrote: Hi, Go to Tools Macro Record New Macro... Then go through your import wizrd routine and, when you're finished, click the stop recording button. Post back if you need help from there. -- Ken Hudson "Knox" wrote: I'm importing many files into excel using text import wizard. I delineate them all exactly the same but it takes time to do it. I was wandering if there was a way to do it automatically with a macro, etc? thank you for any help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To display repetitive text, one time, auomatically | Excel Discussion (Misc queries) | |||
| Create a shortcut for repetitive text | Excel Discussion (Misc queries) | |||
| Can delimited text file imports be extracted to a single column i. | Excel Discussion (Misc queries) | |||
| ODBC imports numbers as text | Excel Programming | |||
| Imports | Excel Programming | |||
Linear Mode
