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)

0
votes
1answer
694 views

How can I create a toolbar button that applies a thousands-separated number style in OpenOffice.org Calc?

In OpenOffice.org Calc I very often want to format numbers with a thousands separator. How can I create a toolbar button to do this? Via the menus, the appropriate format can be applied with Format ...
1
vote
1answer
423 views

Excel: Why use an XLA and not just a blank XLS?

Someone has put lots of Macros in blank XLS documents, and now someone has aked me to put them into an XLA document. Why and for what purpose? The Macro's loop through opening workbooks and ...
0
votes
1answer
848 views

Excel Macro: compare separate workbook lists and LINK to the data in a corresponding column?

1. How can I compare two matching lists from separate workbooks? And then retrieve the data from the same row but another column - (Index&Match maybe be appropriate for this). But how does this look ...
2
votes
1answer
2k views

How to delete macros from an Open Office document?

How to delete macros from an Open Office document?
0
votes
3answers
3k views

Excel VBA/Macro: how can I delete rows and remove dots & dashes?

I've recently been handed an Excel file to format - 100's of lines. The image below shows you the state of it. This could be a really long exercise if I work through it manually, so I wondered if a ...
0
votes
1answer
517 views

Enabling macros in a word file

How do we enable macros in a MS Word document. Assume i have a document with many questions and answer choices. I am not able to see the correct answers. I found a suggestion like enable macros in ...
0
votes
2answers
291 views

getting started with macros programming in word 2007 [closed]

I just came to know that macros in word/excel/powerpoint can be programmed. That is awesome because I've a word document with 70 tables for styling. I'm a programmer but I don't know VB or VBA or VB ...
1
vote
2answers
972 views

Remove Excel 2003 macros easily

I am using Excel 2003 and I have some workbooks that I have to send several days a week to some recipients. These workbooks have macros in it and I don't want the people receiving the file to be able ...
2
votes
2answers
902 views

Excel Macros 2007: How can I Bold the Row if a number is in Column A?

My long list of data has numbers in Column A, but in random rows. How can a macro be written to find a number in Column A and then bold the corresponding data in that row? I know if I record my ...
9
votes
6answers
54k 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
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 ...
0
votes
2answers
676 views

Remap the eject key to an arbitrary sequence of keys on Mac OSX

KeyRemap4MacBook seems to not be able to do this.
2
votes
2answers
226 views

Windows Automation Tool

I need any tool to automate my daily work in windows with dialogs. I've google it and found few tools, but i don't know anything about they. Please advice me
1
vote
3answers
23k views

How do I get an Excel macro to copy data from a specific column and the same row that is selected at activating macro?

Example: I have selected any row and any column, let's say D6. The data I am looking for is in column H. So, I want the macro to copy the data in row 6, and column H, i.e. H6. If I have selected G14, ...
0
votes
2answers
2k views

Backing up Excel Files to a different Directory

In Excel 2007 in the Save As box there is an option to 'Create a Backup' which simply backs up the file whenever it is saved. Unfortunately it backs up the file to the same directory as the original. ...
0
votes
1answer
627 views

Windows keyboard macro playback software?

Many years ago, I had a product called Quickeys for the Macintosh that allowed me to record keyboard and mouse events and create a macro that could be assigned to a keyboard accelerator. This was a ...
1
vote
1answer
451 views

Can I write an Excel macro to find product info based on a SKU?

My coworker wants to create an invoice template in Excel 2007. In column 1, he wants to be able to put in a SKU like '000293954'[1], and when he hits tab, have the other columns fill in a matching ...
0
votes
1answer
833 views

Insert set of fields/document properties automatically

I'm fairly new to Word 2007. (Coming more from a Linux/text editor background.) Each time I create a document within Word 2007, I add a set of details to the start of the document. It's the same ...
2
votes
2answers
3k views

excel autocomplete combo-box with on-selection event

I have an excel sheet for groceries. One column is the name, another is whether to buy it or not (checkbox) and another is the amount. I'd like to have a widget in the top row so that I start typing ...
1
vote
2answers
4k views

Shortcut keys not working on Windows 7 Ultimate x64

yesterday I installed Windows 7 Ultimate x64. The problem is that I have some programs on the quicklaunch and I want some of them to be opened by hitting a shorcut key. Well, the procedure to set it ...
2
votes
3answers
4k views

Keyboard macro program for OS X

