Questions tagged [macros]

A macro in computer science is a rule or pattern that specifies how a certain input sequence should be mapped to a certain output sequence according to defined rules and procedures. Consider using [vba] tag instead of this one if the question concerns a Microsoft Office product. This helps the people answering, filter questions more efficiently.

Filter by
Sorted by
Tagged with
0
votes
1answer
52 views

creating multiple folders using excel VBA

Sub Datasheet_MC_V1() ' ' Datasheet_MC_V1 Macro ' Dim Filemane As String n = Sheets("Loop").Range("C1").Value For i = 2 To n + 1 Sheets("Loop").Select Range("A" & i).Select Selection....
0
votes
1answer
28 views

Split a large excel workbook with multiple worksheets into multiple files based on a column

I have a workbook with multiple worksheets with about 200000 rows. Each worksheet has a state column, and the states are common in all worksheets. I need separate files created based on the state ...
0
votes
0answers
23 views

Excel freezes while running macro

I have a module which gets data from a web API and then copies that data to the excel sheet, while this macro is running, all the other excel sheets freezes for a couple of seconds. Any help to ...
0
votes
1answer
38 views

Check Cells - If Cell 2 have contains Specific different text then stop from saving

I'm new to vba and have been figuring things as I need them. Any help or clue would be greatly apperiated! I have a new requirement for my macro. I have a Macro that will copy a ws, create a file name,...
0
votes
0answers
22 views

XML to Excel and vice-versa

First of all, I am really not quite familiar with XML data, I mean I didn't work with them. I just got a question if I can do something with them using Excel, try to automate some things. I could ...
0
votes
1answer
49 views

Manually run macro in powerpoint presenter view

TLDR: Can't run macros from powerpoint presenter view. If you're not interested in the background, just skip right to "What is not working". I've painstakingly created some macros that I want to run ...
0
votes
0answers
10 views

Is there a macro in Microsoft Word 2016 that sharpens all the image files in my document? [closed]

I have a scanned .docx file which contains scanned pages of my text. The images came out to be too bright and I wish to add sharpness to each page. I converted the pdf to docx as the task proved too ...
-1
votes
1answer
27 views

Accidentally closed excel vba file without saving

I was prototyping a vba macro and had two files with datasets. One was just dataset and the other was dataset with the macro. When I was about done for the day I selected the wrong file to close ...
0
votes
1answer
51 views

How to create a macro that distributes values?

How do I create a macro that takes the value of week 33 (AG5) which is 24, and distributes it in a 10-week interval 13 weeks before it (basically weeks 11-20) in the row below it, as evenly as ...
0
votes
1answer
42 views

Iterate through document and insert cross references using VBA

I'm using mail merge in Word 2016, and then saving merged results as a PDF. In order not to break the hyperlinked table of contents in the merged document when I save as PDF, I have to build a table ...
0
votes
0answers
28 views

Winword: Connection to Word Add-In (dotm file) does not stick after closing and re-opening Word file

I have written some Word macros stored in an .dotm file saved in a folder on my computer (not the default personal folder of Word). I then went to File - Options - Add-Ins - Word Add-In and connect ...
0
votes
0answers
21 views

Word Import/Export Styles: How to Preserve “Always Hide”

I'm able to successfully import and styles from one file to another except for this: The "Always Hide" attribute of built-in styles is not preserved. Is there a way to set this in Word or a macro to ...
0
votes
0answers
19 views

How to reference a value from the n th in worksheet and move to the m th row in different worksheet

I have a group of data in worksheet 1 which is under a similar category every 4 rows 9 (i.e category A) I need a copy/Reference of the group/blocks data in a worksheet which as a pattern for every 25 ...
0
votes
1answer
34 views

VBA Macro find and replace

I am looking to make a macro that uses the find and replace function using data in a two column table (Column A and Column B), that replaces everything that contains data from Column A in the rest of ...
0
votes
0answers
15 views

Modify Outlook Macro so Attachments are Included when ReplyAll

