View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Benedikt Benedikt is offline
external usenet poster
 
Posts: 2
Default VBA storing and accessing larger texts within spread sheet

Nope, my text is more than that...

"Jacob Skaria" wrote:

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


"Benedikt" wrote:

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