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
0 answers
10 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
16 views

Multi Sheet Inventory that allows for an ordered quantity to be entered, once product delivered, the stock column updates to existing + ordered [closed]

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
17 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
32 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
19 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
36 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;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;...
  • 67
0 votes
1 answer
9 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
50 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 ...
0 votes
0 answers
37 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
35 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
90 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
27 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 ...
0 votes
1 answer
30 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
32 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 ...
0 votes
0 answers
26 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 ...
0 votes
1 answer
63 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 ...
0 votes
0 answers
42 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 ...
0 votes
2 answers
84 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 ...
0 votes
0 answers
15 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, ...
0 votes
1 answer
49 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
17 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 ...
0 votes
0 answers
41 views

changing color of specific word using Pages in macOS?

How can I change the color of specific word using Pages? I just want to change the color of O and X of the already completed document. I don't really want the color to change immediately as I type. I ...
  • 1
0 votes
1 answer
664 views

Outlook Trust Center / Macro Settings greyed out

Since the last automated update of Office 2019 ( to Microsoft® Outlook® 2019 MSO (Version 2209 Build 16.0.15629.20196) 32-bit) I cannot run my personal macros anymore. The options in the dialog are ...
1 vote
1 answer
30 views

How can I, as a noob to advanced text editing, write a script to automate converion from one enum to another?

The title is pretty poor, sorry about that. I am using two assembler/disassembler libraries and both have separate register enums. The libraries are Zydis and Capstone. In capstone the register enum ...
0 votes
1 answer
31 views

Excel - Transfer inputs from one sheet to another sheet to do calculations and returns a value

I'm just wondering if I could link the two sheets in Excel where you can transfer inputs from Sheet 1 to Sheet 2 to do some calculations and then return a value back to Sheet 1. See the attached ...
  • 1
1 vote
1 answer
34 views

Microsoft Word - adding page number to page not Header or Footer

I reformat texts to be readable by our students who read with Braille. We are always looking for ways to speed up our processes so that we can deliver more texts and deliver on time. Part of this ...
0 votes
1 answer
117 views

Macro to create folder\subfolder\file.xlsm via Shell(cmd /c md)

I found this amazing code by nixda ... which creates a folder\subfolder structure named with values from a worksheet's cells. Creating folders and sub-folders with a VBA macro . Would it be possible ...
0 votes
1 answer
79 views

Word macros suddenly blocked

I have a Word 2019 .docm file that contains a few macros that I wrote myself. This file was "working" since several years fine until now. Today, I opened it and got a warning that the macros ...
0 votes
0 answers
57 views

Excel freezes when running a macro which works on another sheet

when i run the below code on a sample document with a few columns, it works fine but as soon as i run it on a larger document excel just freezes SampleDoc Sample Doc code Sub RCOps_Compare() ...
0 votes
0 answers
37 views

Issue with PsExec running batch file applications is black

I am trying to run a remote script to launch a game server on my server. Using PsExec is working great for my other game servers. Now with this one game server (Atlas, using their Atlas Server Control)...
  • 1
0 votes
0 answers
26 views

VBA auto selecting and copying data certain amount of times

I am currently stuck with trying to copy data and paste it to another sheet certain amount of times (7). Example. Data is in range (A3:A8) and I need each of cells to be copied 7 times in a row to ...
  • 1
0 votes
1 answer
17 views

Not able apply filter when I select whole excel sheet

I have an excel sheet with macro-enabled when I select a column to apply the filter, it takes only 1653 cells, if I select all using shortcut key ctrl+a also it'll select only 1653 cells can you ...
0 votes
1 answer
64 views

How to get Excel Worksheet List Activate Toolbar?

