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 the [vba] tag instead of this one if the question concerns a Microsoft Office product. This helps the ...
27
votes
7answers
85k views
How to control master volume in Windows 7?
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 ...
9
votes
6answers
2k 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 ...
12
votes
4answers
10k views
Where can I find a macro recorder for Autohotkey?
I used a macro recorder for AutoHotkey in the past, but now I can't seem to find it at all.
1
vote
2answers
3k views
Automate mouse button click with script or macro
I'm searching for a script or macro program which pushes the 4th or 5th mouse button every 5 seconds.
This script or macro program is for a friend who uses Windows 7 on an Asus notebook. I cannot try ...
6
votes
1answer
1k views
Creating special commands for Notepad++ using NppExec
Notepad++ has a convenient timestamp facility built-in with the choice of short or long formats, but both use the built-in date format of the computer they're on, showing either the month first (if ...
1
vote
1answer
278 views
How to force Excel to treat dates in CSV as text in a macro
I have a macro that lets the user select a CSV file and then manipulates it. However, it treats cells that contain things like 1/2/12 as a date. I need to keep these strings as text, not dates.
I ...
2
votes
3answers
2k views
Get Excel 2007 to close completely after creating a macro in the personal macro workbook
I created a few macros in Excel 2007 and I saved them in the personal macro workbook.
Since then, I've deleted the macros. Note: You have to unhide the workbook, delete the macro and then hide it ...
1
vote
2answers
293 views
Auto start Notepadd ++ Macro
Is there a way to auto start a Notepad ++ Macro? I have a macro created but I want it to auto start when Notepad ++ starts.
1
vote
1answer
6k views
Importing CSV files into Excel using a macro
I'm want to develop a macro where in my excel worksheet I type a date in a specific cell, and the macro will go into a folder containing text files. A database you could say. I want it to find the ...
2
votes
1answer
3k 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 ...
2
votes
1answer
663 views
What do you use for linux keyboard macros? [closed]
I've tried IronAHK and xbindkeys. Xbindkeys was ok I guess and ironAHK didn't compile. Just wondering if there's better. Maybe something to where I could set emacs-like bindings when certain programs ...
2
votes
1answer
546 views
In Excel, I pasted in a bunch of URLs, but they aren't live links — how do I bulk convert them to live links?
In Excel, I pasted in a bunch of URL's into a column.
However, they aren't live links after pasting.
How do I bulk convert them all to live links swiftly?
2
votes
2answers
1k views
Why notepad++ plugins don't work in macro?
Why notepad++ plugins don't work in macro? For example:
Manual run plugin - Converter -> "ASCII -> HEX"
AAAA 4141414120
BBBB 42424242
CCCC 43434343
Runned as recorded macro
AAAA ...
1
vote
1answer
749 views
Prevent Excel 2010 user from pasting formatting into cell
Is there a way to lock a cell so that a user can copy/paste a value into it, but not copy formatting to it? Locking the worksheet doesn't prevent the user from changing the formatting of the cell by ...
1
vote
4answers
2k views
How can I avoid the clipboard message box when copying large amounts of data in Excel?
I have a macro that is copying 4 sheets from one workbook to a new workbook and saving it down with another name.
Unfortunately the message box asking me whether I would like to make this large ...
1
vote
1answer
445 views
Preventing a confirmation pop-up when updating fields in Word
In Word 2007, an obvious candidate for updating all the fields in a range is
myrange.Fields.Update
But if the range is the element of ActiveDocument.StoryRanges corresponding to the footnotes, ...
1
vote
2answers
1k views
What is the best multi-application macro tool for windows?
I used to use Texter as a program to create text macros that can be used in any application, e.g. so you can type "sigg" followed by the space bar and it would replace the word with your signature ...
0
votes
3answers
242 views
Apply a formula to particular cells in Microsoft Excel
Say I have the following sheet:
| A | B | C |
1 | 5 | 1 | 5 |
2 | 8 | 8 | 99 |
3 | 77 | 3 | 3 |
4 | 2 | 7 | 4 |
5 | | | |
6 | Base:| 2 | |
...
