Christopher Greaves

416-621-9348 cgreaves@chrisgreaves.com
Home 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, Sunday, December 05, 2010 3:06 PM

Switch To Images Embedded As Numeric Strings Within The Application

I know that I can manipulate stings within a module. My next effort was to load a string representation of an image into a regular code ,module as data. In this form, each line of data is preceded by a single-quote character so that it appears as a comment to the VBA interpreter when the user loads the end-user application.

Sadly, the interpreter won’t allow the user access to a module in a locked appliaction. That’s a good thing, but it prevents me writing code to make use of data stored in this fashion.

that sent me off looking for a means of embedding the data as a parameter to a fucntion call.

I reasoned that if I had a Function BuildTableLiteral(sz As String, strTable As String), I could pass to it the string representation of the image and the name of the table and it woul ddo the job just nicely, thank you!

I needed a way to convert an image to a string, and vice-versa.

Toronto and Mississauga, Sunday, December 05, 2010 3:06 PM