VBA storing and accessing larger texts within spread sheet

  • Thread starter Thread starter Benedikt
  • Start date Start date
B

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
 
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
 
Nope, my text is more than that...

Jacob Skaria said:
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
Click to expand...
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word to Excel: Export comments with text and line number 0
forcing specific sheet opening upon launch of .xlsx file 4
Store VBA-Code centrally 2
using Forms and VBA within Excel 3
2007 vs 2003 2
How to prevent a number stored as text from converting to a number 2
VBA Basics - Where does the code live? 3
Convert an Excel Spread Sheet to a Relationship Database 1

Back
Top