255 char cutoff populating cells with a variant array

[rljenki1]

Hello All,
I am having a problem populating an excel (Excel 2k on win2k) worksheet. I am using a two dimensional variant array which contains strings of various sizes, and generally this technique works great.

The code is something like

worksheet(1).Range(cells(1,1), cells(100,100)).resize(100,100) = myVariantArray

The problem I have is that I can't populate a cell with more the 255 chars at a time. The data is very often larger than this and so gets cut off at 255 chars. There is no error message or anything, it works as normal, but all the data isn't loaded.

I have been stuck on this problem for ages (weeks!) and I have developed a pretty clunky work-around but efficiency is key and I would love to be able to use the variant array method.

If anyone has any ideas they would be very appreciated.

Ross J.

 

[Andrew Poulsom]

That doesn't surprise me. Have you tried renaming the folders first?

http://support.microsoft.com/?kbid=320081

 

[rodrigorpinto]

That doesn't surprise me. Have you tried renaming the folders first?

http://support.microsoft.com/?kbid=320081

Hi Andrew!

Yes, my issue is listed as Cause 4 on this article. The thing is: I have a shared drive called K but I need to use the full path because of my internal clients that eventually can use letter Q or J for example.

I tried the function to rename it as a tentative to change the file name internally but looks like there is no way to cheat the system...

Thanks a lot for your support. Really appreciate that. Mr Excel is helping me for almost 10 years but now I decided to join you guys and I hope I can share some knowledge with you all and always keep learning.

Cheers,
Rodrigo