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)

1
vote
0answers
63 views

Macro to change Spellchecker in Powerpoint table text

I found a macro on Change the spell-checking language on a PowerPoint presentation for changing the spell-checker for presentations, however it does not change the spell checker for the text in ...
0
votes
1answer
30 views

app to make shortcuts that will type words

is there some software for windows that will allow me to register a shortcut that will type a certain sentence for example the app runs and when I'm in word/skype/browser and I type Ctrl+Shift+G it ...
0
votes
1answer
15 views

Trying to find/remember an HTML-writing macro (Emacs?)

There was a keyboard macro I saw once for writing HTML (and perhaps XML), so that if you typed something like: a.foo#bar it would turn that into something like: <a class="foo" id="bar"> I ...
0
votes
1answer
3k views

Copy/move values matching a pattern to another column

I have a worksheet where we need to move all the values matching a pattern to different columns. For example, we have a B column with values that are one or more letters followed by one or more ...
0
votes
1answer
145 views

How do I compile word document reports into a single report?

I would like to take several word documents and collate them into one. I'm wondering if there is a way to use templates, form fields, macros, etc to streamline this process. We have several team ...
0
votes
1answer
141 views

Is it possible to automate tasks within a Macro in Excel

I am relevantly new to Macro therefore would like to know if the following is possible; See what it is, I've created a Macro that compares the data on sheet1 to the data on sheet2 and reports the ...
2
votes
1answer
737 views

How to split cell in a row with Excel

I am trying to create a macro to split a cell containing two or more line of characters. I would like to keep the others cells of the row. For example _____________ | | A | |Row 1| B | | ...
0
votes
2answers
832 views

Windows 7 keep computer from idling

I have to work on a corporate computer that has loads of security. I cannot install any programs. I am a software engineer and can write scripts/use command lines. I sometimes need to fix performance ...
1
vote
0answers
255 views

How can I use a modifier key with the Razer Naga?

I have a macro that I wrote with Razer synapse 2.0. I want to trigger this macro whenever I hold down shift and then hit '4' on the side of my Naga. Is this possible to do with Razer synapse?
0
votes
1answer
37 views

Copy a file to my drive on boot

I'm in charge of retrieving some files from lots and lots of computers. I began logging into each one individually and grabbing the file, however, the computers are off when I get them and they all ...
1
vote
0answers
51 views

Intellij setup git macro

I would like to know if its possible to setup a macro for git. I want to be able to shortcut a git workflow : for instance : git checkout b git pull git merge a git push git checkout a
2
votes
1answer
683 views

Microsoft Word: Auto-filling other form elements basing on contents of first one

I'm trying to set up a form in Word that includes several fields that get duplicated in various spots in the document, like First Name, Last Name, etc. I want the user to be able to enter each ...
2
votes
1answer
155 views

Microsoft Word 2003 - Debug loading times?

Loading new and most local documents is fast as hell, but a few specific documents can take up to 10 minutes to load, which is not acceptable. I know that these documents have macros enabled and ...
3
votes
1answer
478 views

link cell text to file of the same name

i have a workbook in excel and in one column i am putting the names of images. i want to create a macro/vba code so that when i type in the file name into the column e.g. IMG_1234 it will ...
1
vote
0answers
768 views

How to Search For Excel (2003) Files which Contain Macros on Server?

How can I search for Excel files that contain VBA code, are there any efficient ways to do this? The way I'm thinking of would be to use vbscript and recursively search through the directory, open ...
1
vote
0answers
102 views

Outlook 2010 Category search

I am looking for a script for Outlook 2010 Categories that will act like Evernote tags. Once you start typing in a search bar it will start displaying the categories that match. Is there something ...
1
vote
1answer
317 views

Word 2010 Macro shortcut using Normal.dotm

I have a macro that needs to be run from the shortcut button. I have added that shortcut in word 2003 & 2010 manually without breaking a sweat. Now in word 2003 if I add a shortcut it got saved in ...
0
votes
1answer
196 views

How do i extract only pages that contain a specific word from a large ms-word document of 500 pages?

I need a way to separate the pages of a word document that contain the word "online" from the pages that do not. I can't figure out a way to do this efficiently without doing a search for the word and ...
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
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 ...
0
votes
1answer
1k views

Windows 7 (script): Create pre-defined folder structure

Is it possible to create a script, which can be activated through the right-click menu in Windows, which will create a pre-defined folder structure? Every time we get a new update at my work I have to ...
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 ...
1
vote
1answer
2k views

Can I create a macro that will offer a drop down menu for subjects in Outlook 2010?

I need the subject line in my Outlook messages to begin with job the message concerns. Since there are about a dozen jobs going on at any particular time, it's cumbersome to either type the job name ...
2
votes
2answers
1k views

In Excel 2007 where do you store macros that you want to use on all sheets that you open?

It looks like you can store it in a file called PERSONAL.XLSB and that will create "Global" (for all worksheets) macros. This file is of course stored in your user profile ...
1
vote
1answer
494 views

Adding a macro to Outlook

There was a question on adding a macro in Outlook 2010 but the answer was a little unclear to me. I want a specific line of text to appear in an email that is sent to a specific group of people ...
2
votes
1answer
641 views

How can I combine values from multiple rows into a single row in Excel?

I have a result in Excel that consists of customer's invoices and payments. The data are on a separate row for every invoice and payment which looks like this: I would like the invoice and payment ...
0
votes
2answers
751 views

