How can I use data formatting in VB?

N

Nilesh

how can i automate data->text to coloumns->Space by using
objects Programming .Where Can i get an online
encyclopedia about objects in Excel 2000
 
T

Tom Ogilvy

Turn on the macro recorder and do Data=>Text to Columns manually, going
through the text import wizard. This will record the settings you make. If
you then execute the code, it will do Text to Columns using those settings
without showing the text import wizard.
 
Top