T
tmarko
I have created a demo that simulates my problem very well.
Instead of providing Excel with data from the dB as in my application
the demo read a string from the first cell and add it to a recordset
This is printed in a new Excelbook. In this Excelbook you can see tha
when the number of caracters in the input string is more than 25
caracters the printed cell show #VALUE! instead of the caracters. S
this is bothering me. This is occuring in Excel97.
How to use my demo to see this: UnZip the attached file, that consis
of 2 files
Add the Test.xla via the add In menu
Open up the TEST.xls workbook (This is prepared with a defined name fo
the first cell and named the first sheet name as TEST)
Add random caracters in the first cell but less than 256 caracters
1. Please start the demo from Visual basic Editor when standing on th
TEST .xla
The result : You see the caracters in the new Workbook beside TEST
Add random caracters in the first cell but now more than 255 caracter
2. Please start the demo from Visual basic Editor when standing on th
TEST .xla
The result: You see #VALUE! beside TEST
In the code I have commented where adding the caracter-string to a cel
from a recordset casing this strange behavour.
Hope anybody got a solutio
Attachment filename: vb tester.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=66829
Instead of providing Excel with data from the dB as in my application
the demo read a string from the first cell and add it to a recordset
This is printed in a new Excelbook. In this Excelbook you can see tha
when the number of caracters in the input string is more than 25
caracters the printed cell show #VALUE! instead of the caracters. S
this is bothering me. This is occuring in Excel97.
How to use my demo to see this: UnZip the attached file, that consis
of 2 files
Add the Test.xla via the add In menu
Open up the TEST.xls workbook (This is prepared with a defined name fo
the first cell and named the first sheet name as TEST)
Add random caracters in the first cell but less than 256 caracters
1. Please start the demo from Visual basic Editor when standing on th
TEST .xla
The result : You see the caracters in the new Workbook beside TEST
Add random caracters in the first cell but now more than 255 caracter
2. Please start the demo from Visual basic Editor when standing on th
TEST .xla
The result: You see #VALUE! beside TEST
In the code I have commented where adding the caracter-string to a cel
from a recordset casing this strange behavour.
Hope anybody got a solutio
Attachment filename: vb tester.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=66829