Excel macro to extract specific data

I have a spreadsheet with a cell which contains every app on a computer. I want a macro to extract a specific application from the list and delete the rest of the apps and simply display the ...
0
votes
1answer
59 views

Type macro's name in text editor to run it, Is such a thing even possible?

Atm, I'm notepad++ user working mostly on Javascript. And I have a lot of commands that I want to bind to macros. Remember all hotkeys is hard and unpleasant thing. So I wonder is it's possible to let ...
0
votes
1answer
563 views

How can I trigger a macro when clicking a forms toolbar checkbox in Microsoft Word 2002/3?

I've been given a form in Word 2002 that will be used by 2002-2010 users across the organisation which I've been asked to automate. After struggling with hiding the Controls Toolbox toolbar ...
0
votes
2answers
355 views

How can I speed up my macro in Excel 2003?

I have a macro that copies data from one cell to another and uses a VLOOKUP formula, among other things. My spreadsheet contains nearly 2000 rows. When I run it in Excel 2003, Excel starts to slow ...
0
votes
2answers
2k views

Excel sheet with macros - just save the data?

I've got an Excel sheet with some macros built in to grab some data from a database. I'd like to save the Excel sheet and send it to someone, whilst still retaining the data. However because it uses ...
0
votes
1answer
2k views

Auto create folders using Excel field entries

I need to generate folders containing certain Excel field entries: Additionally, I need to append a date to the folder name based on that entry So If I have the above Excel table, I'd need the ...
1
vote
1answer
242 views

Create text file named after a cell containing other cell data

I tried using the code below for the Excel program on my `Mac Mini using the OS X Version 10.7.2 and it keeps saying Error due to file name / path: (The Excel file I am creating is going to be a ...
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 ...
0
votes
2answers
1k views

Move Items per rule after they are one day old

I'm not even sure if this is possible with Outlook's current rule set but I thought I'd ask. I'd like emails that meet certain characteristics to automatically be moved from my inbox after they are a ...
0
votes
0answers
404 views

Microsoft Word 2010 mail merge doesn't work properly with custom macro

I use mail merge to generate letters. These are then merged into one large document which I used to use a splitter for when using Word 2003. Now I am using Word 2010 and when I run the macro it edits ...
0
votes
2answers
4k views

How to enable Record Macro function in Excel 2010?

After adding the Developers tab in Excel 2010, the Record Macro function became disabled. How can I enable it again?
1
vote
0answers
21 views

How to browse a website in an automated manner?

I would like to record a macro (of sorts) where I browse to a certain website, and click around on various things. Then I'd like the macro replayed every so often (based on a schedule). However, ...
0
votes
1answer
3k views

how do you use RunSavedImportExport from a macro

I have yet to figure out all the 'musts' for getting this gem of a macro step to even show up in my macro step drop down. does anyone know what you have to do?
0
votes
2answers
226 views

vim: Change colorscheme for internal shell

I'm using the solarized colorscheme for gvim. I'm using 'light' for normal editing. I want to switch to 'dark' when I invoke vim's internal shell (:sh). Is there a way to do this?
0
votes
1answer
134 views

Autorun Application on startup

i am using Windows 7 with SP1. i want to execute one Application on startup. I can add this program to "Startup" folder, where it will get started on system boot. or Any Startup Managing tools, ...
0
votes
2answers
1k views

Filter data in sheets from a master sheet

I have a 'master sheet' with lots of furniture data in it, in column A there are the suppliers names. What I would like is to be able to have my master sheet with all the info and then sub sheets ...
0
votes
1answer
2k views

Need an excel macro to produce a formatted text file

I am just learning how to make macros and I found a macro that nearly does what I need it to do, which is output a text file from Excel. What I need it to do is output this in a .mhd format, which I ...
0
votes
1answer
3k views

Create a macro in Outlook 2010 to add a simple line of text to the email body

I created this macro in MS Word and it works great but it doesn't work when I copied it into an Outlook 2010 macro. any assistance is appreciated. Sub Thanks1() ' ' Thanks1 Macro ' ' ...
0
votes
1answer
403 views

Excel Single column into rows, VBA script insight

Okay, so much similiar to the below link but mine is a bit different. Paginate Rows into Columns in Excel I have a lot of data in column A, I want to take every 14 to 15 rows and make them a new row ...
1
vote
1answer
7k views

Is there a macro to split the contents of an Excel spreadsheet into separate spreadsheets?

I know there are similar questions out there but I don't think they are quite the same. I have an excel spreadsheet with the following headings- First name -- Surname -- Host Trust -- Contact ...
1
vote
2answers
220 views

Reading macros in an Excel file?

I've got an Excel file (supplied by someone else) that opens with the message This file contains Visual Basic macros. I'd like to look at the macros within the file - they contain code that I ...
2
votes
2answers
240 views

Looking for a simple macro/keyboard shortcut software

I'm looking for a simple software which would do this: When I type in something like dbs and hit tab or enter, it will replace dbs with $this->db->set() in the program that I typed it in. It ...
2
votes
3answers
7k 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
1k views

How do I disable the row/column unhide option in a shared Excel file with vba?

I have a shared Excel file that I need multiple people to work from at once. The file contains some macros that hide certain columns based on the username. 1) check for username 2) hide columns A, ...