| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to import data
Is it possible to write a macro to convert data? I currently use the
text import wizard but since the file I am importing is not delimited so I choose fixed width and adjust the columns according to the heading. The problem is some fields in the data are actually longer than the heading for that column and thus the contents get spread over two to three columns. Any help in writting a macro for this, if possible, would be appreciated. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data and macro | Excel Discussion (Misc queries) | |||
| Import Data with Macro or VBA | Setting up and Configuration of Excel | |||
| Run a macro after data Import | Excel Programming | |||
| import data with macro | Excel Discussion (Misc queries) | |||
| import data using macro | Excel Discussion (Misc queries) | |||
![Gerald[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
