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
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 ...
Phenom's user avatar
  • 6,627
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 =[...
Jake's user avatar
  • 2,059
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?
Karsten's user avatar
  • 898
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 ...
Sathyajith Bhat's user avatar
  • 61.8k
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: ...
Deanna's user avatar
  • 1,174
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'...
William Casarin's user avatar
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 ...
bavaza's user avatar
  • 573
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 ...
tehDorf's user avatar
  • 997
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 ...
Guillaume's user avatar
  • 778
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 ...
GJ.'s user avatar
  • 9,843
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'...
Konerak's user avatar
  • 1,893
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 ...
kacalapy's user avatar
  • 595
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 {, ...
DevSolar's user avatar
  • 4,490
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 ...
Alexey's user avatar
  • 383
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 ...
nixda's user avatar
  • 27.2k
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?
Neil G's user avatar
  • 432
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 ...
Antony's user avatar
  • 736
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 ...
mgalgs's user avatar
  • 2,382
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 ...
user avatar
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 ...
Arthur Ulfeldt's user avatar
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 ...
user287352's user avatar
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 ...
some user's user avatar
  • 203
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 ...
juz's user avatar
  • 91
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.
Dave's user avatar
  • 267
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 ...
cantera25's user avatar
  • 193
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 //********************************************************************
Itay Moav -Malimovka's user avatar
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 ...
typist's user avatar
  • 91
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 ...
Richard's user avatar
  • 6,088
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 ...
user avatar
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 ...
dirtside's user avatar
  • 1,051
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 ...
Superbest's user avatar
  • 1,990
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 ...
njd's user avatar
  • 11.2k
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 ...
Charles's user avatar
  • 245
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 ...
Excellll's user avatar
  • 12.7k
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 ...
hippietrail's user avatar
  • 4,573
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 ...
rajeev's user avatar
  • 1,646
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 ...
rmontgomery429's user avatar
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?
Michael S.'s user avatar
  • 4,057
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 ...
7null's user avatar
  • 153
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 ...
Ramana's user avatar
  • 211
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 ...
Martinos's user avatar
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 ...
Fanis Hatzidakis's user avatar
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-...
JMS's user avatar
  • 61
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 ...
user294589's user avatar
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 ...
WouterB's user avatar
  • 185
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 ...
nqw1's user avatar
  • 235
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][...
oobe's user avatar
  • 61
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 ...
Xantec's user avatar
  • 2,459
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-...
Ramon's user avatar
  • 113
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 ...
user48604's user avatar
  • 543

1
2 3 4 5
36