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,764
questions
122
votes
14
answers
393k
views
How can I control the master volume in Windows?
Some keyboards have volume controls on them that can be pressed anytime to control the master volume. My keyboard does not have that. Is there a way that I can create a key macro that will work like ...
56
votes
17
answers
380k
views
Copy Excel worksheet and maintain relative cell reference in formulas
Another copy problem in Excel:
How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes =[...
49
votes
4
answers
107k
views
How can I record macros for Autohotkey? [closed]
I used a macro recorder for AutoHotkey in the past, but now I can't seem to find it at all.
How can I record macros for Autohotkey?
48
votes
1
answer
26k
views
How do I assign a keyboard shortcut to recorded macro in Sublime Text
I have a bunch of macros which I have recorded and saved in Sublime Text 2. I'm trying to assign keyboard shortcuts to each of those, but I'm kind of lost as to how to go about doing this,
I had a ...
46
votes
8
answers
274k
views
How can I stop Excel from opening a second blank window when opening a file from Explorer?
When I open an Excel file from Windows Explorer, I always get a second Excel window as well. Annoyingly, when I close it, it doesn't close, but the other window does!
This seems to be a common issue:
...
35
votes
8
answers
21k
views
Mapping Super+hjkl to arrow keys under X
I'm trying to map:
Super+h -> Left
Super+j -> Down
Super+k -> Up
Super+l -> Right
globally under X. The idea is I don't want to leave my home row that often to use the arrow keys, so I'...
32
votes
5
answers
171k
views
Can I make an Excel VBA macro available to all workbooks?
Is it possible to write a VBA script in one workbook, and use it in other workbooks in the machine? I guess I'm looking for a way to write a macro package.
EDIT
Following the instruction in the link ...
28
votes
10
answers
53k
views
Is there a Win7 shortcut to position mouse in center of primary screen?
I have a three monitor set up on Windows 7 and I sometimes lose track of where my cursor is. Is there any Windows shortcut to reset the mouse position? I'm guessing there is not, but might there be a ...
23
votes
7
answers
95k
views
What's a good macro recorder for Windows? [closed]
I'm looking for a tool that can record everything I do with my mouse/keyboard and playback recorded sessions. I've found some softwares that can replay macro using a script but none that can also ...
20
votes
3
answers
44k
views
How to inspect / view an Excel macro before "enabling macros" for a sheet?
I'm receiving occasionally an xls file that contains a macro which I should use. If I don't have complete trust in the sender, I wish to look at the macro's source in order to verify that it indeed ...
19
votes
3
answers
42k
views
Can I search and replace in a Notepad++ macro?
I'm trying to create a macro in Notepad++ that allows me to do a few standard Search & Replaces. I can get the macro to do everything (add lines, add characters) except search and replace.
I can'...
18
votes
10
answers
135k
views
How to turn hundreds of text URLs in Excel into clickable hyperlinks?
How do I turn a column of urls into hyperlinks, so that users can click on the url in a cell and have it open in a browser?
I pasted 100 urls and each went into its own cell. When I double-click in ...
17
votes
4
answers
7k
views
vim: Continue macro after error in submacro?
I'm in the process of beautifying some source code using vim. {1}
I've created a couple of vim macros that do the individual steps: removing trailing whilespace, removing empty lines after {, ...
17
votes
2
answers
11k
views
How to cancel recording a macro in Vim?
Imagine I had recorded a macro and then I've occasionally started recording a macro into the same register. Can I interrupt the recording so that the original macro is preserved in the register?
I ...
15
votes
3
answers
104k
views
How can I delete rest of the line after a specific string?
I'm looking for a way to search for a specific string e.g. '=UUID:' and delete it and all following characters per line. I would prefer a way/macro/addon for notepad++. But all other tools or scripts ...
14
votes
4
answers
4k
views
vim macro to convert CamelCase to lowercase_with_underscores
Is there a vim macro to convert CamelCase to lowercase_with_underscores and vice versa?
12
votes
5
answers
75k
views
Record a macro of windows commands
Using Windows 7, is there an in-built or third-party method of recording windows commands and being able to play them back?
As a very basic example of what I would like to be able to do, imagine ...
12
votes
5
answers
4k
views
Is there any way to save a keyboard macro in bash?
I would like to permanently save a keyboard macro that I've recorded using C-x ( and C-x ). Is there an easy way to "see the source" for my newly recorded macro so that I can bind it to a keyboard ...
11
votes
10
answers
69k
views
Keyboard macro to change default audio device
Windows 7, Logitech G110 keyboard
2 audio devices (headphones and speakers)
I am hoping to find a quick way to macro a key to switch to headphones, and a key to switch to speakers.
Anyone have a ...
11
votes
2
answers
24k
views
A good keyboard macro program for Ubuntu? [closed]
I'm looking for a good keyboard macro program for Ubuntu Linux?
I want to easily be able to "start recording" have it record all keys pressed. Then when I stop recording save it. then I want to be ...
11
votes
3
answers
47k
views
How to make Outlook font sizes bigger in the reading pane?
If you use outlook, you may have noticed that there is no default way to permanently and unilaterally change the zoom (font size) in the reading pane. If you click on a message, it will be defaulted ...
10
votes
3
answers
33k
views
How to find document variables in MS Word without using a Macro
I have document with some document variables in and I'm trying to use those variables in the document. But since the variables are set by an external system (which is not well documented) I'm playing ...
9
votes
2
answers
8k
views
Shortcut or macro for changing font type in Microsoft Outlook
Is there a keyboard shortcut for changing the font in Outlook on Windows? I have to alternate between Calibri and Courier constantly for technical reasons and clicking on the font dialog every time ...
9
votes
5
answers
86k
views
Select an entire column minus header row in an Excel macro
How would I access a range that corresponds to an entire column starting at row 2 (there is a header row)?
The end of the selection should be the last non-empty cell in the column.
9
votes
1
answer
26k
views
Word: Resize Image by Percent - Macro
I routinely paste many screen captures into Microsoft Word 2007 and then have to manually resize them to around 75%, which becomes very tedious.
The screen captures are all different sizes.
I've ...
9
votes
4
answers
22k
views
How do I create a Macro/short cuts in Eclipse?
How do I create a Macro in Eclipse?
For example: I want the combination alt+s will print on the page
//********************************************************************
9
votes
6
answers
8k
views
Use keys for mouse buttons in Linux. Alternative to AHK (AutoHotkey)?
In Windows I have an AutoHotkey script which:
Only works when caps lock is on
Generates left, middle and right mouse button events when left control, menu and alt keys are pressed
Allows holding the ...
9
votes
2
answers
45k
views
How do I get a macro to run in Outlook 2010?
I've written a macro for Outlook and would like it to be run from a button which is visible whenever you compose an email. As such, I've added a button to the Quick Access Toolbar pointing to the ...
9
votes
4
answers
7k
views
Is there a way for elegant source code listings in OpenOffice.org Writer?
I have tried to insert source code as listings in OpenOffice.org Writer, but it just doesn't work in an acceptable way.
If space is not enough for an line, it breaks that line automatically into the ...
8
votes
4
answers
3k
views
Macros in GNU screen?
I use the screen command line program in Linux all the time, and I looked through the man page but didn't find the answer to this (although maybe I just missed it):
What I want to do is have a single ...
8
votes
1
answer
9k
views
Use a Python function as formula in LibreOffice Calc cells
Since LibreOffice Calc supports macros, and the builtin functions are somewhat limited, I'd like to write my own functions in Python and then use them as formulas in individual cells. Ideally, I would ...
8
votes
1
answer
3k
views
Can Vim autocommand be triggered by filetype instead of by pattern?
I know how to set up features using :autocmd for specific file extensions:
Eg. ~/.vim/ftplugin/xml.vim
augroup xml
au BufEnter *.xml call Setup_XML_Menu()
au BufLeave *.xml call ...
8
votes
1
answer
14k
views
Gimp record actions
I would like to execute some actions in Gimp and then apply this actions again to a new version of the file.
Is it possible ?
Edit: I would like to crop (and center the rest), resize. Maybe change ...
8
votes
2
answers
3k
views
Is there a way to turn off popups in Notepad++ macros?
I created a macro in Notepad++ that cleans up imported data through a series of regex search and replace iterations. This works well, but at each step, I get a popup telling me how many instances ...
7
votes
5
answers
5k
views
Can I retrieve and access a simple JSON object via HTTP in LibreOffice Calc?
I've located a web API resource that I'd like to access from LibreOffice Calc.
It returns a simple JSON/JavaScript object that's basically just a handful of name value pairs, one of which I want to ...
7
votes
2
answers
9k
views
What is Macro worksheet in Excel?
I have Excel 2013. To access VBA I accidentally pressed Ctrl+F11 instead of Alt+F11 and a new worksheet named ‘Macro1’ was created. This looks like an ordinary worksheet but the default column width ...
7
votes
1
answer
21k
views
Is there a way to have an outlook 2007 email template automatically update the subject with the current date?
I send out an email every morning in a specific format.
To = The same group every day
Subject = "Scrum 25-SEP-09" (replace the date with the current date)
Body =
Yesterday:
- <what I did ...
7
votes
3
answers
9k
views
Does Atom provide a Macro functionality like Notepad++ has?
I am thinking about switching from Notepad++ to Atom. Does Atom provide a Macro functionality like Notepad++ has?
6
votes
4
answers
6k
views
vim: delete all lines but unique?
I am looking for a way in VIM to delete all lines that are duplicates and only leave unique lines that exist in the file. I would prefer a macro but a command or function would be great.
Say I have ...
6
votes
4
answers
32k
views
How to fill a large series (over 10,000 rows) in Microsoft Excel without dragging or selecting cells?
I have more than 10,000 rows of data I need to do some calculations on one column of the data. I have made the calculation in one cell and now need to fill the formula for the calculation and all the ...
6
votes
4
answers
42k
views
How can I record a macro on the fly with Black Widow Ultimate?
I believe that Black Widow Ultimate can record macros on the fly. However, they are recorded with a delay in the time you take to press the keystrokes by default. Is it, in fact, possible to do this ...
6
votes
6
answers
32k
views
Switch speaker configuration between stereo and 5.1 using shortcut
I'm trying to find a way to quickly change speaker configuration between 5.1 and stereo in Windows 7; anything that I will be able to make a shortcut of on the desktop for quick access.
The issue ...
6
votes
4
answers
7k
views
Beep or make a sound upon Cut, Copy, Paste
I have autohotkey installed in my windows 10. How can I have it "beep" or make a sound whenever I Cut, Copy or paste something.
I'm working on a huge record which involves cutting-copying-...
6
votes
2
answers
10k
views
Using English macros in French version Excel
I am currently in France and am using a computer on which all Office programs are in French.
I need to use a Macro which has been written in English VBA, but it fails.
I assume the issue a language ...
6
votes
1
answer
82k
views
Find and replace multiple values within selected cells
I want to run a find and replace on multiple values within a range in excel with values from 2 columns: A with the original word; B with the translation. I already found the VBA code to get this ...
6
votes
3
answers
70k
views
Excel data into PowerPoint slides
I have already found some helpful sites but I'm still unable to do what I want. My Excel file contains few columns and multiple rows. All the data from one row would be in one slide but data from ...
6
votes
2
answers
6k
views
Why notepad++ plugins don't work in macro?
Why don't Notepad++ plugins work in a macro? For example:
Manual run plugin - Converter -> "ASCII -> HEX"
AAAA 4141414120
BBBB 42424242
CCCC 43434343
Runned as recorded macro
AAAA 4[nul][dc4][...
6
votes
1
answer
244
views
How do I Stop the Excel Macro Recorder from Auto-Wrapping Lines of Code?
When recording a macro in Excel (2007) the recorder will often wrap the lines of code if they get to long by using a "_" character. This is all well and good except that there is apparently a hard ...
6
votes
1
answer
7k
views
Custom keyboard shortcut for macros in Outlook 2010?
I have a suite of macros that I used to have linked to buttons in a custom toolbar in Outlook 2007. Using the & encoding I could assign keyboard shortcuts to those macros (e.g. &1 to make Alt-...
6
votes
1
answer
610
views
Word 2007 macro gone
I have programmed a little macro for text search in Word 2007.
I tried to install it on other accounts in our company with very strange results. On two accounts it worked like it should.
On other two ...