Skip to main content
New
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs

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
18 views

Different clipboard contents for multiline strings in Excel cell vs. Notepad

This question is related to the familiar issue of copying multiline strings out of Excel cells [1, 2]. I used this solution (64 bit version in the comments) to create a Macro that edits the clipboard ...
bankpainmedia's user avatar
0 votes
0 answers
14 views

The mouse keeps moving by itself when I'm using a macro program in RDP sessions

my case is the following: I have 10 VPS RDP sessions open on my computer at the same time. On each VPS I am running a Macro Recorder program (an autoclicker) that performs automated activities. This ...
Mercadão do Jeans's user avatar
0 votes
0 answers
46 views

How can I prevent / correct Excel groups of checkboxes size and position changing after reopening the file?

I use grouped checkboxes (formular controls) in Excel sheets for the purpose of diagnosis. One sheet is uses as template and I copy the sheet as I need a new diagnosis with a macro. There is a known ...
Thomas Karg's user avatar
0 votes
0 answers
46 views

How to keep a constant number of line on a page after a macro modify the sheet

I am working on a page to list mechanical part and all the possible variations of components of that part, some of this have more than 21 lines. When I use the macro the lines with value 0 are removed ...
Gabriel's user avatar
0 votes
0 answers
18 views

Assigning Excel add-in macros to ribbon using a relative path

I am trying to create a basic Excel GUI for a Python software which uses Excel spreadsheets as inputs. I have managed to create a basic add-in with a macro which runs the Python code for me. To make ...
Sorade's user avatar
  • 101
1 vote
1 answer
15 views

Running a multiple word search macro in Word

So I'm running this macro to find and highlight multiple words at once. However, I want to set it to find only whole words as it currently finding letters within words and highlighting them. For ...
James's user avatar
  • 11
0 votes
0 answers
40 views

How to search the web via context menu with quotation marks using only mouse?

I often drag an English phrase and search it in Google or Bing with quotation marks to find the exact expression. Dragging with the mouse, right-clicking shows me a context menu of "Search 'the ...
user67275's user avatar
  • 2,072
0 votes
0 answers
52 views

Excel: Insert Copied Cells and pasting values only ... some of it

I'm looking for an excel expert here and what I'm asking may not be possible. Originally, I was looking for a macro to allow me to paste values after performing an insert copied cells and shifting ...
Kevin Rodriguez's user avatar
1 vote
1 answer
78 views

Excel - put login times into neat hours

I have this info in an excel spreadsheet .. representing the amount of time spent logged in to a computer.. logins time of day amount of time logged in (h:mm) ------ ----------- ---------------...
Andyjmr's user avatar
  • 13
0 votes
1 answer
66 views

Removing Content Control Quick Part in Microsoft Word

I have a VBA macro that will auto populate a document with content control quick parts that have blocks of text with other content controls within them. I'm attempting to write a VBA macro that will ...
churchizactiive's user avatar
0 votes
0 answers
30 views

New to MacOS and trying to replicate a few things that I already do using Autohotkey on windows

Below is my Autohotkey script that automatically copies the text of any questions that I ask on the websites for ChatGPT, Gemini, and Claude (I have them installed as chrome apps) by detecting the ...
Varity Colgate's user avatar
-1 votes
1 answer
43 views

MS Access 2016: How to delete a macro?

I use Access of the Microsoft Office Professional Plus 2016 package. I played a little bit with the Creation of Macros. I safed a macro named "Makro1". Now I want to delete that Macro, ...
Mario's user avatar
  • 1
0 votes
0 answers
32 views

Mentions affecting Regex Validation

I was wondering if anyone came across the issue with Regex validation in Microsoft Outlook when including mentions (i.e.,@Tony or @Jodie). The below code works fine when there is no mentions in the ...
churchizactiive's user avatar
3 votes
0 answers
92 views

How to bind USB control knobs to adjust the volume on specific applications?

I want to control the volume level of 2 specific Windows Applications using my USB piano's control knobs (Spotify Premium & discord). FIRST TRY - AutoHotkey. The KeyHistory does not detect any ...
Dominic Marchese's user avatar
0 votes
0 answers
18 views

Inserting Today's Date In A Cell If Other Cell Values Are Changed or Added using VBA

So I have this spreadsheet that I share with my Team, and I'm looking for a way to have a Today's date put in a cell, everytime there's a change in the worksheet. I found this coding, which is working,...
Marta Hoffmann's user avatar
2 votes
1 answer
125 views

Notepad++: Creating a macro replacing selected text

I need a Notepad++ macro that will perform search and replace, but for the portion of text that is highlighted at the moment of running the macro. I tried recording a macro, but it records for the ...
Krz's user avatar
  • 23
0 votes
0 answers
33 views

Excel Macro: Pasting Values from Sheet into a Table Error

