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 [vba] tag instead of this one if the question concerns a Microsoft Office product. This helps the ...

learn more… | top users | synonyms (1)

4
votes
0answers
100 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 ...
3
votes
0answers
33 views

Terminate the Access macro after a specific time

I am running several MS Access macros from a batch file. The macro runs several queries in AccessDB. Things are working fine. But, I want to add a check. If a macro runs longer than a specific time, ...
2
votes
0answers
30 views

Converting Multiple .doc files to searchable .pdf

I have a batch command file that runs daily converting data extract files to .txt, .doc, and then to .pdf formats. I run a series of formatting macros in Word on the .txt file before saving to .doc ...
2
votes
0answers
1k 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 ...
2
votes
0answers
286 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
500 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
80 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
48 views

Excel 2010 - Combine specific sheet in >200 separate files into single worksheet?

I have tried solutions in other posts like this and so far nothing has worked :/ I have >200 separate excel files, and essentially I would like a specific sheet from each of these files combined into ...
1
vote
0answers
138 views

run time error 1004 method open of object workbooks failed

I have this issue on one single PC only, and the error relates to opening an Excel workbook based on a macro-enabled template (xltm). Xltx files work fine. (Macros are enabled on this troublesome PC)...
1
vote
0answers
18 views

How can I set Microsoft Word up to change any text encapsulated in `backticks` to monospace?

I wish to be able to type `simple code` in between backticks as shown, and have Word automatically change the font to some monospace variant. I am aware of alternatives such as LaTeX, but would like ...
1
vote
0answers
43 views

VBA is disabled in Excel Home and Student 2010 (on XP SP3)

Everything seems to be working fine with Office, except that in Excel the VBA/Macro functionality is disabled. I cannot launch the editor, all macro-enabled files are interpreted as corrupt and the '...
1
vote
0answers
164 views

How to paste from Excel with VBA macros (xlsm) to PowerPoint (pptx) without warning

I teach using a combination of Excel and PowerPoint. I use an Excel workbook with a helper macro that makes it easy to display a cell's formula adjacent to that cell. I don't think it's directly ...
1
vote
0answers
48 views

MS Word, can we write a multilingual regular expression?

I want to find all the occurrences of the from x.y and change it to x,y where x and y are numbers: I was using this: ([0-9]).([0-9) and doing the replace using \1,\2 but here is the catch , if the ...
1
vote
0answers
249 views

Complete site rip of a website using wget

I am attempting to perform a complete site rip of a website, I know where the streamed videos locations are however getting the process to run as efficiently and productively is proving difficult. ...
1
vote
0answers
468 views

How to make Outlook font sizes bigger in the reading pane?

If you use outlook, you may have noticed that there is no default way to permanently and unilaterally change the zoom (font size) in the reading pane. If you click on a message, it will be defaulted ...
1
vote
0answers
23 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
39 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
106 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
380 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
516 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
340 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
377 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
124 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
65 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
50 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
42 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
32 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
105 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
185 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
351 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
141 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
338 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
265 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
83 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 tables....
1
vote
0answers
65 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
113 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
24 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
690 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
366 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
723 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
507 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
714 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
18 views

Apply formula to cells with data

Is it possible to apply a formula to cells with data without using macros? For example, user enters "A3 A6 A8" in a cell, and then it applies UDF "CONCATENATEREF()" to that cell that gets those ...
0
votes
0answers
22 views

How to use macros/VBA in Excel to copy/paste 3 portions of a large column of a workbook to a specific position in another workbook?

I am very new to VBA (know next to nothing about how to code in it) but have a basic understanding of how coding works. I am curious if anyone could help me with a script idea I have to automate ...
0
votes
0answers
11 views

List Sort with New Rows - Excel Macros

I am trying to record a macro that sorts my list, but am currently at a wall - I need this sort to adjust to my list depending on adding/removing rows. My current code scans the list for which cell ...
0
votes
0answers
15 views

How to auto-update exports of a document?

Assuming I have a document Report.docx which gets frequently updated and has exports as say Report.pdf and Report.md. How do I adjust Word to automatically update the PDF and Markdown-Versions of the ...
0
votes
0answers
8 views

assistance on one of your macros

I used one of your macros and was wondering if it's possible to alter accordingly for my use. the macro you advised is as follows: Sub PrintCopies_ActiveSheet() Dim CopiesCount As Long Dim ...
0
votes
0answers
32 views

MS Word Macro to change string to Numbers in long documents?

I am as beginner as it gets with VBA and macro. I am looking to record a macro for MS Word documents that converts string to number. For example the document will have like (one thousand and four) or (...
0
votes
0answers
13 views

Office Templates (with macros) in CrossOver Office 2010

I have a very specific problem. I am a policy debater, and I'm trying to install a Word template called Verbatim http://paperlessdebate.com/verbatim/SitePages/Home.aspx on my Chromebook for ...