Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Import External Data Wizard
Hi all,
can anybody point me a control, which is similar to the one used as Data Preview in Text Import Wizard - Step 3 of 3 in Data-Import External Data menu. I would like to use exactly the same functionality like the control mentioned above. What control are actually the Excel guys using to import external data? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Import External Data Wizard
No sure what you are trying to do. One thing you can do is to record a macro
while performing the text import and see the commands that get executed. You can also open a text file and read the data row by row and perform your own conversion. Using the Split function in VBA will seperate the data by a delimiter just like Text-To-Columns. If you want to give the user different options for the import, you can write your own Userform so the user can select options and then depending on the results do a Query (which is used by the text import function) seting the options the user selects on the userform. "edzh" wrote: Hi all, can anybody point me a control, which is similar to the one used as Data Preview in Text Import Wizard - Step 3 of 3 in Data-Import External Data menu. I would like to use exactly the same functionality like the control mentioned above. What control are actually the Excel guys using to import external data? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Import External Data Wizard
Hi Joel,
thank you for your prompt response. If you want to give the user different options for the import, you can write your own Userform so the user can select options and then depending on the results do a Query (which is used by the text import function) seting the options the user selects on the userform. This is exactly what I am trying to achieve. However, I would like to use the grid-like control mentioned above. I already wrote my own form but used a MSFlexGrid in it, so when used on client's machine it gets a license problem. Have you got another idea? thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Import External Data Wizard
No sure why you are using MSFlexGrid. You could open an new excel
application making it invisible and then pasting the data in to a spreadsheet and sorting. "edzh" wrote: Hi Joel, thank you for your prompt response. If you want to give the user different options for the import, you can write your own Userform so the user can select options and then depending on the results do a Query (which is used by the text import function) seting the options the user selects on the userform. This is exactly what I am trying to achieve. However, I would like to use the grid-like control mentioned above. I already wrote my own form but used a MSFlexGrid in it, so when used on client's machine it gets a license problem. Have you got another idea? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import external data into Excel | Excel Discussion (Misc queries) | |||
Excel 2003 data import wizard does not support line ends in fields | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
excel import external data wizard | Excel Discussion (Misc queries) | |||
Import External Data Wizard | Excel Programming |