Distribution-program of templates for Microsoft Office (MAC and PC)
Budget: $30 – $250 USD
This project is quite simple for those who know how to do it. What I need is a program which will distribute templates and template-related files for Microsoft Office both on a PC and a MAC.
I am myself a programmer, but only in VBA...I do not use Visual Studio to create programs.
The way I imagine it is an INI-file with some codewords like:
Templates:
\\ourserver\ourfolder\ourtemplates\template1.dotx
\\ourserver\ourfolder\ourtemplates\template2.potx
Colors:
\\ourserver\ourfolder\ourtemplates\ourcolors1.xml
\\ourserver\ourfolder\ourtemplates\ourcolors2.xml
Fonts:
\\ourserver\ourfolder\ourtemplates\ourfonts1.xml
\\ourserver\ourfolder\ourtemplates\ourfonts2.xml
Figures:
\\ourserver\ourfolder\ourtemplates\ourfigures1.xml
Graphs:
\\ourserver\ourfolder\ourtemplates\ourgraph1.xml
\\ourserver\ourfolder\ourtemplates\ourgraph2.xml
Then we need a program for MAC and a program for PC. I think it is possible to ask the computer what version of office it has and thereby know exactly where to put the files. I do not know about MAC. Possibly the locations are limited so maybe you can check a few locations to see if you find normal.dotx and then that will give you the correct path.
On a MAC you can use "Add graph" and at the bottom of the menu you see something about templates. That should take you to the folder on a MAC where the different files should be stored. I think you can do the same on a PC. BUT you need to google this because Office 2013, 2016 and 2019 might have different locations....maybe the ini-file could contain some information which you can use to say exactly which folder...with of course the flexibility of unknown username.
Today companies sometimes place their templates on sharepoint. So the source of the files must be flexible. The source can be:
- Sharepoint - meaning an URL to the file (you have to check if the user has the rights to download and if not give a warning Text: "You do not have the correct rights to download the templates", Title:"Not enough rights"
- A shared folder like: \\ourserver\ourfolder\ourtemplates\ourgraph1.xml
(same - need to check that user can copy from there and if not give the warning)
- A "normal" folder-list like e.g. P:\Commonfiles\Office\mytemplate.dotx
(same - need to check that user can copy from there and if not give the warning)
If needed we must be able to sign the project. I do not exactly how that works, but I assume my customer will need to provide a certificate to sign it in Visual Studio - or something...If my customer does not have anything like that I would like you to provide me with the idea of how we can deal with it. I can always charge my customer for buying a certificate.
If you do the project I consider it delivered when I have:
The program in a PC-version and a MAC-version.
The Source Code for both programs (I might tweak them later myself)
The INI-file as an example.
I am myself a programmer, but only in VBA...I do not use Visual Studio to create programs.
The way I imagine it is an INI-file with some codewords like:
Templates:
\\ourserver\ourfolder\ourtemplates\template1.dotx
\\ourserver\ourfolder\ourtemplates\template2.potx
Colors:
\\ourserver\ourfolder\ourtemplates\ourcolors1.xml
\\ourserver\ourfolder\ourtemplates\ourcolors2.xml
Fonts:
\\ourserver\ourfolder\ourtemplates\ourfonts1.xml
\\ourserver\ourfolder\ourtemplates\ourfonts2.xml
Figures:
\\ourserver\ourfolder\ourtemplates\ourfigures1.xml
Graphs:
\\ourserver\ourfolder\ourtemplates\ourgraph1.xml
\\ourserver\ourfolder\ourtemplates\ourgraph2.xml
Then we need a program for MAC and a program for PC. I think it is possible to ask the computer what version of office it has and thereby know exactly where to put the files. I do not know about MAC. Possibly the locations are limited so maybe you can check a few locations to see if you find normal.dotx and then that will give you the correct path.
On a MAC you can use "Add graph" and at the bottom of the menu you see something about templates. That should take you to the folder on a MAC where the different files should be stored. I think you can do the same on a PC. BUT you need to google this because Office 2013, 2016 and 2019 might have different locations....maybe the ini-file could contain some information which you can use to say exactly which folder...with of course the flexibility of unknown username.
Today companies sometimes place their templates on sharepoint. So the source of the files must be flexible. The source can be:
- Sharepoint - meaning an URL to the file (you have to check if the user has the rights to download and if not give a warning Text: "You do not have the correct rights to download the templates", Title:"Not enough rights"
- A shared folder like: \\ourserver\ourfolder\ourtemplates\ourgraph1.xml
(same - need to check that user can copy from there and if not give the warning)
- A "normal" folder-list like e.g. P:\Commonfiles\Office\mytemplate.dotx
(same - need to check that user can copy from there and if not give the warning)
If needed we must be able to sign the project. I do not exactly how that works, but I assume my customer will need to provide a certificate to sign it in Visual Studio - or something...If my customer does not have anything like that I would like you to provide me with the idea of how we can deal with it. I can always charge my customer for buying a certificate.
If you do the project I consider it delivered when I have:
The program in a PC-version and a MAC-version.
The Source Code for both programs (I might tweak them later myself)
The INI-file as an example.