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)

-1
votes
0answers
22 views

Macro in excel to manage more than one worksheet? [on hold]

I need to set a macro to manage the "footer elements" in many excel files, and each file has many worksheets. I set the macro both with relatives reference and not, but I can view the modify only at ...
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
2answers
2k views

Excel 2010 Legend key color based on text

Background I've an excel template. This template I populate with data by running a program I've written. The excel template has a pivot table on a sheet that get's data from another sheet that I've ...
1
vote
1answer
20 views

Dealing with absolute references in a conditional formatting macro

Say I have the following simple data in Excel: A B C D E F G 2 1 3 2 5 4 2 4 2 1 3 2 5 2 1 3 2 4 I want to set up ...
2
votes
2answers
4k views

How to add a custom command macro in Windows 8 speech recognition

I have tried a few options but its not working for me. I am using Windows 8 Pro. Can anyone show me how I can write my own custom command macros for speech recognition in Windows 8? I have tried ...
0
votes
0answers
17 views

MS office character replacement [closed]

I often need to replace a character in Excel on a character that follows after it or preceeds it in alphabet. This letter is part of formula that takes data from different columns in other table. For ...
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
1answer
11 views

Word - Change styles without changing formatting

I've been given a document where the majority of the text is styled as Heading 1 for some reason. I want to change it to Normal without changing the formatting - is this possible? I want the font, ...
0
votes
2answers
2k 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 ...
1
vote
1answer
35 views

In the terminal what does “/path/to/file number” do? [closed]

There are a series of commands used to launch some code I'm working with. They are an absolute path followed by the number 0. e.g. /foo/bar/goo 0 Currently its not working, its just gives the ...
1
vote
1answer
44 views

Excel macro to format cells based on value and group with blank rows below

I'm trying to create an excel macro to format some data that is exported from another program. Here is an example of the data layout: ID Code SubCodes 1 A1 1 1 ...
3
votes
4answers
13k 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
2answers
2k views

Office 2010 macro issues

I have some macro enabled word documents that worked fine in Word 2003, but in 2010 I cannot get the macro security settings to behave properly. When I first open a macro enabled document, I get this ...
1
vote
1answer
46 views

Outlook 2013 macro suddenly not working anymore

I've been using a macro to send mails when a reminder is triggerd. I used this guide to get it: Scheduled and recurring email in Outlook? It worked fine for a couple days but now it's not sending ...
0
votes
4answers
3k views

One computer, two desktops?

Can I make my single computer run multiple desktops at the same time. I need one desktop that will work in the background until I decide to switch back to it from the other regular everyday desktop. ...
0
votes
1answer
29 views

How to write VBA code that looks to a cell for a column header in another sheet, then returns the corresponding column? [closed]

So I have a full spreadsheet of customers as columns and products as rows, the crossing cells indicating how many of each the customer has purchased. In another sheet i want to be able to run a macro ...
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 ...
1
vote
1answer
35 views

VBA; Fill down last line of an array to match the length of an adjacent column

So for an early stab at VBA I'm writing a macro: I'm pasting in a set of data that increases in numbers of rows each month; data is well organised with no blank values/columns I have formulae in ...
3
votes
1answer
4k 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? ...
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 ...
1
vote
1answer
29 views

Quick Steps in Outlook quick access toolbar

How can the quick steps in Outlook (2013) be added to the quick access toolbar? The Microsoft forums have an (un)helpful answer. Quick steps exist on the Home tab of the ribbon in a box, but I have ...
0
votes
1answer
30 views

VBA Code Isn't “holding” ThisWorksheet Parameter

I want to retrieve one column of values from another workbook and populate a tab in my current workbook. This will ultimately go into a much longer module I've written that works great. I just wanted ...
0
votes
1answer
5k views

Excel 2010: dynamic update of drop down list based upon datasource validation worksheet changes

I have one worksheet for setting up the data sources of multiple data validation lists. in other words, I'm using this worksheet to provide drop down lists to multiple other worksheets. I need to ...
2
votes
1answer
3k views

Excel 2010 macro to separate a large data file into workbooks

I found some code which works perfectly to separate a file based on a column (line 31) into separate tabs within a worksheet. I just need it to separate the files based on a column into a separate ...
-1
votes
2answers
36 views

Find and replace {0,} occurrences in Word

Are there any alternatives to the concept {0,} which is not allowed in MS Word? For example, if I wanted to replace, by a single abbreviation, the next five terms: articul articulo articula ...
2
votes
1answer
27 views

Numerical index structure out of a folder structure

I'm new to this and I will do my best to ask this question correctly. I need to create a numerical index structure out of a folder/document structure as such. I have this information: ...
0
votes
1answer
14 views

Autofill in a Excel macro

