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

learn more… | top users | synonyms (1)

62
votes
9answers
176k 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 ...
1
vote
3answers
5k 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 ...
4
votes
1answer
17k 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
1k 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?
23
votes
4answers
32k 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.
9
votes
6answers
47k 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 ...
5
votes
2answers
21k 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 ...
2
votes
2answers
4k 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 ...
1
vote
1answer
4k 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 = ...
10
votes
6answers
5k 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 ...
6
votes
2answers
21k 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 ...
13
votes
8answers
16k 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
3answers
13k 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 ...
1
vote
1answer
106 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
2answers
11k 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 ...
0
votes
1answer
120 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 ...
8
votes
11answers
60k 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 ...
8
votes
1answer
6k 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 ...
3
votes
2answers
8k 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
17k 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
2k 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 ...
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
27k views

Excel 2010 VBA - 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.
1
vote
2answers
1k 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
516 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, ...
5
votes
3answers
9k 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
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 ...
3
votes
4answers
14k 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 ...
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
2answers
2k views

VBA to move specific data from one column to another

I've tried requesting help with this before but have received no helpful responses. I need a Macro/VBA that moves any word in red from column A into column C as a list. However if the same word is ...
2
votes
1answer
1k 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
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?
1
vote
2answers
174 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 ...
1
vote
1answer
665 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
1answer
292 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
1k views

Find and replace multiple words in a column in Excel 2007

Sub xLator2() Dim s1 As Worksheet, s2 As Worksheet Dim N As Long, i As Long Dim from(), too() Set s1 = Sheets("Sheet1") ' contains the data Set s2 = Sheets("Sheet2") ' contains the translation ...
1
vote
1answer
5k 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
0answers
656 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 ...
1
vote
1answer
5k 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
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
4answers
12k 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
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
1answer
48 views

(Subscript out of range) Error 9

Below is a modified version of a code (i found on Stack Exchange) that I am currently using - Option Explicit Sub Main() Columns("E:E").NumberFormat = "@" Dim i As Long, c As Long, r As ...
0
votes
5answers
88 views

Can I run this Macro faster? [duplicate]

I am using this macro for over 1000 entries. The code itself works the way I want it to. Option Explicit Sub DoTheThing() Dim keepValueCol As String keepValueCol = "H" Dim row As Integer row = ...
0
votes
4answers
4k views

Combining all combinations of data from three columns in excel

I have a few columns of data that I would like to combine, and get each unique combination. Concatenating across a row or set list is easy enough, but I would rather not have to enter each possible ...
0
votes
0answers
1k 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
362 views

Split single column data into multiple columns based on leap year in Excel 2013

I have about 100 files of MS Excel which consist of weather data. I need the data on yearly basis but the file has a single column with data of about 140 years and manually copy-paste is very time ...
0
votes
1answer
206 views

VBA Code De-bugging in 2010 excel

Looking for some help in debugging some old VBA/Macro code to work in the newer version of MS Excel 2010. The macro in question is the "Material Rollup" function. The purpose of the macro is after ...
0
votes
1answer
10k views

hide/unhide rows based on cell value [duplicate]

Based on a cell value = true or false, I conditionally formatted rows to turn black. That means that I need to scroll down to find the set of rows that did not turn black. I would prefer that all my ...