Convert image to Base64 string in VBA
 

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

Convert image to Base64 string in VBA
 

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/sh...d.php?t=168783

Microsoft Office Help

Convert image to Base64 string in VBA
 

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...

"joel" wrote:


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/sh...d.php?t=168783

Microsoft Office Help

.

Convert image to Base64 string in VBA
 

Where are the images you need to convert located?

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

Tim


"SpeeD" wrote in message
...
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...

"joel" wrote:


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/sh...d.php?t=168783

Microsoft Office Help

.

Convert image to Base64 string in VBA
 

you can try this free online service to convert image to base64 string online(http://www.online-code.net/base64-image.html).