macro - auto run

  1. jaeremata

    Compare 2 worksheets

    Hi Everyone, I need you help regarding with my problem. I don't know how to do it. I have 3 files, 1. Result 2. Files 3. Score On the result worksheets, I have a list of vendor including the path of each worksheets( Score and Files). What I want to happen is to find the latest date on...
  2. S

    Run a macro on save sheet

    Note: I'm too basic in VBA/macros... I have a macro that exports my sheet as CSV without leaving the XLSM file, that works great: Sub ExportCSV() Dim MyFileName As String Dim CurrentWB As Workbook, TempWB As Workbook Set CurrentWB = ActiveWorkbook...
  3. C

    How to modify code to update multiple workbook files which has the same format but different data?

    Hello excel programmers. I don't know if you can help me. Yet again, if you are comfortable to view the files below for testing. This is my concerned. I have a code for each of my workbook files below. (I have over 100 workbooks which has the same codes and excel layout, but different data)...
  4. D

    Macro used to send automatic emails

    I am using the Ron de Bruin macro to send automatic emails to various users and that is working perfectly. As below: Sub Send_Files() 'Working in Excel 2000-2016 'For Tips see: Dim OutApp As Object Dim OutMail As Object Dim sh...
  5. X

    Auto Populate Cells In A Table, Based On New Month

    Hi everyone! I have a table, with Monthly Expenses. Each Month should have recurring Expenses, and I don't wish to have to type the information every Month. If there's a way to automatically import the data into the corresponding cells in my table, it would be greatly appreciated! I have...
  6. T

    Running graph-creating macro through multiple rows

    Hey, I dont and cant use VBA nor any other programming language at all but need this thing for my work, so sorry in advance for my phrasing; I created a macro simply through "record macro" button in excel. The pourpose of it is to create a simple graph out of one row of a table. Now I need...
  7. T

    Need Macro Created for pulling info of files inside a folder

    Hey have a workbook called "Office Invoice.xlsx" What i want is to open a folder i have and go through each file and pull data from certain cells and put them in on the Office invoice file. We add 500 or more invoices in an excel sheet on that file for each year, and it auto update when they...
  8. MrDB4Excel

    Autorun a macro upon opening of excel file

    I am trying to get a macro to autorun when I open a workbook. I want this macro to run automatically as soon as I have selected the "Update" selection that appears in the "This workbook contains links to one or more external sources that could be unsafe." Obviously these sources exist only on my...
  9. B

    Excel to PDF Naming convention

    Hi. I have the macro below which upon running converts the active sheet in excel to pdf. Sub SaveasPDF() Dim wsA As Worksheet Dim wbA As Workbook Dim strName As String Dim strPath As String Dim strFile As String Dim strPathFile As String Dim myFile As Variant On Error GoTo errHandler Set wbA...
  10. G

    Automatically email based on cell value

    Hey all - I would like to create a macro that automatically creates an email for a group of people based on a cell value that's selected from a drop-down menu in a range of cells. There would only be 2 or 3 status options from the drop-down menu, but a specific group of people would be emailed...
  11. D

    Private Subs to run at opening a workbook

    Dear, I need to run automatically three events upon opening the workbook; it seems that when I put them together within the same sub, only one runs and by-passes the others. The first sub I need to run is to enter a user name, it should be enforced, otherwise to close the workbook. At the...
  12. A

    Macro for downloading files from website into excel

    Hi Community Members Is it possible to do a excel vba to automate the following? Initially, I was intending to record a mouse & keyboard movement macro, please advise :) Step1: Open a website URL and login using credentials (Username and Password) daily Step2: Navigate the website via a few...
  13. D

    Copying Data from one excel to another Matching Headers

    I have a few excel which has 23 columns and another few with 7 columns with headers which I get daily with new data. I have another excel which is the master excel where I have all the data updated. My master excel has only 12 headers and columns. The headers are not the same on the master excel...
  14. W

    Making a command button dynamic

    Hi everyone, I'm fairly good with google and fairly beginner with VBA. I've found a VBA command to return a "no data" message in a row I've assigned to allow customers I am sending this file a quick check on the validity of the data. I basically want "no blanks" back from the customer in...
  15. J

    Blank cells as result of formula with ""

    Hello guys, I'm making a macro that finds the last empty cell and paste from there, the problem I'm having is that Excel won't consider an empty cell when copying a cell which formula's result is "" and pasting values, hence, the macro leaves as many empty cells as where copied from blank cells...
  16. D

    Find Nth Value without an Array

    I have a spreadsheet which has been amalgamated from few other, as such the data is not as I would like but the owner will not amend the data. I need to create a search engine of sorts using partial matches. I have the following formula for the first and second matches and they work fine but I...
  17. L

    VBA- error

    Hello Everyone, I'm new to VBA macros and need some help. I have "Live Data" through a OPC/DDE link populating in Cell A10. (connected to a PLC through RSLinx) This data is "dynamic" and updates/changes periodically. I'm copying the data from A10 and pasting it into C10 (pasted data is pasted...
  18. N

    Macro to hide/unhide columns in multiple worksheets and protect/hide on close

    Hello I have limited knowledge with macros so would appreciate any advice you can give me. I have a Workbook that has several users - most only need to view the Workbook, others need to edit certain columns. I would the columns that need to be edited hidden on opening and only visible once...
  19. I

    Insert new row with above active cell using vba excel

    Hi , i have data in column A, B ,C but i need to insert new row above active cell in coloum B original format <colgroup><col><col><col></colgroup><tbody> A B C 4 APPLE SUGAR MILK WATER 5 BANANA SUGAR MILK WATER 10 MANGGO SUGAR MILK...
  20. S

    Excel macro - open files - copy data - rename worksheet close files

    Hi there I hope someone can help with a small macro. The macro is to: 1. Look inside a specified folder at all csv files 2. Look at column G of the csv file which contains a date and time in this format 28/02/2018 08:31:10 and take the date from this the second row and then create a...

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

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