|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Insert data into a sheet from a textfile
Hi for all
This is very hard. I want to insert into a text file create by Excel some information like name, address and so on. When the file is opened, excel´s macro waits 'till I save the file. Then, it copy each line of the text file and put in a excel´s row. Please HELP MEEEEEEE!! Hughes for all |
|
#2
|
|||
|
|||
|
Are you familiar with Excel's Object model? Open the text file, read in each line, you will need some delimiter for each field. For each field insert into an excel Worksheet. When you reach the end of a line, start a new row in Excel.
__________________
El éxito consiste en una serie de pequeñas victorias día a día MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Insert data into a sheet from a textfile |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|