I am trying to copy data from worksheet "Project Summary Data" and paste it into a table on worksheet "Project Cost Report Summary". I am very new to Macro's, so I am unsure of ...
Shayne's user avatar
  • 1
1 vote
0 answers
135 views

How to run a Word macro from the command line?

I'm trying to save and close all open Word files (to start I only target one of them). The macro I made works when ran from Word (clicking "Execute"), but it won't run when called from the ...
TryingToLearn's user avatar
0 votes
0 answers
31 views

Macro for compressing/expanding formulas in Excel [duplicate]

I have looked for a while but haven't come across something that does what I am looking for. I'm not that proficient in writing macros and if this isn't possible I will find a different solution to my ...
Skrobbit Johnson's user avatar
1 vote
1 answer
271 views

Macro for using Goal Seek over a range of cells

I'm trying to automate the GoalSeek function over a range of cells. Each cell in Columns I and J calculates a quantity of interest using two different methods, and the results must agree. Each cell in ...
Alan's user avatar
  • 11
0 votes
1 answer
92 views

Libreoffice macro has infinite loop

Can someone point out what's wrong with this macro please? I'm trying to search for paragraphs with the token "vv", then change their paragraph style to "_Verse". This macro works ...
Paul B.'s user avatar
  • 69
0 votes
0 answers
32 views

Microsoft Word Global Templates Loaded from SharePoint?

I have a Macro Enabled Template I use to store my Macros and I wanted to share them with my company without having to duplicate the document on everyone's computer or changing the file path in the ...
churchizactiive's user avatar
0 votes
2 answers
125 views

Use a Macro or Formula to replace a single letter with a string of text

This should be pretty simple. I want to use a formula or macro that will automatically replace a letter with a string of text within the same cell. Ex.: If I type the letter "r" in Cell A1 I ...
Christopher Stanesa's user avatar
0 votes
0 answers
54 views

My windows excel icons are same for .xlsx and macro enabled .xlsm files

I'm running Microsoft Office Professional Plus 2016. The macro enabled .xlsm files, used to have an exclamation mark in their excel icon. For some time now, all type of excel files have the same ...
Sakis's user avatar
  • 43
0 votes
0 answers
19 views

How to break a paragraph with footnotes via \autocite{} into sentences in nVim?

This question is similar to the one asked here. I'm trying to figure out how to break paragraphs written in a TeX file in Nvim so that: any sentences with a citation (i.e. \autocite[][]{}) after them ...
notkerus's user avatar
-1 votes
1 answer
288 views

Footer page numbering restarting when using continous sections

