Convert image to Base64 string in VBA

[SpeeD]

Hi.

Im mapping some XML fields in a worksheet to be exported to a web page.
On of this fields is a image field and it only accepts images in a base64
string format.

how can o convert a "normal" image to a base64 string inside excel trough VBA?

thanks a Lot!!!

Speed

 

[SpeeD]

Hi joel.

For what i discovered today there some components that will do the trick.
Anyway, if anyone has some direct answer (code) to this please post it here!

SpeeD

P.S: it´s important that i only use common components (do not install
anything) because i have to distribute the Workbook...

 

[Tim Williams]

Where are the images you need to convert located?

Base64 encoding in VB/VBA:
http://www.nonhostile.com/howto-encode-decode-base64-vb6.asp
http://www.motobit.com/tips/detpg_Base64Encode/

Tim

Hi joel.

For what i discovered today there some components that will do the trick.
Anyway, if anyone has some direct answer (code) to this please post it
here!

SpeeD

P.S: it´s important that i only use common components (do not install
anything) because i have to distribute the Workbook...

What file type is the source and the converted. Are you trying to
convert BIT mapped files to JPG or something similar. You can't convert
an image to 64 bit format by just changing the string you need a
utility.

Excel VBA can't convert directly but can call other utilites that you
have installed on your PC. Excel can convert a worksheet to either JPG
or Bit mapped by savving as a picture but I don't think this is what you
want.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/showthread.php?t=168783

Microsoft Office Help

.

 

[jolly123]

Hi,

Is it possible to get an image in base64 string format and convert it back to image to embed in excel sheet?

Many Thanks in Advance,
Jolly