I have a successful Outlook macro, so that when I hit ReplyAll, it starts the email with "Hi Sender." However, the problem is that I want attachments to be included as well (there is a reason I need ...
0
votes
1answer
18 views

Integrating visual guide within cell to hide / unhide rows

I have 5 rows of data and want to hide 4 of them. This macro works but seems to be a bit unstable. And one has to click out of the cell J8 and then back into it for it to work. In addition, it ...
2
votes
2answers
28 views

MS Excel: INDIRECT with an ! (exclamation) followed by some string name

I am new to excel macros I am trying to get my head around the macros. I have figured out that =INDIRECT(A1 & "!D1") will reference to A1 cell and then look for that sheetname and find its D1 ...
0
votes
1answer
13 views

Excel formula repeating and replacing text in countif

I would like to know how I can perform a few actions on excel if you can help. I couldn't find a simple answer for this. For example, A1 has a name, New York, and A2 and A3 have a formula that ...
0
votes
0answers
21 views

Activate an Excel Sheet Function using a Keyboard Macro instead of an In-sheet Button Object

I'm trying to set up an Excel sheet with a function to automatically add a blank row at the top of the sheet per this question. So far, all is going well. Now I want to know if the function can be ...
1
vote
0answers
15 views

Screen recording is missing from security&privacy in macOS

today I was trying to test teamviewer and found out that my option to disable/enable screen recording is missing. (see picture) I have tried to reboot and not help. googling around did not come up ...
0
votes
1answer
20 views

Remove Emoji Macro

I found a macro that will remove the emojis from Excel. My challenge is that I can't figure out how to get it to loop. It only works on the first cell in the range. Ideally I'd like for it to be able ...
1
vote
1answer
50 views

Extracting data in a specific order from a data dump on a separate worksheet

I am trying to extract data from the "USD-ZAR" worksheet. The code works perfectly. The only problem is that the data is in descending order as opposed to ascending order which would be preferred. How ...
0
votes
1answer
16 views

How to connect midi device to grandMA2 encoders?

I have a midi controller with 3 rotary encoders and I want to connect them to grandMA2 onPC software. I know how to setup midi remotes and stuff, but it doesn't allow you to connect to the encoder ...
0
votes
0answers
26 views

How can I retrieve an array from a separate spreadsheet using a column name as the search criteria?

I have a macros-enabled Excel template. I'm trying to figure out which formula(s) I can include in it in order to achieve the following: ▪ search for column name that exists in a separate ...
0
votes
1answer
69 views

How to Copy and paste to another worksheet if value match - Excel VBA

I need to copy and paste values from sheet1 Columns(A:B) to sheet2 Columns(A:B), if Sheet1 Column F="NUMBERS" Input A 1 NUMBERS B 2 TEXT C 3 NUMBERS D 4 TEXT E 5 NUMBERS AND TEXT OUTPUT A 1 C 3 ...
2
votes
2answers
84 views

How to record keyboard macro?

I have a task to rename a lot of photos that had naming corruption and I have to rename each photo a lone which is a lot of work. I thought why won't there be a solution to record all the process of ...
0
votes
1answer
27 views

Invoice data copy to another sheet but not the formulas

I see a lot of questions here on this site but not sure if mine has been answered. I found a macro and made it work for what i need except for one thing. When it copies my data over from sheet 1 to ...
1
vote
1answer
152 views

How to Expand inbetween Numbers in VBA

I need to expand Some numbers from one to another Like when input is 399207 and 10 = Output 399207 399208 399209 399210 Input: 422209 10 904L1009 10 356608 11 ...
0
votes
0answers
35 views

Writing a macro for excel and I am having trouble with syntax. Can anyone help me?

Could someone please help with the syntax error I am getting with this macro? It will not run and I am getting the following lines in red: What do I have to change to correct the syntax error? I ...
0
votes
1answer
71 views

How to Copy Range of Filtered Data and Paste it to new work sheet in Excel VBA (without Using Clipboard)

I want to Copy ColumnA and B to New sheet Range A and B (Source Sheet Filter Applied in ColumnH) This code is Recorded one, When i use this Random Error comes. Because i have 5 submacro and When i ...
-1
votes
1answer
40 views

VBA If Then stament returning error in For Each loop

I am trying to write a VBA code that inspects each element in a specified column of a named range using an If Then statement nested in a For Each loop. This code is trying to test out a subroutine for ...
1
vote
0answers
16 views

How can i compare 2 columns row by row in excel and then extract unique information?

My Question(s): 1) Being able to compare Column A word in Column B and highlight the difference but doing this comparison row by row between the 2 columns. Iam working with a large data set of 48k+ ...
0
votes
1answer
33 views

How to differentiate between selected pictures in VBA code excel?

I am a total beginner in VBA coding. I try to arrange 3 pictures in Excel as follows: Bring all selected pictures to the same size. Bring the 3 selected pictures 188 point away from each other in 1 ...
0
votes
0answers
40 views

