Decode text in a cell encoded in basecode64

**renderman7** · 12-11-2012, 08:43 PM

hey all,

i want to create a macro that will take text from one cell in excel, which is encoded in basecode64 and have it be auto decoded in the next cell as normal.

can anyone help?

**TMS** · 12-11-2012, 09:06 PM

VBS Decode

http://www.motobit.com/tips/detpg_Base64/

VBS Encode

http://www.motobit.com/tips/detpg_base64encode/

Regards, TMS

**renderman7** · 12-11-2012, 10:26 PM

Originally Posted by TMShucks

VBS Decode

http://www.motobit.com/tips/detpg_Base64/

VBS Encode

http://www.motobit.com/tips/detpg_base64encode/

Regards, TMS

thanks for the links, but i cant make heads or tails of it.

Do i need to stick it inside of a macro, or can i trigger it to run on its own.

If you have the time, could you build the sheet for me?

thanks

**renderman7** · 12-11-2012, 10:39 PM

never mind i got it

**TMS** · 12-12-2012, 05:06 AM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save