| 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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to import data
Gerald,
Is the data separated by spaces, tabs, etc? How is the data separated? Text-to-Columns allows you to choose one or more of these, and others. Including one of your own choosing... The trick is knowing what separates one data byte from the next... Reply back... -- steveB Remove "AYN" from email to respond "Gerald" wrote in message oups.com... 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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to import data
Steve:
I'm not sure what separates the fields but I have tried choosing delimited and different combinations of each tab and space. Space seems to be closer but it seems to be best if I just do fixed width because only one field doesn't fall into the width of the heading. Thanks for your help! Gerald STEVE BELL wrote: Gerald, Is the data separated by spaces, tabs, etc? How is the data separated? Text-to-Columns allows you to choose one or more of these, and others. Including one of your own choosing... The trick is knowing what separates one data byte from the next... Reply back... -- steveB Remove "AYN" from email to respond "Gerald" wrote in message oups.com... 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! |
| Reply |
| 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)
Hybrid Mode
