macro - auto run

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: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm Dim OutApp As Object Dim OutMail As Object Dim sh...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi, Please help me in this problem. I have my data in worksheet 1 with Row headers..Like Name, City, Assignment,Date. Now worksheet 1 is having list of 100 members in Column1 and they will be assigned 2-3 type of assignment on daily basis. Assignment will be entered on Column 2..Date will will...

I am new to visual basic, but I need to have a macro runafter a date is added to a specific cell(G7). I don’t want to use a button I would like it to be automatic. Anyhelp would be greatly appreciated.

Hello everyone, I am looking for a way to run this macro on a determined starting point not only on "m3137" but for example if I am in "A3194". It may be worth to mention that I added blank rows to make navigation easier and to have a cell to do the sum. This is the code I used: Sub...