ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Programmatically Set the Workgroup Templates location (https://www.excelbanter.com/excel-programming/345283-programmatically-set-workgroup-templates-location.html)

joe215

Programmatically Set the Workgroup Templates location
 
I want to create an installation program in Visual Basic.NET to install Excel
templates on a user's computer system. That's no problem, but I also need to
see if the user already has a Microsoft Office Workgroup Templates location
identified. If they do, then I want the Excel templates to be installed in
that directory. If they don't, I want to set the Workgroup Templates
location programmatically.

So, what namespace and class allows me to read and change the Workgroup
Templates location?

Thanks,
joe

David Lloyd[_3_]

Programmatically Set the Workgroup Templates location
 
Joe:

The following KB article contains information about the registry location
for the Workgroup templates.

http://support.microsoft.com/default...b;en-us;889495

Generally, although I don't know all of your specifics (version of Visual
Studio, Office, etc.), you can use the Registry Installation Editor to write
registry values , and the Launch Conditions Editor to read registry values.
The following KB article has more information.

http://support.microsoft.com/default...b;en-us;827026


--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


"joe215" wrote in message
...
I want to create an installation program in Visual Basic.NET to install
Excel
templates on a user's computer system. That's no problem, but I also need
to
see if the user already has a Microsoft Office Workgroup Templates location
identified. If they do, then I want the Excel templates to be installed in
that directory. If they don't, I want to set the Workgroup Templates
location programmatically.

So, what namespace and class allows me to read and change the Workgroup
Templates location?

Thanks,
joe



joe215

Programmatically Set the Workgroup Templates location
 
David-
I read through the articles that you referenced and I see how to proceed.
Thank you very much for your advice.
-Joe

"David Lloyd" wrote:

Joe:

The following KB article contains information about the registry location
for the Workgroup templates.

http://support.microsoft.com/default...b;en-us;889495

Generally, although I don't know all of your specifics (version of Visual
Studio, Office, etc.), you can use the Registry Installation Editor to write
registry values , and the Launch Conditions Editor to read registry values.
The following KB article has more information.

http://support.microsoft.com/default...b;en-us;827026


--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


"joe215" wrote in message
...
I want to create an installation program in Visual Basic.NET to install
Excel
templates on a user's computer system. That's no problem, but I also need
to
see if the user already has a Microsoft Office Workgroup Templates location
identified. If they do, then I want the Excel templates to be installed in
that directory. If they don't, I want to set the Workgroup Templates
location programmatically.

So, what namespace and class allows me to read and change the Workgroup
Templates location?

Thanks,
joe





All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com