template

  1. P

    Formula template change to vba code for userform help

    Hi I have this formula below which works on a template I have but I want to add this into my userform1. My range is in sheet called ‘Data’ A1:R17 and the AC3 (Match) is now ComboBox2 and AC4(Match) is now ComboBox1 and I want the result to go into TextBox53 [CODE]...
  2. DataBlake

    Outlook Check, Import Template, Add To Template and Send

    Hey i'm having trouble getting an outlook code to work in my favor. Basically i have a userform that an end user fills out and it assigns 2 strings to errorHD and issueHD I want to check if the user already has outlook open If its not then open outlook Then use a template that looks like Name...
  3. B

    VBA code to create new sheet from choice of templates based on cell value in a cell range.

    Hello Forum, I have exhausted every effort in searching all over different forums for a solution to my predicament. I would be eternally grateful to anyone that can find a solution to my issue.:( This is what I’m trying to accomplish: I have one master sheet called “Master” There are six...
  4. B

    Automatically create and name varying of template sheets based on cell values in multiple cell ranges of the master sheet.

    Hello, I am trying to accomplish the following: In my workbook I have a master spreadsheet named PLC Config. In PLC Config there are eight different cell value options (SPARE,ECOM,AI,AO,AIAO,DI,DO,DIDO) for cell range B12:N12. The same cell value options are present in cell ranges B15:N15...
  5. B

    File dialog prompt for power query source file

    Hope someone can help with this, I have a a csv text file that needs importing to a template then modifying using power query. Trying to find a way of being prompted with a dialog box for the source file so different named source files from different locations can be imported to the same...
  6. rjplante

    Check workbook name for specific word

    I am looking for a way to see if the workbook name contains the word "Template". If so, I want the macro to prompt the user to save the file. I have the code listed below, but it does not seem to give the correct response. How do I get this to work? If ThisWorkbook.Name = "*Template*" Then...
  7. B

    Macro Enabled Template error

    I have an .xltm file on a shared network drive. I set it up as a template to enable multiple users to use the same document at the same time, opening each instance as a template page... but... when they open it, the macro goes to save the file as a generated name... a pop up occurs stating that...
  8. R

    Macro to change text in macro on control button in workbook?

    I have inherited a process which has a template workbook with Macro buttons so users can move to specific sheets. The template has been used to create approx 700 files. I have been making some amendments to the template, which has included changing one of the worksheet names - this means one...
  9. J

    Copy Range from specific sheet of all workbooks in a folder to a template and create new template in the Master sheet

    Greetings! I am quite new to this forum and know very little about VBA. Seeking your expertise in a matter that I've been searching for a couple of days to no avail. I am looking for a vba code to copy a Range from a sheet named "Estimation" of multiple workbooks in a folder to a template and...
  10. W

    String Array

    Hello I am working on an excel file with 7 sheets. The main interaction that a user will have with the worksheet is through a user form. The user form as multiple pages and one page is already completely functional. The next page, however, is giving me a lot of problems. The first problem I am...
  11. P

    Sharepoint Server wreaking havoc on my macro

    I have a macro that creates a folder for every new client we engage with a specific folder structure. It copies a template folder to the desired location, then renames the folder based on the input in the excel workbook I run that macro from. Sometimes when I open the template, it has an...
  12. G

    Copy Formulas, save as values and then reload same formulas

    Hello All you Excel Gurus, I need a little insight. I have a template that has multiple columns and multiple rows. Set up with accounts, subtotals and grand totals. The template will have a Rollup total section on the top and multiple regions below it. My main issue is that it will be...
  13. P

    Edit and send Outlook email template .msg

    I have an email template stored on the desktop, labeled Email.msg. The Email template is in HTML format. I want to take a cell containing the recipients name from a cell in Excel and adding the name to the Email template. I have put a placeholder in the places where the recipients name should...
  14. E

    XLSTART startup folder in Citrix Virtual Desktop

    I constantly change and save my default Excel template in: C:\Users\dmalfoy\AppData\Roaming\Microsoft\Excel\XLSTART Does anyone have experience changing the default Excel template in a Citrix Virtual Desktop? I put in a ticket to my IT department and their response was clearly that of a deer...
  15. E

    Planning Template

    Hi guys, I am in the process of running a planning cycle and have currently I have managed to design what the template will look like for one area i.e. EMEA. We have numerous areas which have multiple cost centres which are further broken down into accounts at hierarchy levels 1 and 2. I am...
  16. A

    TImeline Template suddenly has errors but didn't the day before

    Perhaps you can help me solve this issue. I created a timeline using Excel template called "Timelines with milestones (yellow)" please view below Everything went smoothly, bounds were adjusted, data was entered and it worked intuitively. I even gave a presentation to my boss and showed him...
  17. A

    How to stop a Macro-Enabled Template from saving and adding a "1" to the file name

    Is there a setting or a macro that could disable the auto function of a macro-enabled template from adding a number? I have a workbook that is used for every bit of work done in house, and is copied many times. I chose to use a template to discourage anyone from making edits to the original...
  18. D

    Old template to new template... about 400 times

    I have about 400 files in an old template. The data in each file needs to go into a new template. Most of the cells between the 2 templates don't match (cell B7 in old template may go to cell C14 in new template, even in a different tab sometimes). ... I really don't want to do it manually 1 by...
  19. L

    Where is the Default location for template?

    Hi I am using Windows 10 with Office 2010 I want Excel to open to macro enabled template but where to put? Thanks
  20. R

    [VBA] Reducing >1 "Y" flags to just one

    Hi all, got a quandry here. Let's say I have a table like the below: <tbody> Paper Company Template Flag 1 Aber Chronicle JG UK 2 Aber Chronicle JG UK 3 Ban Guard JG UK Y 4 Ban Guard JG UK Y 5 Biggle Chronicle JG UK Y 6 Biggle Chronicle JG UK Y 7 Biggle Chronicle OM UK 8...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top