I have written an excel template that uses a font I distribute with the
spreadsheet. Most of the computers that use this spreadsheet don't have this
particular font, so Excel falls back to a default font.

How would I install a font from within Excel using VB?

Thanks

Joe V.

You basically use the windows API.

I couldn't find anything VB specific, but this foxpro article shows how and
should be easily convertable. I didn't study it, but it appear to be 90%
API calls (done very similar to how you would do it in VB) and little foxpro
specific stuff.

On thing you need to be sure of is that you have authority to distribute the
font.

http://support.microsoft.com/default...b;en-us;186722
How To Programmatically Install a True Type Font (visual foxpro)

--
Regards,
Tom Ogilvy

"joev7777" wrote in message
...
I have written an excel template that uses a font I distribute with the
spreadsheet. Most of the computers that use this spreadsheet don't have
this
particular font, so Excel falls back to a default font.

How would I install a font from within Excel using VB?

Thanks

Joe V.

Thanks Tom,

I appreciate your response.

Joe V.

"Tom Ogilvy" wrote:

You basically use the windows API.

I couldn't find anything VB specific, but this foxpro article shows how and
should be easily convertable. I didn't study it, but it appear to be 90%
API calls (done very similar to how you would do it in VB) and little foxpro
specific stuff.

On thing you need to be sure of is that you have authority to distribute the
font.

http://support.microsoft.com/default...b;en-us;186722
How To Programmatically Install a True Type Font (visual foxpro)

--
Regards,
Tom Ogilvy

"joev7777" wrote in message
...
I have written an excel template that uses a font I distribute with the
spreadsheet. Most of the computers that use this spreadsheet don't have
this
particular font, so Excel falls back to a default font.

How would I install a font from within Excel using VB?

Thanks

Joe V.