vba

  1. animedaytrader

    Cell.Find Run-Time error '91' VBA excel

    Hi everyone, I'm trying to automate formatting a set of new downloaded data so I can update a master sheet as new years are added for the data. All of it was working fine, but now I've run into a problem with a certain section, where I attempt to make the naming of the countries the same. This...
  2. W

    Outlook - Set up a domain-based email reminder system?

    I work for a company that reports to many other companies, and they ALL have their own rules about where to send emails, what the RE line should look like, etc. I've got checklists for each company but it would be a lot faster (and less prone to 'forgetting') if I could set up something where...
  3. R

    Solved VBA help needed

    Hi there, I need assistance with some VBA. I have lots of Excel files with marks in a folder. All files have the name and final mark in the same locations. Presently, it is time consuming to open each file and type the mark in a final mark sheet. The number of students amount to around 100. I...
  4. O

    Outer loop does not activate

    Hey, I'm trying to copy some values from one worksheet to another. The code works fine for the first row, but does not countine to the next ones. Here is the code: Sub VannprøveResultater() i = 3 j = 3 Worksheets.Add().Name = "Sheet4" Do Until...
  5. 4

    VBA Help

    Hello All I have what I'm sure to many of you will be an easy task but I'm clueless. I need to create a spreadsheet that needs to send reminders to a mailing list every three days from various dates (based on what the users input). I have no clue how to do that though.
  6. E

    Saving Excel Book in Multiple Times

    Hi All, I am trying to save a timesheet template that I update monthly multiple times in the same folder. e.g. I have a template folder with excel files named Anne, Bob, Jane, Rachel, etc; and want to save the new template over the top of these. Currently I am saving them one at a time but I...
  7. Alchemi

    Solved MS Access: Multiple copies of pages within a Report

    Hello, This thread touched on what I'd like to do but went into a different direction: https://forums.techguy.org/threads/access-print-tell-certain-pages-to-print-multiple-times.1212146/page-2#post-9529585 I am so close on completing my system except for one nagging problem. I would like to...
  8. T

    word help- macro needed

    hello I d need to ask you for a help. I have a 300 pages document (no headers no footers) and i need to duplicate each page and then hide duplicates in order to process for translation. i want to avoid manual copy paste work. i was thinking either about macro or maybe duplicate all the file and...
  9. Zsolt Kükedi

    Create a list from Google Sheets difers if it is horizontal

    Hi! I'd like to get a few cells in a list from a Google Sheets. I have the following data: First list horizontally: 1 in C2, 2 in D2, 3 in E2 Second list vertically: 1 in C5, 2 in C6, 3 in C7 Here is the test sheet: https://goo.gl/UDooqL I use the following script: function onEdit(){ var...
  10. B

    Excel footer macro

    Good afternoon everyone - I need a bit of help with a few lines of code. Here's where the problem is: For i = 1 To Worksheets.count If IsError(Application.Match(Sheets(i).Name, s, 0)) Then Sheets(i).PageSetup .CenterFooter = PageFooterText End If Next i...
  11. C

    Sending an email with excel

    A while ago, OBP helped me create an excel sheet that automatically sends me an email when a cell displays "send". Lately it has been sending an email regardless of whether the cell displays send. It's also not displaying the "action required" in the email. I was hoping someone could point out...
  12. C

    Using task scheduler to automate excel macro

    Hello, With the help of OBP, I was able to automate an excel workbook to send reminders whenever a date is reached. This would occur whenever the workbook was opened, so I was hoping to open these workbooks on a task scheduler. The task scheduler on my computer, however, is not opening up the...
  13. A

    How to automatically hide and unhide cells based on cell val

    Hey all New here and new to VBA so I apologize if this is the incorrect place to ask this question or if I'm not including enough information. Basically I have two forms, one form that is a cost est. form and another form is a proposal form (client sees this one). I have the proposal form...
  14. C

    Solved Excel 2016 and VBA to create automated business checklist

    Hello, I've been online all day trying to find more info on creating an excel spreadsheet with VBA scripts to send an email when there is an upcoming due date. I'm trying to learn about macros and VBA scripts, but I've never learned how to code and this stuff looks very dense. In this...
  15. C

    Solved Simple VBA issue

    Hi, It is the first time I try to work on VBA. I have a project to do at work but rather than learning from scratches which I cannot afford (time wise), I found a formula that seems to do the job. Private Declare Function ShellExecute Lib "shell32.dll" _ Alias "ShellExecuteA" (ByVal hwnd As...
  16. Adman8

    VBA Script for sending automatic reminder mails

    Hi everyone, This is my first query on this forum. I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts. The details of the input sheet are as shown...
  17. Adman8

    VBA Script for sending automatic reminder mails

    Hi everyone, This is my first query on this forum. I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts. The details of the input sheet are as shown...
  18. H

    Solved Excel and Emailing AGAIN!

    Good day, First I'd like to say...This site is a great learning resource! Learned so much about VBA and Macros in just two days. Now the issue. I found two great codes that I will 'splice' together to get what I want...
  19. L

    Insert multiple checkboxes in all sheets at the same time

    Hi, I have one questions. I wanna ask if is possible to insert multiple checkboxes in all sheets at the same time? I already done many search on internet about this but I gain nothing. It is possible to solve this using excel vba? or there any other way? just wonder. Thanks you for any helps.
  20. C

    Populating Excel sheet from Outlook Mail

    Hi everyone, I read a post on Tech Support Guy that was similar to my question however seeing as the thread was quite old, I thought I would ask again to see if there were any new ways of doing this. I have a spreadsheet with Name, Surname, ID number, Verification Code, Employee Number...
Top