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 ...

learn more… | top users | synonyms (1)

71
votes
9answers
221k 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 ...
2
votes
3answers
7k views

How do I transpose data in columns to rows?

How do I transpose data in columns to rows? If the data is: Joe some city some state Bob no city no state and I use Paste Special » Transpose, I get Joe some city some state Bob ...
5
votes
2answers
33k 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 ...
5
votes
1answer
27k 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 ...
3
votes
1answer
2k views

How to configure a hotkey/shortcut to activate a macro in Outlook 2007?

Is there a way to configure Outlook 2007 so by pressing a [CTRL]+[letter] combination, a macro is activated?
26
votes
4answers
47k views

Where can I find a macro recorder for Autohotkey? [closed]

I used a macro recorder for AutoHotkey in the past, but now I can't seem to find it at all.
10
votes
7answers
59k 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 ...
2
votes
2answers
56k views

Trigger macro with ONE click on specific cell

Would you mind pointing a way to start a macro in Excel 2010 by clicking only once on a specified cell? I had seen a solution somewhere, but now I can't trace it back.
4
votes
8answers
23k 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 ...
1
vote
1answer
2k views

Lookup and return value based on sub-string match

Is there a formula or script that will match sub-strings from one column in another column and return the full value of the sub-string match? e.g. Input COL_a COL_b name ...
0
votes
1answer
11k views

Macro to copy distinct values from one Excel sheet to another

I have an Excel workbook that has the following sheets, "Main" and "Count": Now the "Main" sheet has the column B with list of IDs. Is it possible to have a macro on "Count" page to copy all ...
14
votes
7answers
6k 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'...
19
votes
8answers
23k 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 ...
3
votes
2answers
15k views

Custom macro buttons without writing code?

I just upgraded from Word 2003 to Word 2010. I'm mostly OK with the Ribbon, except that I've spent years maintaining and enlarging several custom toolbars full of buttons for extremely specialized ...
2
votes
2answers
5k views

How can I compare two columns in Excel to highlight words that don't match?

