|
Home > Archive > IIS ASP > March 2007 > how to read cell data line by line from excel using vb script in macro?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
how to read cell data line by line from excel using vb script in macro?
|
|
| ashok0866@gmail.com 2007-03-27, 1:18 pm |
| I had created a macro to read data from an excel sheet and write the
values to a text file. I had used "ActiveSheet.Range("GB" & k).Value"
command to read the values from the excel.
The issue is: some cells in the excel sheet is having two lines value
and four lines data, the text file is generating that value in a
single line. (Ex. the cell value in address column is in four lines
and should display in four lines in the text file generated from the
macro)
Can i do something in the excel sheet or in vb script to read the
address value line by line and write line by line in text file???
Please help me........
Regards,
Ashok
| |
| Tim Williams 2007-03-27, 7:25 pm |
| If the Excel cell value has "hard" return/newline then those should also show up in your text file (unless you're stripping them).
Is the Excel data definitely multi-line or is it just wrapped?
--
Tim Williams
Palo Alto, CA
<ashok0866@gmail.com> wrote in message news:1175001106.981098.114830@n76g2000hsh.googlegroups.com...
> I had created a macro to read data from an excel sheet and write the
> values to a text file. I had used "ActiveSheet.Range("GB" & k).Value"
> command to read the values from the excel.
>
> The issue is: some cells in the excel sheet is having two lines value
> and four lines data, the text file is generating that value in a
> single line. (Ex. the cell value in address column is in four lines
> and should display in four lines in the text file generated from the
> macro)
>
> Can i do something in the excel sheet or in vb script to read the
> address value line by line and write line by line in text file???
>
> Please help me........
>
> Regards,
> Ashok
>
|
|
|
|
|