I am after a program to complete a series of key presses automatically, with next to no involvement from a human. Basicly, I want it to hold down the spacebar, whilst pressing Y a couple of times, ...
0
votes
3answers
272 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 | | ...
1
vote
4answers
2k views

How to prevent truncation of 0 in Excel sheet?

I am copying tabular data from a website: [http://www.infodriveindia.com/TradeResources/STDCode.aspx?STDCode=&City=&State=andaman][1] But it pastes the numeric value by truncating the ...
2
votes
3answers
889 views

Save and restore multiple layers within a Photoshop action that flattens

I'm editing comic pages with layers - "background", "foreground", "lineart" and "over lineart". I have a Photoshop action that includes a Mode->Bitmap command, which requires the image to be ...
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 ...
8
votes
3answers
36k 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 ...
12
votes
7answers
53k 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 ...
2
votes
1answer
814 views

Outlook 2007 VBA/Macro

I am a very amateur user new to macros and VBA. My problem is that I recive online orders to which I need to click an auto generated unique order hyperlink to confirm receipt of the order within a ...
0
votes
2answers
2k views

Automatically empty a folder on Mac OS X

I'd like to find a way to automatically move all the files from the Downloads folder to the trash. Ideally I'd like to trigger this with a keyboard short cut. How should I try this - Automator ...
1
vote
1answer
2k views

How do I write a macro in Outlook 2007 to move an item out of my Inbox to another folder and marke it as unread?

I would like to have a macro in Outlook 2007 to move selected items to sub-folders of my Inbox, marking them as unread as I go. This way I can assign buttons to move items quickly to my deal today and ...
1
vote
2answers
368 views

Capturing and parsing xterm cut buffer in emacs

I'd like to make an indirect control for Emacs (in Ubuntu Linux) so that I can swipe some text in an xterm with the cursor, cutting it into the X cut buffer, then run a macro in Emacs to parse the ...
14
votes
6answers
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 ...
7
votes
3answers
2k 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 ...
3
votes
2answers
95 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 ...
1
vote
1answer
2k 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?
2
votes
3answers
4k views

“macros have been disabled” message in Word 2007 but no macros

I open a .doc file in Word 2007 (sorry I am unable to supply the .doc) which pops up with a message above the document "Security warning: Macros have been disabled" but there are no macros shown in ...
66
votes
9answers
198k 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
2answers
2k views

Interacting w/ Graphs Using VBA in Word 2007

I have a long MS Word 2007 document, in which I occasionally need to replace all of the embedded graphs. The changes are simple enough and regular enough that I could probably write a VBA macro to ...
1
vote
1answer
773 views

Outlook, Word, and normal.dot (2003 Edition)

I have one user that for some reason has been having macro issues with her normal.dot file. At first the fix was just remove the file because she isn't actually needing to save anything. This was ...
3
votes
3answers
3k views

Macro that disable / enable sound device in Windows 7

What should I use to program that kind of Macro ?
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 ...
2
votes
2answers
411 views

A mouseclick every 15 seconds

I want to create a macro that fires a right click every 15 seconds (30 clicks in total. What kind of software would you recommand for a macro like that?
6
votes
1answer
18k 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 ...
0
votes
2answers
1k views

a windows keyboard macro recorder that is FAST to use?

I want to hit some hot-key, type away, hit another to stop recording. then hit a third hotkey to select the sequence to replay. Opening an editor and typing a script is too much overhead to save any ...
2
votes
2answers
9k views

A good keyboard macro program for Ubuntu? [closed]

I'm looking for a good keyboard macro program for Ubuntu Linux? I want to easily be able to "start recording" have it record all keys pressed. Then when I stop recording save it. then I want to be ...
7
votes
5answers
41k 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.
0
votes
1answer
291 views

Always show toolbars in Word 2003

I have a custom toolbar associated with some VBA macros in Word 2003. I want this toolbar to alway be visible, independent of the doc or template open. Is there any way of doing it?
1
vote
4answers
12k views

How to filter an Excel column for entries matching a master list

The general question entails sorting a large Excel 2007 list to find entries that match smaller subset list. I have a couple of ideas on how to approach the problem, but I lack the technical ...
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
158 views

How to set Visio 2003 Trusted Locations

I see the option in Visio 2003 to only trust macros stored in trusted locations, but I can't find any way to set up what these trusted locations are. My problem is I have a template file that's not ...