(I'm using Microsoft excel 2010) OK, lets say I have a list of phrases in both column A and column B (see screen shot below) What I would like to happen whether it be with a macro, VBA or formula ...
2
votes
2answers
13k 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 ...
2
votes
1answer
541 views

How do I debug Excel / OpenOffice / LibreOffice macros - getting started

How do I get started with debugging VBA macros? This is to help to locate faults and mistakes within the code and the data it handles.
1
vote
1answer
365 views

How to create multiple rows combining data sets

I have three tables and i need an out put which has data from two tables, i would like to create the same using macro. Table A A B C D Table B Apple Orange Pears Table C Americas Asia Europe ...
1
vote
1answer
3k views

Remapping keyboard keys for specific applications [closed]

I want to be able to remap keys for specific applications so that those keys can execute macros. I don't want the remap to be global. What are the best programs for this?
1
vote
1answer
49 views

MS word: a macro to turn ON/OFF some proofing settings

What macro could turn ON/OFF some proofing settings? (Unfortunately macro recording doesn't record the setting change) I'm looking for a way to turn ON/OFF 2 proofing settings (at the same time): ...
0
votes
1answer
53 views

Duplicate rows based on its data

I have an excel file which I'll use to import hundreds of products in an e-shop. The excel have columns like this Title | SKU | Size | Price | etc I asked my clients to make the excel in very ...
0
votes
1answer
275 views

Clever way to connect multiple images to on-click macro - VAB Excel

I have asked this question before, but admittedly in a terrible way, so I am asking this again. So here I am once more. I am making a program in VBA Excel - or better, combining a certain worksheet ...
31
votes
1answer
12k 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 ...
8
votes
1answer
7k 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 U....
4
votes
2answers
12k 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 ...
2
votes
1answer
27k views

Importing CSV files into Excel using a macro

I 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 ...
1
vote
1answer
3k 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 ...
0
votes
2answers
1k views

Create a shortcut for Notepad++ to reopen a closed tab?

To reopen a closed tab in Notepad++ you press ALT+F&1. I was wondering if there was a way to make a macro or program to do this so that I can press link it to the shortcut CTRL+SHIFT+T instead, ...
4
votes
4answers
3k 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 ...
2
votes
1answer
3k views

Excel 2010 macro to separate a large data file into workbooks

I found some code which works perfectly to separate a file based on a column (line 31) into separate tabs within a worksheet. I just need it to separate the files based on a column into a separate ...
1
vote
2answers
2k views

Auto start Notepad++ macro

Is there a way to auto start a Notepad++ macro? I have a macro created but I want it to be run automatically when Notepad++ starts.
0
votes
1answer
2k views

Hack for running multiple iMacros in random fashion

I have 20 iMacros (for browser) and they are specific to different URLs. I run these macros one after another, and then repeat or loop all of them 10 times. But within that loop, i need those 20 ...
0
votes
2answers
142 views

Find and replace {0,} occurrences in Word

Are there any alternatives to the concept {0,} which is not allowed in MS Word? For example, if I wanted to replace, by a single abbreviation, the next five terms: articul articulo articula ...
5
votes
2answers
3k 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][...
5
votes
3answers
10k 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 ...
3
votes
1answer
1k views

Creating automatic links in OpenOffice

Are there any macros for OpenOffice that enable certain words to automatically be replaced with hyperlinks? Every time I type the word "google" in OpenOffice, I want the word to become a hyperlink to ...
3
votes
1answer
2k 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, ...
2
votes
0answers
1k views

How to enable Razer BlackWidow macro keys on Windows without install Razer Synapse?

I found out how to enable Razer BlackWidow macro keys on Linux, and I want to enable them on Windows as well, without installing any Razer driver. Please help me. I want use macro keys with ...
2
votes
1answer
2k 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
1answer
6k views

Copying data from multiple word docs into one excel sheet

I have about 4000 doc and docx files which contain a table. I've managed to import these into one excel sheet using the following script: Sub Macro1() Dim xl As Object Set xl = CreateObject("...
2
votes
1answer
2k 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 ...
1
vote
1answer
7k 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
1answer
8k views

How to select radio buttons by cell value in Excel?

I have a group of radio buttons with labels in adjacent cells. How can I arrange for the radio button with the label matching a target cell value to activate? Here's an equivalent example to what I'...
1
vote
4answers
18k 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
3k views

outlook automated reply with unread message count

I get hundreds of daily emails and I'm looking to configure an out of office reply for outlook which will inform the recipient that I have X unread emails and that I'll get to theirs as soon as ...
1
vote
1answer
9k views

How do I copy hyperlink only (and not text) to another cell? [duplicate]

I have a spreadsheet where column A displays names. There are a few hundred names and each has a different hyperlink (which links to that person's web page). I want to transfer those hyperlinks across ...
1
vote
1answer
1k views

Excel: How to extract group of the same rows and their values into columns?

How can I extract the second table from the first one? I need to extract those titles that have exactly three costs (in the following example: f1 and f3). I tried using pivot tables but could not ...
1
vote
2answers
297 views

Chart macro displaying incorrect labels from non-sequential visible rows on filtered worksheet

This macro displays text labels from the source worksheet when double-clicking a dot on a scatterplot chart. The chart is updated when the source worksheet is filtered on any of several columns. The ...
0
votes
1answer
37 views

Mass Find and Replace for Pictures Macro - Microsoft Word 2013

I have this macro that is able to do a mass find and replace across multiple word documents. I am able to do a find and replace for pictures (within a header) but when I implemented it within my macro ...
0
votes
1answer
719 views

VBA Macro to sort and apply conditional formating to a range of cells with dynamic number of rows

I have a range (the image below). Please note that: Range is generated by another application, so number of rows is ever changing, and is not formatted as an Excel 'table' The number of columns, ...