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)

50
votes
9answers
136k 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
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?
8
votes
6answers
33k 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 ...
3
votes
1answer
6k 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 ...
1
vote
1answer
1k 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 = ...
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 ...
20
votes
4answers
22k 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.
5
votes
2answers
12k 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 ...
4
votes
2answers
10k 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 ...
3
votes
3answers
11k 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
2answers
7k 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
51 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 ...
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 ...
4
votes
9answers
29k 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 ...
1
vote
1answer
1k 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
1answer
10k 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 ...
2
votes
3answers
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 ...
1
vote
2answers
715 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.
9
votes
1answer
33k 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?
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 ...
3
votes
2answers
2k 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 ...
2
votes
1answer
617 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
2answers
2k 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
3answers
8k 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
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
1k 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
1answer
62 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
2k 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
7k 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
881 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
0answers
44 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
110 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
82 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
0answers
193 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, ...
0
votes
2answers
69 views

Microsoft Excel Macro

I have an excel sheet that contains names (1st row), job titles (2nd row), company/institution (3rd row), and addresses(4th row) in one big column. I am trying to separate them into four different ...
0
votes
0answers
31 views

I need help writing a macro that will check a condition, and then paste a value into a different cell [duplicate]

I want to have a macro that will check to see if a specific value exists in a data range, and if that value does exist in that data range, then I want to past a line of text in a different cell. Could ...
0
votes
1answer
211 views

I need a program that will do a mouse click on the Firefox browser [duplicate]

I need a program that will do a single mouseclick at a certain place on the Firefox browser. Nothing else. It needs to be executable under Windows-XP (an .exe, .vbs, etc.) The mouse click will ...
0
votes
2answers
103 views

How do I associate a shortcut key combination to a macro in Word 2007? [duplicate]

I've created a macro that inserts a reference to a table When I did the macro, I configured the access to this macro through a button. But, now I want to change it to use the keyboard instead of ...
0
votes
3answers
263 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 | | ...