templates

  1. S

    Prevent userform textbox from updating cell link until edited

    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
  2. O

    Fill Out Forms to Copy and Paste

    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...
  3. A

    Apply Template to all sheets in vba

    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...
  4. S

    Excel 2013 - At startup, open all files in: only works first time

    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...
  5. T

    Call Tracker MS Access Template

    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...
  6. Q

    Reporting Summary derived from Invoices in separate excel files

    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...
  7. P

    Using VBA to send email template with Replace Method

    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...
  8. F

    PowerPoint Slide from Template

    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...
  9. D

    Need an excel guru - template - word wrapping - page printing -

    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...
  10. M

    Auto-Fitting Templates to Table Size

    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...
  11. M

    Office 2013 Best way to Use A template when Access creates the Excel file.

    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...
  12. A

    Change table data according to drop list

    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
  13. C

    Open Action Item TEmplate

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

    use VBA to create and name workbooks based on cell data

    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...
  15. B

    Excel links "THIS WORKBOOK ONLY!" for excel template

    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"...
  16. J

    Using Powershell to search in Word VBA (.dotm)

    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...
  17. D

    Excel Inventory Chart Template / Trick

    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...
  18. P

    Will updating a template update files dependent on it?

    Sorry, this is kind of a fundamental question but I don't see it answered anywhere. When I use a template to create a new excel file, does the new excel file take a 'snapshot' at the time I create the new file and there's no connection between the new excel file and the template that created...
  19. J

    Best EXCEL VBA Templates for free

    Dear Freinds and Colleagues, I am looking for the weblinks of free excel vba macro templates. for example MVP Mr. Jerry Beaucaire's - Excel Assistant page provides best templates that helped me alot in my VBA study, tests and some useful timesaving prepapulated macros...
  20. D

    How do you create a personalized, formatted email using Excel 2007 VBA

    I am working on code (Excel 2007) that creates 200 plus emails using a template. I want to personalize the emails in Outlook 2007 (I.E. Dear John,) but also maintain formatting. I have had success doing one of the two items, but not both. If I use the generic message in the template with no...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top