Christopher Greaves

416-621-9348 cgreaves@chrisgreaves.com
Home Site About Services Products

Embedded images (Home) ; Obtain set of original images on disk ; Build application ; Try with images embedded as images in a GUI form within the application ; Switch to images embedded as numeric strings within the application ; Converting a stored image to an ASCII string ; Converting an ASCII string to a stored image ; Optimizing storage of the embedded string ; Function to insert an image from an embedded string ; Macro to drive the function ; Essay with a string as a parameter (statement) ; Converting An Embedded String To A String ; Converting A String To An Array Of VBA Statements ; Converting an string of VBA assignment statements to an array of VBA code ; Converting an array of VBA code to a macro .

Toronto and Mississauga, Monday, September 06, 2010 8:51 PM

Essay With A String As A Parameter (Statement)

It would be nice to make the macro as simple as this:

dim sz as string
sz = “ in here the character representation of the ascii values from the image file”
call BuildTableLiteral (sz)

Sad to relate, there is a limit on the length of the string literal that can be assigned to a variable, brought about by the limit of a statement length.

No problem you think. We’ll just use continuation characters!

Not in a string literal you won’t.

And besides, there’s a limit of 20? or 25? continuation lines to a statement in VBA.

Toronto and Mississauga, Monday, September 06, 2010 8:51 PM