I am using MS Office 365. I have created a Word Form, with page numbering in the footers. Some of the pages have continuous sections in them (to enable a signature line to be in an unprotected section,...
Shenoa Gittins's user avatar
0 votes
0 answers
50 views

How to edit/create settings/shortcut/macro for enabling reversed text input direction in Windows 10?

I want to create a hotkey for the ability to insert a character without advancing the caret, i.e. write backwards. Every search I tried on Google related to this functionality is of how to disable it, ...
Wicky's user avatar
  • 1
5 votes
1 answer
559 views

Making it so users that do not have macros enabled cannot see other sheets

I am working on a project that wants all users to have macros enabled. It is a shared sheet so I cannot simply hide everything as a baseline and unhide the sheets when Open_Workbook is ran. My goal is ...
Thomas Wohllaib's user avatar
0 votes
1 answer
105 views

Identify columns having mix of Dr and Cr values

I have an Excel file where columns E to BB have amount values, the cells of which are formatted using Custom Format as either ""0.00" Cr" or ""0.00" Dr" I want ...
AllSolutions's user avatar
0 votes
2 answers
144 views

Excel macro to split the date and time in one column to two separate columns

The code created by the macro works just fine, but looks clumsy. Can anyone assist in cleaning this up so that I can learn to make the recorded macros cleaner going forward? Sub SplitDateTime() ' ' ...
Iron Man's user avatar
  • 103
2 votes
1 answer
50 views

Separately color all rows for unique clients listed in one column

I am a relative Excel noob, and to that end, forget about Excel macros. I'm here because this seems to be where the GOATs congregate, and I really need some help. I have an enormous data set that ...
alm's user avatar
  • 23
0 votes
2 answers
528 views

How to handle protected view errors in Excel VBA macro

Introduction. I have a local website, and one of its pages is used for downloading an Excel report by several users on their PCs. The file is automatically generated with some data from our database ...
Garry Gorn's user avatar
0 votes
2 answers
259 views

How to add a keyboard shortcut for a macro in excel

I want to add a custom keyboard shortcut for a Macro (to zoom in and out) in MS Excel. It works very well with Word thanks to this answer, but on Excel (at least with Version 2310 that I'm running) ...
ludicrous's user avatar
2 votes
1 answer
149 views

Notepad++ Recording a Macro with searches in it

I'm using Notepad++ to edit a calendar ".ics" file. I've used simply macros before but can't get this one to work. I need to find the text "cancelled", then go back 6 rows (ok so ...
GrahamK's user avatar
  • 23
1 vote
1 answer
364 views

LibreOffice Calc Basic search and replace macro

I am attempting to create a LibreOffice Basic macro for use in Calc that when invoked in an open spreadsheet file will open a second spreadsheet file that contains two ranges, (the first range ...
JCB's user avatar
  • 173
0 votes
1 answer
49 views

Macro to keep 3 rows visible under the selected row in LibreOffice Calc

In Calc or MS Excel when one is finished editing a cell in a row, pressing Enter leads to the next row below. Keep doing that and eventually you arrive at the last row visible on the screen. Here when ...
Shakir's user avatar
  • 103
0 votes
0 answers
380 views

How to get live data from a website in Excel

I want to get the price of an item from AliExpress in Excel. For example, this item. I modified the URL to get the specific product variant using this. I found this to get the name and price of the ...
John Doe's user avatar
  • 107
0 votes
0 answers
77 views

How do I automatically generate colour styles in LibreOffice Calc using VBA?

I want to be able to run a macro to automatically create a set of named styles that change the cell background colour. I tried this, but it doesn't work: REM ***** BASIC ***** Sub ...
skeetastax's user avatar
0 votes
0 answers
236 views

Execute Macro via USB device

I want to execute a macro via hardware, and not software. Ideally being OS-independent. Here are some ideas that I've had and how far I got on each of them: Pre-programmed Mouse. Since the macro will ...
Cyber's user avatar
  • 1
0 votes
0 answers
34 views

Looking for common solution to validate Excel reports (ETL)

I'm trying to more efficiently validate financial reports generated in Excel. Currently, a user generates around 300 reports in Excel using different Sheets in each. These reports use extensive ...
Iqbal's user avatar
  • 1
0 votes
0 answers
300 views

How to wait for Web Query to complete in Excel VBA Macro

I have an Excel file that uses an API to lookup some data from a website. It is built using the standard "Get Data from Web" built in PowerQuery feature of Excel. I run a macro to update ...
techtheatre's user avatar
0 votes
0 answers
32 views

Copying a specific range of cells form multiple worksheets in a work book to a Summary Sheet

I have data on 28-31 different worksheets based on the month. the data is goes from B23 to J33. I need to copy and paste those cells from each tab to a Summary tab.
Kevin Trippel's user avatar
1 vote
0 answers
14 views

Trying to update ranges in macro to not have set range

I am trying to update my macro to where the set ranges in the macro are not hard coded because when the data for the new data set is ran the data range may be smaller or larger. How do I update my ...
Coco's user avatar
  • 11
0 votes
0 answers
123 views

Excel macro requests access to an external file: removing dependencies

I download an Excel file and I copied the sheets (I tried also to maintain only the main sheet; figure below) and the macro in a new Excel file; when I try to execute the macro, this message appears: ...
Gennaro Arguzzi's user avatar
0 votes
1 answer
859 views

Word macro: Insert text into each selected cell of a table

I am trying to format cells and insert text (in this case a checkbox) in each SELECTED cell in a table. This is used as a place keeping aid in my plant emergency procedures. The cells format properly, ...
Rokbottoms's user avatar
0 votes
0 answers
69 views

Copy range of row using two dropdown list as start time and end time in Excel

I have list of data that fetched from SQL at defined time range: At that image I also already make dropdown list named Start time and End time. The question is: how can I make a macro that the output ...
Romy Prazhad's user avatar
0 votes
0 answers
21 views

Creating a formula on Excel for my table

I would like to create a formula that will auto update when more information is added to my table and when numbers change. I have created a table that shows how many licences I have and their annual ...
Loren Webb's user avatar
0 votes
1 answer
559 views

Designer button grayed out in macro-enabled presentation in PowerPoint. How to fix it?

I don't know if it's a bug or a “feature”, but if you're creating a macro-enabled presentation in PowerPoint the designer button is grayed-out. As usual the Microsoft website is very “useful”. This is ...
Paulo Santos's user avatar
0 votes
0 answers
27 views

How can I use a macro to create a new excel spreadsheet with values only and formatting (including results of conditional formatting)

I have written this macro to unprotect an existing worksheet, copy the data from the existing worksheet, open a new spreadsheet, paste the data to the new spreadsheet with values and formatting, then ...
OWalker's user avatar
0 votes
0 answers
20 views

How to change all caps text to normal case with the first word capitalized in sentences in PhraseExpress?

How do I get all caps to normal text? These are the codes that I've tried & how they've turned out. Some work & some don't. Also, I'm somewhat new to PhraseExpress so this is all a whole new ...
Shae Clark's user avatar

1
2 3 4 5
36