I have many excel workbooks with many worksheets in them. It is always difficult to navigate between them. I found a VBA macro that shows the list of them using Macro. Here is the macro. Sub SheetMenu(...
0 votes
1 answer
43 views

How to make macro work with all cells of column A?

How to make macro work with all cells of column A? So that can paste into several cells at a time and the data is converted. I need this in order to be able to convert multiple data at once. I have ...
  • 19
0 votes
1 answer
267 views

How fix macro error: "Runtime '9': Subscript out of range"?

If I enter or paste one word or one number, it gives an error: "Runtime '9': Subscript out of range". It is necessary that one character can be entered, but without conversion. If remove ...
  • 19
0 votes
0 answers
123 views

How to tell if a keyboard/mouse macro is triggered/running?

I have a Logitech G915 keyboard. I have a macro every 3 minutes to press a button. I want to know when the macro is running (triggered). How to tell if the macro is triggered/running? I thought of a ...
0 votes
1 answer
97 views

How to remove these extra spaces in a doc file?

I was wondering if there is any command in MS word to remove all the extra spaces between a huge table's border and its content and put all the lines on the same order? Let me illustrate it by some ...
  • 103
0 votes
0 answers
33 views

Create outlook folder loop via excel range

I could able to loop sender names from first columns of excel & nwow I am trying to create folder loop in below code but it showing error !!! Sub MoveItems() Dim myNameSpace As Outlook.Namespace ...
user avatar
0 votes
1 answer
29 views

How to set the resolution of a macro exporting images of LibreOffice Writer pages?

Previously I've asked how to export all pages of a LibreOffice Writer document to images. I've got this answer. I've adapted the macro towards my needs and this is my current code: Sub ...
  • 582
0 votes
1 answer
27 views

How To Create Keyboard Shortcuts, Quick Keys or Macros or Whatever Else They Might Be Called

Online, I (and probably you & ~almost everyone else) go to many different websites, order forms and sign up areas, etc. that all require me (and you) to repeatedly type in similar versions of the ...
0 votes
2 answers
349 views

EXCEL 2010 all macrobuttons stopped working "Cannot run the macro '*'. The macro may not be available in this workbook or all macros may be disabled."

My many macro buttons were all working perfectly. Suddenly, a while back, they all stopped working, in any workbook, including Personal.xlsb. All my macro buttons refer to macros in Personal.xlsb, ...
0 votes
0 answers
18 views

Having issues running a sort macro in excel

I have a spreadsheet with columns of data. I start a Macro, then sort row B largest to smallest. I copy row A (agent names) and B (sales figures) and paste to another sheet in the same workbook. I ...
  • 1
0 votes
1 answer
87 views

Macro to delete cells highlighted by conditional formatting?

I was looking for a way to automatically remove duplicates in a given range with a macro but all I could find : it's either remove duplicates from a list or remove duplicates from a cell. I thought ...
0 votes
2 answers
247 views

How to assign VBA to a keyboard shortcut in Microsoft Word?

Okay this sounds silly. I am trying to assign a Macro to a keyboard shortcut in Microsoft Word. Let's say I want to assign macro LangUS to a keyboard shortcut I want to assign the macro to shortcut ...
0 votes
1 answer
25 views

Is it possible to map strings obtained by a macro, which contain XML tags, to existing Word styles?

From a macro, I'm obtaining a string like the following: <p>D. W. Arning et al. <i>Mixed Mode–Mixed level Circuit Simulator</i>. (2011). Ngspice. [Online]. Available: http:..., ...
  • 703
1 vote
2 answers
397 views

Is there a way of using a shortcut to jump to the next text box?

For example, I have multiple text boxes on a document, and instead of using the arrow keys to navigate downwards (or the mouse to manually click into the next text box), is it possible for me to use a ...
  • 241
0 votes
0 answers
753 views

Run Excel Macro when Slicer is Clicked

I have a PivotTable connected to a Horizontal Bar Chart. When I filter the content to be displayed in the Chart (by using the Slicer), the Chart did not resize according to the entries displayed. This ...
0 votes
0 answers
57 views

Why does my conditional formatting stop working when I use the format painter to copy from one Excel sheet to another?

I have a macro I created that has worked perfectly for a few months. It copies formatting and conditional formatting from one Excel sheet to another sheet that has raw data. The macro still runs but ...
1 vote
1 answer
153 views

How can I flip (partially mirror) a selection of an image?

I have many pictures. The text in the text balloons is mirrored, or, horizontally flipped. How do I flip this text back so that it is normally readable? Horizontal flipping (or mirroring) of the ...
0 votes
0 answers
55 views

How to create custom Word dictionaries from .CSV files

I work with documents that use a lot of specific words that are flagged by the spell checker in Microsoft Word, such as scientific names of insects. Ideally, I would take data in .CSV format, and be ...

1
2 3 4 5
34