Save Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2085807%22%20slang%3D%22en-US%22%3ESave%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2085807%22%20slang%3D%22en-US%22%3E%3CPRE%3E%3CSPAN%3EHello!%0A%0AI%20have%20no%20idea%20if%20it%20is%20possible%2C%20but%20worth%20a%20try.%20I%20have%20developed%20a%20template%20for%20my%20work.%20It%20is%20for%20the%20project%20leaders%20on%20how%20to%20keep%20track%20of%20the%20project%20hours.%20Now%20I%20want%20to%20know%20if%20it%20is%20possible%20to%20create%20a%20setting%20or%20VBA%20so%20the%20sheets%20are%20always%20saved%20the%20same%20way.%20For%20example%20that%20the%20file%20name%20always%20references%20refer%20to%20some%20cells%20with%20the%20needed%20data.%3CBR%20%2F%3EEach%20file%20must%20be%20named%3A%20%5BOrder%20number%5D%20-%20%5BCustomer%20initials%5D%20Planning%20requirements%20WK%5BYear%5D-%5BWeek%20number%5D%3CBR%20%2F%3ESo%20for%20example%3A%20123465%20-%20ABCDEF%20Planning%20requirements%20WK2021-03.%0ANow%20I%20can%20also%20name%20the%20template%3A%20xxxxxx%20-%20xxxxxx%20Planning%20requirements%20WKxxxx-xx%2C%20that%20my%20colleagues%20know%20that%20the%20need%20to%20fill%20in%20the%20xxxxxx.%20%0A%0APS%3A%20Yes%20I%20know%20this%20is%20actually%20just%20a%20bit%20of%20discipline%20from%20the%20project%20leaders%20and%20order%20managers%20to%20store%20it%20properly%2C%20but%20the%20more%20boarded%20up%2C%20the%20smaller%20the%20chance%20of%20errors.%3C%2FSPAN%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hello!

I have no idea if it is possible, but worth a try. I have developed a template for my work. It is for the project leaders on how to keep track of the project hours. Now I want to know if it is possible to create a setting or VBA so the sheets are always saved the same way. For example that the file name always references refer to some cells with the needed data.
Each file must be named: [Order number] - [Customer initials] Planning requirements WK[Year]-[Week number]
So for example: 123465 - ABCDEF Planning requirements WK2021-03. Now I can also name the template: xxxxxx - xxxxxx Planning requirements WKxxxx-xx, that my colleagues know that the need to fill in the xxxxxx. PS: Yes I know this is actually just a bit of discipline from the project leaders and order managers to store it properly, but the more boarded up, the smaller the chance of errors.

 

0 Replies