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 [tag:vba] tag instead of this one if the question concerns a Microsoft Office product. This helps the ...

learn more… | top users | synonyms (1)

47
votes
9answers
134k 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 ...
20
votes
4answers
21k 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.
11
votes
8answers
8k 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 ...
10
votes
1answer
3k 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 ...
10
votes
4answers
1k 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 ...
9
votes
6answers
3k 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 ...
9
votes
4answers
3k 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
6answers
32k 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 ...
8
votes
1answer
32k views

In Excel 2013, where are Visual Basic, VBA, Macros, AddIn Tools?

In Excel 2013, where are options and tools such as Visual Basic (VBA), Macros and AddIn tools? Are they supported?
8
votes
3answers
10k 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 ...
8
votes
7answers
35k 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 ...
7
votes
2answers
955 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?
7
votes
2answers
1k 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
2answers
12k 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 ...
6
votes
3answers
1k 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 ...
6
votes
3answers
21k 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 ...
6
votes
4answers
26k 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.
6
votes
2answers
2k views

How do I add “input” to my macro, to replace text in Notepad++?

I'm trying to make a macro with an 'input' pop-up dialog that synergizes with the replace feature. It should go something like: "Paste text->ask for input->replace variable in pasted text with input ...
6
votes
4answers
9k 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 //********************************************************************
6
votes
1answer
14k 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 ...
6
votes
1answer
3k 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 ...
6
votes
2answers
3k views

VBA Runtime error 1004: Method 'OpenText' of object 'Workbooks' failed

After an upgrade to Excel 2010 (from 2003), a script used for standardizing data from Access import has stopped working. It returns an error: "Run-time error '1004': Method 'OpenText' of object ...
6
votes
1answer
383 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 ...
5
votes
2answers
11k 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 ...
5
votes
2answers
18k 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 ...
5
votes
1answer
156 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 ...
5
votes
2answers
554 views

Use keys for mouse buttons on linux. Alternative to AHK?

On 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 ...
4
votes
9answers
26k 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 ...
4
votes
2answers
1k views

Need to split stereo track, discard right channel, and remove noise

I'm using Audacity to process some short audio clips - about 300 of them (!!!), so I'd really rather not repeat my steps manually for each one. However, I can't seem to find a way to create a chain ...
4
votes
4answers
13k views

Switch speaker configuration between stereo and 5.1 using shortcut

I'm trying to find a console command or utility that will let me 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 ...
4
votes
3answers
1k 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 {, ...
4
votes
2answers
325 views

Keyboard macro software

I'm looking for a super-simple free keyboard macro program. Does not need to "automate" anything just send some keystrokes when a key is pressed. Ok, not just letters some arrows and enters.
4
votes
2answers
2k views

tool to record windows action?

My boss give me a job to record some hundreds script manually, it would break my fingers...is there any free tool for recording and playback windows' mouse and keyboard action?? I am on win xp. The ...
4
votes
3answers
8k views

How to execute Outlook 2010 macro with AutoHotKey?

Having found that I can't bind custom keyboard shortcuts to macros I've written for Outlook 2010, I turned to AutoHotKey and have a working solution, but it's clumsy. Here is one script and I have two ...
4
votes
3answers
4k views

How can I split Excel data from 1 column into 8 columns while keeping the data in a specific order?

I need to maintain the order of the data. So to explain I need to move the data from cell a1 to b1, a2 to c1, a3 to d1, a4 to e1, a5 to f1, a6 to g1, a7 to h1, a8 to i1, a9 to B2 a10 to C2 a11 to ...
4
votes
1answer
1k views

How do I create an Excel Macro to output key/value pairs to file?

I have two columns as key/value pairs and want to export them to a file in the structure key=value (to create a properties file). I tried this script: Sub Properties() Dim FileName As String, i As ...
4
votes
1answer
1k views

Excel 2010 Macro “Command could not be completed by using the range specified”

Running a macro on an Excel spreadsheet, I get the Run-time error: 1004 Command could not be completed by using the range specified. Selected Debug and the highlighted code is: ...
4
votes
1answer
5k 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 ...
4
votes
3answers
3k views

How can I get Visual Studio 2008 to align my assignment operators?

I had this in Vim and miss it dearly now that I'm confined to Visual Studio. I'd like to take this: MyType type_obj = new MyType(); MyLongerType longer_type_obj = new LongerType() To this: MyType ...
4
votes
1answer
297 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 ...
3
votes
3answers
749 views

Is there a way to set the name box of a cell programmatically in Excel

I would like to programmatically set the name box of a cell in a worksheet I'm working on, either through a formula or through a macro. The end point is that I don't want to set it by hand. In my ...
3
votes
1answer
376 views

Send an email when computer restart

I want to receive an email from PC everytime it restart. I think about adding EXE file - which send an email - to windows schedule. but I don't know how I write one. any other ideas?
3
votes
2answers
488 views

How can I keep every fifth row in Excel

I have a data set in excel with 3084 rows. I need to delete 4 rows, then keep one: deleting Tuesday, Wednesday, Thursday, Friday but keeping Monday to create a weekly rather than daily data set. ...
3
votes
2answers
7k views

How to break a spreadsheet containing CSV into multiple columns?

I'm working on preparing data for export, and the client has put all of the data into a spreadsheet. Each field of data should be its own column. The problem is that the client erroneously put ...
3
votes
2answers
90 views

macro keystrokes via input file?

I am thinking of writing one up but i'll ask first. Are there any apps that will do keystrokes to an application via an input file? i have a list of 1400 keystrokes i need to do. Basically its 4 ...
3
votes
3answers
905 views

How can I strip macros from an Excel workbook so that I can upload and edit it on SkyDrive?

I don't have any access to MS Office, but SkyDrive for personal use is proving great for my basic edits, but as soon as somebody sends me a workbook containing macros, which I don't need, I can't ...
3
votes
2answers
1k views

Subscripts and superscripts in Excel

I have an XL sheet with chemical formulae - which is basically just letters with numeric subscripts and superscripts. I can save as an html page and get the <sub> and <sup> html elements, ...
3
votes
2answers
428 views

Get first and last value from range in a spreadsheet using other column's data for filter criteria

I have data in my spreadsheet in a worksheet like this: Where the data goes in this format [ID] | [Date] | [Hour] | And I have another worksheet where I want the data to be like this: Where I ...
3
votes
1answer
6k 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 ...
3
votes
2answers
573 views

Excel 2010: Save current tab as tab delimited txt file

I do most of my stats in R, thus I know nothing about Excel macros and must ask for help. My institute provides MS Office 2010 (currently), so I use that to do quick edits to my data sets, then I save ...