Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
you can try this free online service to convert image to base64 string online(http://www.online-code.net/base64-image.html).
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
reading a string in a png image file | Excel Programming | |||
how to convert image in .xls to .jpeg | Excel Discussion (Misc queries) | |||
Is there any way to search image of my local drive with Image name or Image Title, Description | Excel Programming | |||
How do I convert a picture (bmp or jpg) to a excel button image? . | Excel Discussion (Misc queries) |