| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Me!!. can not set the string with len more than 255 character to the value cell
i have an access file,in this i have a table, and have a memo field i
this. which field have a string less than 255 char it ok, but whic field more than 255 char it display #value! in exel file. How can i fi this problem. i use this command in VBA to set value: ExlObj.ActiveSheet.Cells(NxtLine, lc + 2).Value rsDailyReport.Fields(lc) thanks -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help Me!!. can not set the string with len more than 255 characterto the value cell
I don't speak Access, but Debra Dalgleish posted this to a similar (well, it
sounded similar to me!) request. http://groups.google.com/groups?thre...resXSPAM .com Maybe it'll help you??? "hvtrang <" wrote: i have an access file,in this i have a table, and have a memo field in this. which field have a string less than 255 char it ok, but which field more than 255 char it display #value! in exel file. How can i fix this problem. i use this command in VBA to set value: ExlObj.ActiveSheet.Cells(NxtLine, lc + 2).Value = rsDailyReport.Fields(lc) thanks. --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing character in a string | Excel Discussion (Misc queries) | |||
| Validation a character in a string | Excel Discussion (Misc queries) | |||
| find a character in a string | Excel Discussion (Misc queries) | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
| Does the cell contain the character "-" within the string? | Excel Discussion (Misc queries) | |||
Linear Mode
