templates

Hello, As of a Microsoft update around the end of September 2017, I can't get any Templates I've made and been using for years now to open properly. Instead of just Double-Clicking on either a xltx or xltm file (in Excel 2016) and seeing 1 copy of the Template open with a suffix of "1", the...

I am trying to set up a spread sheet that will calculate the number of hours based on the times employees clock in and out each day and then give me a total for the time period. I have found lots of templates but every last one of them has a problem I don't know how to overcome. If I have an...

Dear All; How do I retrieve the absolute path of the default (per user) folder where Excel stores/looks for its template files? (I need this for MS Office versions 2007, 2010, 2013 and 2016). Many thanks in advance. =S.Br.=

I have an excel workbook that takes email templates and uses a range of cells to fill in the blanks in those templates. I want the user to be able to edit the message, but only after they have entered the fill in the blank data for the template. In my orog

Hi, I want to be able to provide people with a template which gives examples or a description, which they can fill out and copy - to be able to paste elsewhere. But the template that copies only includes the item and the answer (not the description) Eg. Name: (Your Full Name) Address: (Your...

I am creating a daily planner. So far I have been able to create a new worksheet and then create pages for every day in the given month. I am using: Sub DoDays() Dim J As Integer Dim K As Integer Dim sDay As String Dim sTemp As String Dim iTarget As Integer Dim dBasis As...

Afternoon all, I've just upgraded to Office 2013 and I'm trying to get to grips with it. Since Excel 2003, through 2007 and 2010 I have created and used standard templates for new workbooks and sheets which I store in a specific location. Using the "At startup, open all files in" option in the...

I'm working on a tracker for my service desk calls and came across the MS Access Call Tracker. I have managed to get virtually everything working almost the way I need but need some help. I wanted to upload a zip file with sample data but can't find how to upload files here on this forum...

Has anyone established how to aggregate data located in separate excel files or separate invoices? We have a template and each invoice is saved as a separate excel file and invoice number auto increments after saving and exiting. Wish to create a Monthly and Annual Report by extracting data...

Hey Guys, I've been searching the forums and have found answers that should technically work however they don't and I'm not to sure where I'm going wrong. I have a code set from excel to open a email template and email specific contacts in my data sheet. The Email template in HTML format...

Hi, I'm adding empty slide. Then I want to set Template (slide 6 from 4x3_Cool_Template.potx). But I dont know how to use it? newPowerPoint.ActivePresentation.Slides.Add newPowerPoint.ActivePresentation.Slides.Count + 1, ppLayoutBlanknewPowerPoint.ActiveWindow.View.GotoSlide...

HELP PLEASE! I am using Excel 2013. I am trying to create a template of sorts for my boss based on his criteria as follows: From 1 – 50 worksheets based on number of salespeople...

Hello, I am trying to build a template to stream data into a presentation format. The issue I am having is that the data I put in varies (The x and y axis vary in count). If someone could tell me how to auto adjust a table to fit the data coming in, I would greatly appreciate it. I realize this...

I have an Access database that creates a spreadsheet everyday. The user wants me to use conditional formatting and certain allignment rules for each cell. The User will need to be able to manipulate the data from the new file. I know Access but not Excel. I am not sure how to apply templates to...

Say I have a 2 tables, 'orders' and 'profits'. How can I make a table so that it will show the profits for the year, according to the year selected in the drop-list table. I need to know ASAP its the tast task i have for my work and is due in a few days. Thankyou

Wanted to know if anyone had an OAI template they would like to share. I created one but hate the reporting and the look.

HI, I have a workbook which i use to register clients (name; address; registration date, etc.). One of the cells uses =concatenate() to generate a unique Id for each client. I want to automate the creation of a personal workbook for each client, using data from the unique Id cell, as the...

Hi All! I am creating a boiler plate template workbook in Excel that I using many many copies of. I want to save as a template and reuse instead of "saving as" each time. I have many formulas and macros within the sheet. How can I write the formulas and macros to specify "this workbook only"...

I have written a Powershellscript to search certain text in the VBA coding. It works and is able to searchwithin the .dot files giving me useful results but in the same directory thereare .dotm files which does not seem to be searching. Please see the powershell script below...

Totalllllly new to this.... and really self taught on excel so any and all help would be useful Trying to create an excel template... and having problems with having my master chart extract totals from each individual tab. The goal is: to have a tab of each product in inventory. ie: For...