macro - auto run

Hi! I'm a complete begginer, so i don't know much about coding. I'm trying to create a button to run a macro that does the following: 1.- Save sheet2 in a specific location as PDF and saves the hyperlink in sheet24 of the active workbook in column 11 2.- Save a copy of some of the sheets of the...

Hello everyone I have a problem. I'm trying to run a macro but it doesn't work. When my co-worker runs it, it works perfectly. We both checked the settings in our computers and we have the same enable so I don't know what is the problem I would really appreciate if someone can guide me Best...

Hi all, I am a completely new user to Excel Macros! I have sourced myself a code from this site, that goes a little something like: Private Sub Worksheet_Activate() Dim LookupRange As Range Dim MoveToRange As Range Dim MoveDay As Long Dim ClearRow As Range Set LookupRange =...

macro

Hi everyone! I'd like to seek your expertise here as I am new to macros/VBA. I have 5 workbooks, and within each workbook, I have a number of worksheets. However, from these worksheets, I'd only require about two to four columns of data to be copied (these could be 1 - 2, 3 - 4, or, 1, 3-4, 5...

Hi all, hope you are doing. I'd like to ask if someone can guide me how to build a macro that updates automatically xml tables? I have already recorded a macro to map the xml however when i try to record an update or import the files it gives me an error. It might be simple but can't find a...

Hi All I would really appreciate your help. I would like to create a manager workbook for individual managers which include different tabs for appraisals, training and sickness of lists of there staff. Currently I have managed to pull the different reports for all and complete a macro to...

Sub Macro1() ' ' Macro1 Macro ' ' SolverOk SetCell:="$BD$8", MaxMinVal:=3, ValueOf:=0, ByChange:="$AJ$8", Engine _ :=1, EngineDesc:="GRG Nonlinear""" SolverOk SetCell:="$BD$8", MaxMinVal:=3, ValueOf:=0, ByChange:="$AJ$8", Engine _ :=1, EngineDesc:="GRG Nonlinear"""...

Hi, I need help please! I have this code but I need it to work automatically. The idea is= I need to gain the data from the range "A6:W29" but only cells with data and to do it in every sheet except for "RESUMEN" "S.Inicial" and "S.Final". Right now I can merge all the info but running the...

I have 2 sheets in my excel file (Data and DataRanges). DataRanges sheet includes Start & End columns (multiple rows) which represent the range for each graph. The data sheet includes Data Serial which will represent data in serial for those ranges (start, end) to plot a simple line graph...

Hi, I'm trying to make a macro run on every sheet in my workbook, problem is macro doesn't work if cell value is 0: Sub Ola() Dim Rng As Range Dim InputRng As Range, OutRng As Range xTitleId = "KutoolsforExcel" Set InputRng = Application.Selection Set InputRng =...

how do I add a Macro that will work with multiple CSV files of the same name. but only search the one thats in the same(file) location. as the spreadsheet using the macro normally you could use .\ to reference the same folder, but this doesnt work. any help would be great My spreadsheet...

I'm using Office 365 and am importing data from an external database, creating a query as I do. I then have a macro that does some formatting and copies the table, without headers, to my main table. The code works perfectly if I open the editor and run it line by line. When I create a button to...

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

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

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

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