| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use data formatting in VB?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use data formatting in VB?
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. -- Regards, Tom Ogilvy Nilesh wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use data formatting in VB?
Thanx Buddy & Happy New Year *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting ALL data labels for ALL data series at once | Charts and Charting in Excel | |||
| Formatting data series - line between certain data points only | Charts and Charting in Excel | |||
| Formatting Rows of Data based on Column Data | Excel Worksheet Functions | |||
| How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!) | Excel Discussion (Misc queries) | |||
| formatting data | Excel Worksheet Functions | |||
![Nilesh[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
