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.
1,707
questions
1
vote
0
answers
18
views
Skip rows with NULL value
I have this code I have been using to find the 50% exceedance value per hour and month. Attached is a picture of the data. There are some NULL values in the Gen columns and I need the code to skip ...
- 11
0
votes
1
answer
23
views
How to use This Script to Disable horizontal (left/right) mouse input during specific key hold
I am an Occupational Therapist working with a patient who has quadriplegia but had great head movement. He has Windows 11 and He wants to be able to hardcore game on his gaming laptop and we have been ...
- 9
0
votes
0
answers
22
views
Left shift acting as right click
If anybody is having the problem where when you press left shift it doesn't actually capitalize anything and for some reason decides to right click instead, just check your keyboards like software. ...
-1
votes
0
answers
43
views
How to automatically insert a table based on cell value
I have a question that I'm not sure is doable but I want to try anyway.
I am creating a form where depending on the answer, I want a table to populate. For example:
Question 2: How many substances ...
- 1
0
votes
0
answers
18
views
Run Excel Macro Faster?
I am trying to run this macro, it works, however, it taking too much time to work like 3 minutes.
The refresh button should hide the empty rows and show some shapes in the sheet.
see the attached code:...
0
votes
1
answer
23
views
Converting My Macro into Array?
I have done a Macro code where I was able to show rows which contains the word "Overdue" and hide the other rows which contain the word (Completed, Pending, in progress, Delayed". ...
1
vote
1
answer
30
views
Create a macro on Word to save with current name at a different location
I have a Windows 10 PC.
Basically I have a similar problem to this: How can I save a file to two locations at the same time?, but just the opposite. I have files on a USB stick, and I want them to be ...
- 19
-2
votes
1
answer
37
views
macro for action in specific application
I am intending to map a certain keypress to a specific action, regardless of whether it is the active window, for example forward and back in VLC Player. Rather than the in-app hotkeys, I am looking ...
- 33
-1
votes
1
answer
51
views
Excel: How to split Column Value under Particular column Name
I have the Main Value as per below table. Now, I need to keep the each value under particular column name .All the values are space separated. Let say, the Main value is:2 3 6 7.
Now, 2 should goes ...
- 99
1
vote
1
answer
151
views
Excel VBA - add date and time to a file name as FILENAME_MMDDYY_HHMMSS
A few weeks ago I posted about using VBA To prompt me to add a file name when saving an excel file using a macro. Thank you for all the help. I got it to work!!
Now I have another similar question.
...
0
votes
0
answers
19
views
Save Excel file to Confluence File List via Macro
I am trying to create a macro that updates three workbooks from a single data source (ticket system data for my team).
I've got the macro to actually generate the data, but the last step is to post ...
- 123
0
votes
1
answer
24
views
look for empty cell between non empty cells in one row and then put 0
enter image description here enter image description here
A B C
abc 30 40
def 4646
ghi 45 3234
So, I want to write a macro code where it takes all three columns into consideration at once....
- 1
0
votes
1
answer
94
views
Set default zoom in Excel on a new sheet
I have set zoom level when new workbook is open with this code:
Private Sub Workbook_Open()
ActiveWindow.Zoom = 109
End Sub
How to I set custom zoom on every new sheet that's created in that ...
- 475
0
votes
0
answers
25
views
How to auto-fit column width automatically on opening file in excel?
I open a lot of CSV files in excel and close them after verifying the data.
Whenever I open a file, I manually auto-fit the column width using keyboard shortcut. However I want to automate this.
I ...
- 146
0
votes
2
answers
757
views
Macros not working from network location even after added to Trusted location
I have some users that use macros on their excel documents that are saved on one of our internal file servers. I have added the network location to the trusted locations however when the user opens ...
0
votes
1
answer
38
views
Custom abbreviated date sequence in MS word doc
This is a weird one that I would be grateful for a solution from some clever person with time to play with word macros or suchlike.
I have a word (2007) document with a few consecutive dates in ...
- 101
0
votes
2
answers
68
views
In Windows 10, how to automate a set of actions? i.e. turn the Internet off, wait 2 sec, turn on again
My Internet randomly disconnects and I have to go to Adapter options to turn it off and back on again in order for it to start working again. It's tedious and I wish I could just press a key combo to ...
- 103
0
votes
0
answers
334
views
"Microsoft has blocked macros" for Excel, but "Disable Macros" is the only available command - how to enable macros?
My program is loading/opening Microsoft Excel file file contains macros and that is why the following dialog appears:
Microsoft Excel Security Notice
Microsoft has blocked macros from running because ...
- 123
0
votes
1
answer
68
views
Why does Microsoft Word's "Protected View" prevent editing?
To the best of my understanding (and correct me if I'm wrong), the purpose of Protected View is to display the document without executing any macros that the document may contain, in case those macros ...
- 41
0
votes
0
answers
442
views
Outlook in MacOS search issue
Problem
trying to search mail in Outlook in a Mac computer. It can't find mails, even though the mails are in the inbox
Outlook Version: Office 365
Mac Version: MacBookPro (MacOS Ventrua
13.1)
...
- 11
1
vote
1
answer
124
views
Is there any benefit in signing Excel macros using EV certificates?
Some of our software services at work offer downloading Excel files as templates to fill in some data and then reuploading them to our software for import. Since the users in our domain usually are ...
- 61
1
vote
0
answers
24
views
Clicking on an unlocked cell on a protected sheet is unprotecting the sheet
I have a workbook with multiple sheets. There are unlocked and locked cells. I have a macro to protect all sheets.
After I run the macro and all sheets are protected, when I then click on a cell ...
- 11
0
votes
1
answer
32
views
Creating fast plumbing quotes with lists of equipment in excel - then turning into a word doc or PDF
I would like to create a series of events that happen - to correspond with a drop down list in excel. These would be for example
Within a header 'plant room' in Excel you select a size and type of hot ...
- 1
0
votes
0
answers
84
views
how to automate adding new data every month
Every month, I add new data from csv file to an excel table. How can that be automated? Looking at the table photo I attached, I have two questions:
I want to automatically add new columns with data ...
0
votes
0
answers
25
views
Highlighting similar text between two Word files
I have two Word documents and I want to highlight the text in common on file 2. I have the below macro (which is supposed to highlight any text strings with more than 4 words in common between the ...
- 1
1
vote
0
answers
38
views
Creating .txt files from excel columns with description [closed]
I am trying to create .txt files that have the following:
Txt file name would be cell(A1)
Content of the txt file needs to be the content of cell (B1)
Repeat throughout the column
I am new to VBA and ...
0
votes
1
answer
159
views
Merge PowerPoint Presentations Slide By Slide as Animation
I have 12 PowerPoint presentations (one for each month) with same number of slides and each slide contains similar reporting info/trends/tables for the corresponding month. I would like to merge all ...
- 1,427
1
vote
1
answer
204
views
Word 365 Allow Macros to run on Read-Only/Protected View
I am attempting to upgrade our company to Microsoft 365 x86 from Office 2019x86. We are currently stuck on 32bit because our electronically controlled document process currently has VBA macros that ...
- 11
0
votes
0
answers
35
views
How can I use text-to-speech in a Microsoft Excel macro on an Apple Mac?
My understanding is that Microsoft Excel for Windows has a 'Speak Cell' button in the Quick Access Toolbar. However, the Mac version of Excel doesn't have this. Instead, it has a 'Speak Selection' ...
0
votes
0
answers
147
views
Microsoft Word Collapse and Expand Button
Is it possible to add a button to an Word document for collapsing and expanding the headings within the document. I am looking to create a document that is easy to navigate for those who are not to ...
- 11
0
votes
0
answers
54
views
Multi Sheet Inventory that allows for an ordered quantity to be entered, once product delivered, the stock column updates to existing + ordered
I've been breaking my head over this one.
I have an inventory that has 10 sheets and a 500 different items. Stock entry To enter data, you can select the manufacturer (Lieferant), the page on which ...
- 1
0
votes
0
answers
19
views
Color duplicates rows in two different sets of data and also the rows which are present in both sets of data
Note
When I say rows, I mean cells in Column A only and not the whole row.
Data
VBA Code and Data Sample at the bottom
Background
There are two sets of data. Lets call the data on the top, Data A and ...
0
votes
1
answer
36
views
Solution to populate a ComboBox
Hello any suggestions for two small problems I have with the codes.
I am working on a form that when entering the origin city (Enter city #1:) and the destination city (Enter City #2:), based on its ...
0
votes
0
answers
70
views
Excel Macro - Update a row of information in a different sheet based on matching multiple criteria
I have been searching for a while a solution to this problem, but without much success. I need a macro that allows me to update the data in a different sheet based on matching criteria.
For example, ...
0
votes
2
answers
177
views
Excel VBA Macro to remove a specific duplicate character and leave one instance each time it finds it in a string
Windows 10
Microsoft Excel 2019
I have a Excel worksheet with multiple strings in each cell of Column A
The strings are formatted like this:
Some Text;;;;;;More text;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;...
- 77
0
votes
1
answer
15
views
Can you edit monitor disposition with a macro
I have a setup with 3 monitors and I use it in 2 different dispositions.
1: Screen 3 alone, screens 2/1 duplicated
2: Screen 2/3 duplicated, Screen 1 deactivated
I can't find a way to set theses 2 ...
1
vote
1
answer
86
views
Sort values based on colors, then on values using VBA code
I'm tryin to sort values based on colors, then on values
The macro was working very well, but on one sheet, so I have to create a new module for each sheet, and because I have around 400 sheets,
This ...
- 45
0
votes
1
answer
71
views
Word VBA Regex replacement text inserted to wrong place
I have a Word template with a macro that makes text replacements. But it pastes the replacement text to the wrong place. However, using the Word Search/Replace function manually (Ctrl + H; "Use ...
0
votes
1
answer
40
views
When an Ecel workbook with LAMBDA function must be saved as macro enabled?
I am looking for the LAMBDA function to replace the below VBA function for evaluating strings:
Function Eval(Ref As String)
Eval = Evaluate(Ref)
End Function
I made a minimum function in the Name ...
1
vote
1
answer
193
views
Custom keyboard shortcut to paste a pre-defined text?
I am finding myself with a lot of need to frequently type one of several specific short strings of text, and i'm growing very tired of the repetitive motions needed to do each.
What I would like to be ...
- 21
0
votes
1
answer
30
views
MS Word: Automatically search for strings and convert to footnotes
I've searched for variations on this question but haven't found anything quite like it.
I have a set of Word documents that include two types of inline citation. The first is a standard academic ...
- 1
0
votes
1
answer
44
views
Stop Excel Power Query from adding previously deleted rows
I have a power query that pulls data from several Excel workbooks that are added daily into a folder.
These workbooks are generated automatically and I group it in a single table for analysis.
I have ...
0
votes
1
answer
55
views
MS Access Runtime closes database when there is a mirror error. How to Ignore?
There is a MS Access Database. Sometimes there are pop ups errors: "The value you entered isn't valied for this field" and then a Macro error. But that's OK, I just click "Stop All ...
- 107
0
votes
0
answers
55
views
Endless Save loop for .DOCM file with macros
I have a .docm Word file that connects to a .csv to get mail merge data. I believe the mail merge part is not part of this problem.
The problem arises from 2 macros that I wrote.
1st macro inside ...
- 247
0
votes
1
answer
357
views
Excel VBA: How to use RegExp.replace to remove characters from a string?
In VBA Excel I am working with Regular Expressions.
I have enabled Microsoft VBScript Regular Expressions 5.5 and am trying to use RegExp for the following.
Input: "234;BB-154"
Expected ...
- 316
0
votes
0
answers
97
views
Excel VBA group by issue
ive been working on a group by function however ive run into an issue, because when the macro comes across a sheet with one row then it throws an exception at the commented line below when really it ...
1
vote
2
answers
259
views
Libre Office "Create" is not enabled for Python Macro
Libreoffice 7.4.2.3 (x86) on Win7 Home (x64). That's the current version, but problem exists for any version. New (empty) spreadsheet. I'd like to create a new Python macro.
From Tools|Macros|Organise ...
- 540
0
votes
0
answers
54
views
Is it possible to control browser video playback with key macro and not lose focus from current program?
Here's my scenario: I've got a gamedev.tv (or youtube, whatever) page open on one screen playing a tutorial video. On my other screen is Blender or Unity, whatever it is I'm learning.
I need to pause, ...
- 1
0
votes
1
answer
122
views
How Insert an image on all pages of a word (With VBA macros)?
I try to insert an image every word page.
I know that the command is Next in a for loop, but it is difficult for me to program it with that loop.
This is my code:
Sub InsertImage()
Dim oILS As ...
0
votes
0
answers
24
views
Email macro on Mail for MacOS
I get receipts to my email which need to go to my book keeping. I would love to semi-automate this process, by adding a button for me somewhere where I can go "THAT's a receipt, email to the ...
- 11