I have the following macro in Excel Sub IHIAddWeeks() ' ' IHIAddWeeks Macro ' ihi-table ' ' Keyboard Shortcut: Ctrl+Shift+I ' ActiveCell.FormulaR1C1 = "=YEAR(RC[1])&WEEKNUM((RC[1]))" ...
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 ...
1
vote
1answer
19 views

Macros in “Word commands”

Recently, I created a macro and named it TableProperties and saved it. This macro will change the AltText in table properties of all the table in the document. I opened a different document today and ...
0
votes
2answers
45 views

Automating reconnection of internet

I use WiFi with a router that drops my connection rarely, which is too often. This usually happens at night, when I'm not using the computer. I would like to automate this: Detect Internet ...
0
votes
1answer
41 views

Loop through cells in a column and concatenate

I would like to take all cells in column A: *bla* *someWord* *two words* *two & words* *other - words* Loop through them and concatenate as follows: “my custom text” + “(”+“*[index1]*”,” * ...
0
votes
1answer
32 views

Calling a function from another workbook

I've got a pile of data in one worksheet that I am trying to save to individual workbooks based on values in several columns. The approach I am taking (for better or worse!) is to copy the relevant ...
0
votes
1answer
36 views

Merge multiple Personal.xlsb

There are SO and SU answers for merging the contents of spreadsheets, but has anyone merged VBA macros to only keep distinct macros and/or highlight differences.
1
vote
1answer
45 views

How can I add a fixed amount of time to all “hh:mm” strings in a document?

I have a document that's a transcription of a video interview. The video itself has embedded SMPTE timecode as well as burnt-in timecode (BITC). The SMPTE timecode and BITC correspond to the time of ...
1
vote
2answers
2k views

How can I stop Excel from opening a second blank window when opening a file from Explorer?

When I open an Excel file from Windows Explorer, I always get a second Excel window as well. Annoyingly, when I close it, it doesn't close, but the other window does! This seems to be a common issue: ...
1
vote
1answer
22 views

Only Show a Watermark When Document is Printed

I have a series of ISO controlled documents that need to have a watermark appear only when printed that says something like "UNCONTROLLED WHEN PRINTED". This watermark would appear in the footer of ...
-1
votes
2answers
1k views

Excel macro to group rows based on a cell value

I have a hierarchical list of items in an Excel worksheet and want to create a macro to group each row based on a cell value that gives the level of indention. The data looks like this: Index Level ...
-1
votes
1answer
40 views

Excel Macro to Find Cells that Contain “<6” in Columns with Header “n” and Replace the Adjacent Cell with “S”

I'm relatively new to Excel VBA programming and I'm having problems generating a macro. My data looks something like this. In column A titled "N" I have counts going down several rows. If a count was ...
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
1answer
156 views

Fake invoice attachments, what's the real functionality doing? [closed]

Over the last few months I've been receiving about 10 emails per day containing fake invoices, e.g. Good Morning The order below was sent over 28/05/15 (please do not duplicate). I am ...
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. ...
3
votes
2answers
31 views

How to format text between branches excel using a macro Excel 2010

I found a little macro to change all the text between "[" and "]" red in excel. But i can't get it to work in Excel 2010, i get some errors. Can someone help me debug this? At the end i wish that in ...
0
votes
0answers
47 views

Word (Office 365) macros disappear

I have created a few simple macros in Word. One of them allows me to switch between printers without multiple clicks. I create this macro (and other simple ones) and they work. The next day, the ...
0
votes
0answers
14 views

How do I split a worksheet into multiple files dependent on the column values, calculate sub-totals and plot graphs?

I have a large data set and would like to split these into separate files/worksheets and perform the same analysis over each data set. I have found a macro to split the data into separate ...
0
votes
0answers
25 views

How to use Windows Libre office Macro In Linux environment

I have some macro which I have made in libre office by window 7 Now I want to run those macro in Linux system through some kind of command Now issue is that How can I save Macro in a single file..? ...
1
vote
1answer
27 views

How to select a cell relative to a button with a macro?

I am trying to create a macro in Excel which I can assign to a number of buttons (one in each row), each of which will operate on the data in the row in which the button is located. Is it possible to ...
3
votes
1answer
66 views

Emacs - move cursor back after mark-whole-buffer & indent-region

I'm Emacs newbie and for automatic re-formating of my source codes in Emacs I've created simple macro using mark-whole-buffer and indent-region commands, mapped to C-j shortcut: (fset ...
0
votes
1answer
54 views

Split data in half evenly by adding column with value: 1 or 2 based on specific cell value - excel

I have a query I pulled from a database with student information. The table has the following columns: StudentID, CourseID, CourseGrade. The CourseGrade column can contain any of the following ...