How can I use data formatting in VB?

  • Thread starter Thread starter Nilesh
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING 9
how to remove blank rows from a sheet using visual basic sode 1
How do i seperate colums when special pasting information 1
Problems starting Word from Excel VBA 3
MACRO OR FORMULA NEEDED FOR CALCULATION 2
NEED MACRO TO GET BALANCE 2
How to intersect two coloumns in a third coloumns 3
AMENDMENT IN MACRO 2

Back
Top