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)

3
votes
0answers
58 views

How to get rid of macro leftovers in Excel?

Old macro workbook from Microsoft samples gallery left items on the ADD-INS ribbon tab, highlighted by yellow: These cannot be deleted or at least I don't know where to find them – see Customize ...
3
votes
0answers
90 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
214 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 ...
2
votes
0answers
30 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
175 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
2k views

Can i stop a blackwidow macro while its being executed?

I'm trying to make a macro for my blackwidow keyboard, which has to be executed until i press a different button. Can anyone tell me how to do this, or how tp stop a macro from being executed halfway? ...
2
votes
0answers
190 views

How to manually edit a macro for replacing a list of characters in Sublime Text 2?

I first tried recording a macro, but instead of recording the character sequence it records my commands and movements without arguments, like this: "args": { "close_panel": true }, ...
2
votes
0answers
66 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
11 views

Convert HTML to Word and embed file hyperlinks as attachments.

I have some HTML files that I'm opening with Word and saving as docx files. I have some macros I run to break the links on the graphics so that they get embedded in the doc file, but I haven't figured ...
1
vote
0answers
22 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
28 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
23 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
23 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
76 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
82 views

How to program a kinesis foot pedal macro?

The manual says that you should press Prgrm+F11, at which point the lights will start blinking (which happens), then press the triggering key, in this case the foot pedal, then the lights should start ...
1
vote
0answers
68 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
147 views

Microsoft Excel Copy one row to another worksheet if cell contains specific data

I have never written a macro in excel before. I am trying to organize my PTAs spirit wear orders for ease of placing the order. I have entered all orders into a master worksheet titled "spirit wear". ...
1
vote
0answers
105 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
178 views

Macro to copy and insert rows by variable number

I have an Excel 2003 worksheet with names and addresses, unique per row, to be used for shipping monthly magazines. Some members receive more than one copy of the magazine, which will be indicated in ...
1
vote
0answers
100 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
52 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
204 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
234 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
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 ...
1
vote
0answers
256 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?
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
1
vote
0answers
771 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
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, ...
1
vote
0answers
339 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
324 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
403 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
367 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
630 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
7 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, ...
0
votes
0answers
13 views

How can a Macro sort dates from oldest to newest?

I'm doing account statements in a bank and I need to be able to make them fast, so I am using macros for making this process. However, there is a step that I always have to do that a macro won't let ...
0
votes
0answers
14 views

Can I write a Macro to export data from Web?

I need to write a macro that can import data from the web (salesforce.com). Is it possible to pull data from the web through a macro? The data I will pull from salesforce.com, is a monthly task. Can a ...
0
votes
0answers
8 views

Script/Macro to print 1st page of 1000 pdf to same printer

I have a folder with 100+ PDF documents each of varying number of pages. I need to print the first page of each document to a printer which adds a VAT code to the document (kind of like an ...
0
votes
0answers
25 views

VBA Excel: Macro working well, add-in does half of the job

I created a macro that: 1.takes the value in cell "D11" then 2.trims the value acording to some criteria, then 3.opens another workbook ans searches the trimmed value then 4.copies some info to ...
0
votes
0answers
32 views

Automation of solver in Excel by VBA macro code

I'm solving a 3rd degree polynomial equation, e.g., -0.003x3 +0.195x2 -1.087x -180 = 0 in Excel. I can do this by SOLVER of Excel and can find the value of x. The problem is the constant term ...
0
votes
0answers
10 views

Open image on specific monitor (trigger with Windows Speech Recognition)

I am using a speech recognition macro to open an Image with Irfanview on my Windows 7 system. What I want to do moreover, is to force any new window emerging due to the macro to open in a specific ...
0
votes
0answers
38 views

Removing an OTF macro from a Razer Deathstalker

I recently bought a Razer Deathstalker, and the other day I managed to activate the OTF macro recorder by accident, so now I have random gibberish and key presses bound to regular keys, so typing ...
0
votes
0answers
17 views

LIBREOFFICE: Macro to convert LTR to RTL selectively. (BiDi issue)

I use Scrivener to write my essay that consists of BiDi text formatting. The sources I quote are in Arabic whereas the commentary is in English. I then export my file from Scrivener to ODT format. ...
0
votes
0answers
36 views

Windows filename formatter BAT script?

At work we upload files for publishing to the web. The filenames people use are atrocious. Is there something easy out there like a .BAT file that they can drag the file on to to have it clean up the ...
0
votes
0answers
30 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 ...
0
votes
0answers
25 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 ...
0
votes
0answers
32 views

Automatic backups (history) in LibreOffice (OpenOffice)

LibreOffice can create a backup copy when you enable it in settings (Options > Load/Save > General), but it saves only the previous state (one only). It has also an versioning feature (File -> ...
0
votes
0answers
109 views

When I saved my excel file xlsm and reopened it, the macro was reported to be correct

I've been learning vba recently and a disturbing question came up to me. I simply tried the message box code: MsgBox("hello world"), and then saved the excel file with .xlsm extension. When I reopened ...
0
votes
0answers
47 views

Force pasted address to show on one line separated by commas

I am pasting addresses into a cell in my document before printing. The cell is wide but not very tall which means when the address is pasted into the cell the bottom couple of lines are not visible. ...
0
votes
0answers
26 views

Macro for hiding table colums, in multipile files, and another on to reverse it

I know almost anything about VBA so I can't really code the Macro that I need for MS Word. I hope that I could get some help here. The basic functionality that I want is to take a Word document with ...