VBA storing and accessing larger texts within spread sheet

[Benedikt]

Hi there,

I am embedding a small code generator into an Excel spread sheet.
Does somebody have a clever way to persistently store longer text somewhere
in an xlsm so that it can be accessed by VBA code?

Thanks!
Best,
Benedikt

 

[Jacob Skaria]

Dont know whether this will help.Even if 1024 characters are displayed or
printed, a cell can hold 32767 characters..

If this post helps click Yes

 

[Benedikt]

Nope, my text is more than that...

Dont know whether this will help.Even if 1024 characters are displayed or
printed, a cell can hold 32767 characters..

If this post helps click Yes

 

[Jacob Skaria]

Dear Benedikt

So you mean it is continous text and not in a table format.....I am not sure
whether this helps but you can have the data in text file and embed that into
excel as an OLE object.

ActiveSheet.OLEObjects.Add(Filename:="D:\1.txt", Link:=False,
DisplayAsIcon:=False).Select