View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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