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)

3
votes
0answers
93 views

Is there a FOSS macro somewhere that will convert tabs to the spaces up to the next tab mark?

Would like to ensure text documents don't get mangled by badly behaving email clients on smart phones that mangle tabs, so would want to convert tabs to the number of spaces up to the next tab mark in ...
2
votes
0answers
39 views

Open link at cursor position with keyboard shortcut

I'm using a rich web application that replaces my browser's right-click context menu with a menu of custom options. I want to be able to open a link in a new tab and right-click doesn't work for the ...
2
votes
0answers
239 views

Resizing window in Word 2010 on Windows XP

Two macros I have, one to size down a Word window down to 20% of the RH side of the screen, and the other to 80% on the LH side, have stopped working. (They are for reference files while I work on the ...
2
votes
0answers
397 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?
2
votes
0answers
73 views

Why are some options unavailable when recording a macro in Word 2007?

I am trying to create a macro that works with images in Word 2007. The problem is that when I start recording my macro I can't select some options, such as the one surrounded by a red border in the ...
1
vote
0answers
15 views

Word 2013 - insert “intelligent” field

I have a word document with several sections and every section has a unique header. I need to insert a field containing the revision date, and as it is now I need to insert the date in all the ...
1
vote
0answers
31 views

Macro to change font in email, dependent on which email account is being used

I have several different email account for different companies I work with, and each one has a different corporate font for emails. Anybody got any ideas how to quickly change this over when ...
1
vote
0answers
152 views

Excel VBA that calls Powershell ActiveDirectory cmdlet, but Module won't load?

I have a powershell script I use to dump user and computer lists to csv files; it works great and I don't want to touch it much. It uses the ActiveDirectory cmdlet, and the Get-ADComputer and ...
1
vote
0answers
28 views

How to replace fonts of some characters as typing in Microsoft Word 2013

I want to replace fonts of digits and some other characters automatically as I type in Microsoft Word 2013 (something like word Auto-correct option). How can I do this by Macros?
1
vote
0answers
65 views

MS Word 2010 - How do I create a universal macro that will auto-insert a header if none exists?

I'd like to create a macro enabled template that will automatically insert a header into a document if none exists. This is in order to work around a printing issue that cuts off the top of the ...
1
vote
0answers
109 views

How can I open a PDF to a certain page from within excel?

I would like a macro code for Excel 2013 that will open up a certain page upon clicking a button in the excel cell. I am using the below code, but it is working intermittently. Please help with a ...
1
vote
0answers
240 views

Macro to copy multiple rows from one worksheet to another and then copy the headings into copied columns

I am new to macros and I have developed this macro that allows me to take rows that has data in them from cells B-G from Workseet "master 1" starting from row 11. I take this data and then copy it ...
1
vote
0answers
384 views

Reset Numbered List with Text Style VBA macro MS Word

I'm trying to make a VBA macro to create a Word document from Excel... Currently I'm having issues with setting up the Lists properly. I want the list indexes linked to my 2 header types. Like so: ...
1
vote
0answers
243 views

run-time error 1004 Application Defined or object-define error

I have this macro that I wrote: Dim lastColumn As Long lastColumns = wkbWorkbook2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'this is the highlighted part in debug SourceRange.Copy ...
1
vote
0answers
165 views

Deploy macros and ribbon button - Outlook 2010

We need to deploy macros across our organization, along with a shortcut button up on the ribbon, in Outlook 2010. Right now, the way we're slated to do this is by copying over and overwriting the ...
1
vote
0answers
85 views

MS Word 2010 macro to renumber pages within the footer of all sections.

My problems is that I also have a divider page which originally I provided -1 in the page field to get the appropriate count. Could you please advise how I can manipulate the macro to take this back ...
1
vote
0answers
51 views

How can I make emacs ignore bell when recording macros?

Currently, emacs will halt the recording of a macro when the bell rings. This is extremely useful for things like halting when C-s fails to get a new match. However, when I'm recording a macro, and ...
1
vote
0answers
33 views

Outlook Macro not firing

My macro was working fine the other day, but as of today, it does not. I have not changed the program, nor the code, nor updated via Windows Update. I use Kaspersky. When the user clicks send, it ...
1
vote
0answers
87 views

AHK Gui button working as a toggle?

I have been searching for a while now on how to make a GUI button work as a toggle for a simple loop. I'm stumped and need help. Here's my code. #NoEnv #SingleInstance force ...
1
vote
0answers
29 views

Use two keyboards; One for macros?

I'm wondering if it is possible to actually use another keyboard as a set of "macro keys"? I have searched a lot online for this, and nowhere can I see that it is possible. Do you know of something ...
1
vote
0answers
30 views

Is there a program to move the mouse according to an svg?

Basically, I want a program that will look at an svg, then 'act' it out on a set canvas. For drawing.
1
vote
0answers
600 views

Splitting an excel 2010 spreadsheet into multiple workbook files based on column value

I find and clean a lot of contact data, sorted by country, which I am currently using excel to manage. Mainly because it is easier to clean and manipulate the data I find this way, and I can easily ...
1
vote
0answers
137 views

Is there a macro to filter table by some list elements?

I have a table with entries based on a list and I used a macro I found somewhere to be able to add/remove multiple elements from the list to one cell, let me show you an example: TEST TABLE test1 ...
1
vote
0answers
101 views

Splitting Excel file but retaining lookup data and formulas

I have a master expenses file that has a page for each employee summarising their expenses. The employee sheets run off a hidden data sheets. I want to send each employee a copy of their expenses ...
1
vote
0answers
137 views

How to use Windows key in Autohotkey as part of a macro

I have been using autohotkey on a terminal with 122 keys. I remapped the keys so that their original funky uses are now much closer to normal modern computers. I also mapped a scancode to Windows ...
1
vote
0answers
611 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
0answers
209 views

Pasting and re-sizing a screenshot

I often take screen shots of random drawings and i want to re-size them using a macro. I want the macro to automatically paste the screenshot then re-size it to fit to a height of 5.9 inches and a ...
1
vote
0answers
99 views

Using Macros for Automatic Formatting in Word?

We're trying to create something that will allow us to copy lines from a technical document which is unformatted and in font X, and paste them into a form or into something that will produce it in a ...
1
vote
0answers
273 views

Runnning macro when specific text is entered on Word

How can I make a macro that does something whenever a specific text is entered on Word. Can you give me a simple example of a macro that, for instance, is run every time some text is entered between ...
1
vote
0answers
251 views

Display Macros on a Microsoft Keyboard?

I am using IntelliType Pro (v8.2) with a Sidewinder X4 keyboard. Is there a way I can display the macro names and assigned macro keys on screen? For instance if I press a macro key that is not ...
1
vote
0answers
73 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 ...
1
vote
0answers
59 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
1
vote
0answers
1k 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
107 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
0answers
23 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, ...
1
vote
0answers
515 views

Refreshing Crystal Reports through Excel Macro

At work we have an ancient Ingress database that wont allow me to make links between tables using the SQL Query editor in Excel 2007. My current solution is to generate the data in Crystal Reports, ...
1
vote
0answers
348 views

When replying to email in Outlook 2010, how do I get it to automatically select the account I want it to send to? I have multiple accounts

I have multiple accounts and want to get outlook 2010 to automatically select the account it uses to send my reply emails - based on whatever email address is indicated in the "TO:" field for that ...
1
vote
0answers
600 views

Timed/Periodical automatic uploads to DropBox?

I'm wondering if there are any tools/apps out that allow you to; select a specific set of files/folders -> select a specific time (every 3 hours for example) -> automatically upload/sync the selected ...
1
vote
0answers
451 views

Macro security disabled in Outlook 2007

All radio buttons under "Macro Security" in Outlook 2007 are greyed out. I am the admin in that Win 7 system and I have not been able to figure how to enable them. Because of the macro security, I ...
1
vote
0answers
679 views

Gimp batch processing on the Mac?

I am looking for a way to batch apply auto-brightness, auto-contrast, and a dash of colour correction to a pile of images with Gimp. I found a the David's Batch Processor (DBP) plugin but can't ...
0
votes
0answers
13 views

Disable right click on tab

I am attempting to build a secure workbook where the user cannot print or copy the contents of any of the sheets/tabs. I've been able to provide security for all but copying a sheet/tab to another ...
0
votes
0answers
4 views

How to batch-convert MS Word 2003 files from Letter to A4, and change margins to 20 mm at the same time?

I was looking at this answer, regarding how to batch convert MS Word 2010 documents from Letter (US) format to A4 (International) format: How to batch-convert MS Word files from Letter page size to ...
0
votes
0answers
14 views

Need help creating Macro in outlook 2013

Here is a copy of my code for my macro that I created in word but I can not get it to work in outlook. I need a macro that puts the phrase "Here is your order confirmation. Please let me know if I ...
0
votes
0answers
10 views

open excel using .bat when excel error “file in use” is returned

I have created a .bat file to open Excel, then my Excel workbook which contains a macro which runs on open, all on a scheduled task timer. The problem is that occasionally the Excel files are not ...
0
votes
0answers
28 views

Filename path in Word vba macro is unable to find building block.dotx file saved in network drive

I have a building block that I am using a vba macro to implement. The macro pastes a building block header into a section of the word document. The pasting of the building block works, when the ...
0
votes
0answers
24 views

Find and replace by a single dot several series of two dots attached to the end of words

I want to replace every series of two dots in a document by a single dot, excluding the cases where there are three dots in a row, i.e., the written ellipsis (...). Yet, the series of two dots always ...
0
votes
0answers
28 views

Combining all combinations of data from 8, 9 and 10 columns in excel

I'm attempting to figure out how to run all possible combinations for data in 8, 9 and 10 columns (each on different pages) and would love to have a macro for each. Below is a macro for three ...
0
votes
0answers
24 views

Clear find result in notepad++ with keystrokes or plugin

I'm trying to find a keystroke or plugin (that I could assign a hotkey to) to do the following: Focus the "Find Result" window (I know the F7 key does the focusing, but I think it's also a toggle) ...
0
votes
0answers
10 views

Macro to reference tagged objects on other slides

I am wondering if there is a macro that could automatically update slide references for objects on other slides. For instance, let’s say there is a table on slide 20. I want to be able to place a text ...
0
votes
0answers
44 views

Excel 2010 Macro throws Object or Method Not Supported error

I keep getting an error 438: Object doesn't support this property or method when trying to run a portion of a macro I have that updates three PivotCharts off of the top three items on another table. ...