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
99 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
25 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
22 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
283 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
487 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
79 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
118 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 ...
1
vote
0answers
17 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
41 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
141 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
46 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
230 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
333 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
37 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
102 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
332 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
497 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
333 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
347 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
118 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
64 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
47 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
40 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
182 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
343 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
139 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
331 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
262 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
82 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
62 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
660 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
365 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
711 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
502 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
710 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
5 views

My Excel Macro book crash after enable content

I have number of macro workbook. when I open it on VDI network and click on enable content Excel crashes, and I am not able to work. But when I open this workbook on Laptop it works fine. VDI ...
0
votes
0answers
16 views

How do I accept tracking changes for a specific symbols and reject for the rest of the text?

I would like to accept tracked change only for specific symbols like manual line break and break section and reject any other changes. How can I proceed? I guess it should be a macros which looks for ...
0
votes
0answers
15 views

Excel 2010, “Runtime Error '32809': Application-defined or object defined error”

I am having this error when I open up certain workbooks that contain macros. The files are stored on a network drive and this error only happens on a few computers which leads me to believe the ...
0
votes
0answers
11 views

How to Create Keyboard Macro to Adjust Sound Level Momentarily

Basically what I'm trying to do is figure out a way to somehow reduce the sound output level of my system to a certain level (say half volume) and bind that to a keyboard shortcut. Ideally, the volume ...
0
votes
0answers
22 views

Microsoft Excel - Run-time error '1004': Application-defined or object-defined error

I received this workbook from a co-worker. Each time I run the marco I get an error that says "Run-time error '1004': Application-defined or object-defined error". All I believe this marco does is ...
0
votes
0answers
10 views

Automatically adjust row height with text wrap and merged cells

I'm copying text from worksheet 1 which has merged and wrapped cells in the same row, into a cell on worksheet 2, the cell in worksheet 2 is text wrapped and merged with other cells in the same row ...
0
votes
0answers
34 views

Opening Google Chrome with macro instead of IE

I have a question regarding a VB macro that opens automatically a file in IE 11. The problem is I cannot get the download prompting to disappear (believe me, I've tried everything from Tools in IE, to ...
0
votes
0answers
24 views

Need a Word doc “Submit” button which attaches doc to Lotus Notes 8.5 email with defined recipient

I need to create a "submit button" (Macro) at the end of a Microsoft Word document template form. When button is clicked it attaches the document to a Lotus Notes e-mail (we are using 8.5) and has ...