How to create & run a macro in Outlook's Word editor

I like to do a couple things to pictures when I paste them in an email using current O365 version of Outlook: I put a border around it, set a basic drop shadow, and indent it by 1 tab stop. I'm trying ...
2
votes
2answers
57 views

How to Add Suffix to range of cells with existing Data

Input: 55958 55959 55960 55961 55962 55963 60346 60347 60348 60349 Output: 55958-K 55959-K 55960-K 55961-K 55962-K 55963-K 60346-K 60347-K 60348-K 60349-K I ...
0
votes
0answers
5 views

Playing Macros in Testpad that you saved using a shortcut

So I have a TextPad Macro I saved. This macro goes through the file and finds certain data items. This macro is saved specifically to play once. The reason it is saved to play once is I need to ...
0
votes
1answer
16 views

Macro line that will remove formula when copying row input

could an expert please show me how to prevent formulas in "Daily Report" from being carried over? Specifically, there is a formula in E2, and I only want the data carried over, not the formula. Thanks!...
0
votes
0answers
26 views

Converting All Plain Text Links to Hyperlinks II

I have an Excel workbook that we input data into. once complete I run a macro that performs a mailmerge and some formatting of the text including changing plain text link addresses to blue/underline. ...
0
votes
0answers
26 views

Autorefresh of RSS in excel in background (not focusing excel)

So I found this already describing how to autorefresh data in excel from RSS Auto-Refresh RSS Feed in Excel but such solution makes the excel to focus itself whenever the macro is run. I know that ...
1
vote
1answer
65 views

Why is my Excel macro running so slowly?

My VBA code in excel is running very slowly. How could I make this macro code to run faster? Sub Test() Dim i As Long For i = 1 To Rows.Count Statusupdate = Cells(i, 1).Value If Status = "Started" ...
1
vote
1answer
41 views

Excel Macro - Hide and Unhide based on cell value

I want to set up for Excel Macro to automatically hide/unhide entire row based on the values in Column D. e.g. If the value in D3 = 0, then hide If the value in D4 = 1, then unhide Only variables ...
0
votes
0answers
46 views

Extract external links from multiples Excel files

I'm trying to get all the external links from multiple Excel files and I already found a way to do this with a macro, but this only works for a single file. Right now I have a list of all the Excel ...
0
votes
0answers
16 views

Maximize an excel file in Macro scheduler

I run a script with Macro Scheduler but opening the excel file minimizes it, does not maximize it, it does not occupy the entire screen. //Set IGNORESPACES to 1 to force script interpreter to ignore ...
0
votes
1answer
39 views

Copy and paste a row of data into separate rows and staggered columns using Excel VBA macro

I am trying to automate the following step. From a single row of Excel data, I would like to copy and paste each cell value into separate rows, but staggered by columns, as shown in the picture. Is ...
0
votes
0answers
15 views

Outlook To Prompt Sender to Select Subject Line Tag

We email many clients each day. We are asked to quote the client's unique customer number in each email but often staff forget. When sending emails, is it possible to have outlook prompt users/senders ...
0
votes
0answers
36 views

Executing SQL query through VBA

I am new here, but I always check this website whenever I have issues with excel and so far you've always helped me! Now I have a problem with VBA: I want to "call" an SQL query through a macro, so ...
-1
votes
1answer
80 views

Excel Macro Help: Start at R 2, read Col B, WS 1, find same in Col E, WS 2, then copy cell in Col I, WS 1 into cell of Col G, WS 2

Need to make a Macro in excel to do this: Starting at Row 2, read Column B, Worksheet 1,(need to Prefix data with PW- and trim spaces at end of string) find same value in Column E, Worksheet 2, ...
0
votes
1answer
32 views

Intercepting mouse software calls to usb mouse

I'm running win10 x64. I have a Pictek PC231A gaming mouse, which comes with macro buttons and a software to map buttons to keys/macros (among other things). I want to preface this by saying that I ...
2
votes
1answer
66 views

Two-way connection between multiple cells and across multiple worksheets

I am looking to make a 2-way connection across 2 worksheets so that I only have to change the entry on one sheet for it to be changed on the other and vice versa. I found a good explanation here (I ...
-1
votes
1answer
37 views

Force “File Save As” immediately after workbook opens — code not executing

I created a .xlsm wrkbk template with the code below (h/t mrexcel.com) embedded in a module in the macro-enabled template file. To prevent users from overwriting the template file, the macro should ...

1
2 3 4 5
31