In Excel, what is CharMap.exe?

G

Geoff Woolhouse

In Excel, what is CharMap.exe, where do I find it and how do I get help using
it? I need to include characters which are normally only found in MSWord.
 
D

Dave Peterson

From that other thread:

Insert Symbol was added in xl2002.

So if you don't run xl2002+, you'll have to find a different way.

You can hit flying windows R (or windows start button|Run)
type charmap
hit enter

or even
windows start button|Programs|accessories|System tools|charmap
if you like to mouse.

Chip Pearson has an addin that may help (if you're using xl2k or lower).
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)
 
Z

Zack Barresse

To do so programmatically, try something like this ..


Option Explicit

Sub ShowCharMap()

'Define the variable
Dim WsShell As Object

'Set the varible
Set WsShell = CreateObject("WScript.Shell")

'Run the variable
WsShell.Run ("charmap")

'Clean up objects
Set WsShell = Nothing

End SubHTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.
 
C

Chip Pearson

Or, much more simply,

Shell "charmap.exe", vbNormalFocus


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



Zack Barresse said:
To do so programmatically, try something like this ..


Option Explicit

Sub ShowCharMap()

'Define the variable
Dim WsShell As Object

'Set the varible
Set WsShell = CreateObject("WScript.Shell")

'Run the variable
WsShell.Run ("charmap")

'Clean up objects
Set WsShell = Nothing

End SubHTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to
the board, as
to benefit others.
Click to expand...
 
Z

Zack Barresse

LOL! There is always a better way. Thanks Chip!

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


Chip Pearson said:
Or, much more simply,

Shell "charmap.exe", vbNormalFocus


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
Top