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
vote
1answer
37 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
83 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 ...
0
votes
1answer
66 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
93 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
57 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 ...
1
vote
1answer
85 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 ...
1
vote
1answer
91 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
41 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
42 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 ...
2
votes
1answer
35 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
0answers
42 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
1answer
18 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]))" ...
1
vote
1answer
28 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 ...
-1
votes
2answers
54 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 ...
0
votes
2answers
60 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
121 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
61 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
45 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
59 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
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
votes
1answer
71 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
44 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
354 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
16 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
83 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
33 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
84 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
21 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
46 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..? ...
0
votes
1answer
35 views

Ultra Edit Macro - Save file getting the name from clipboard

I need to record a macro which save the current file getting the name of the file from what I have on the clipboard. I know I can edit the macro after saving the file and use the "^c" variable, but ...
0
votes
0answers
75 views

Run Notepad++ macros on command line

I have a lot of txt files in a folder and what I want to do is creating a Python script wich reads all the files contained in this folder and applies to each of them a n++ macro. To do this I need to ...
0
votes
1answer
76 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 ...
0
votes
2answers
23 views

I'm looking for a way to control an iOS device with a Mac and execute pre-defined touch macros

I'm looking to perform automated testing on an app so I don't have to sit in front of my phone and perform the same repetitive tasks. One thought is to use a VNC solution to connect with the iPhone, ...
1
vote
2answers
527 views

How to split numbers into separate digits in Excel

Does anyone know a fairly simple way to split numbers of various length into separate digits and then manipulate each digit? Could probably do it in Excel itself, but thinking a macro would be nicer ...
0
votes
1answer
27 views

MS Excel cell references shifting after using a macro?

Basically this is what happens: On Sheet1 I have a column of cells that are linked to other cells on sheet2. Looks something like this. Sheet1!A1=Sheet2!A1 Sheet1!A2=Sheet2!A2 Sheet1!A3=Sheet2!A3 ...
1
vote
0answers
19 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 ...
0
votes
1answer
65 views

VBA to prevent the global shortcut from running the wrong code

The article at the following site provides a tip for preventing a global keyboard shortcut from executing the wrong VBA code when two different macros in two different worksheets are assigned the same ...
0
votes
0answers
19 views

Create macro and hop to next line

so my question is if there is a possibility that a macro ends in the next line. I currently need to edit an xml file in notepad++ and after certain lines I have to add a <br />. I already ...
0
votes
1answer
28 views

Recording Macros with Visual Studio 2013

I am trying to use Mouse Recorder Premium to record a Macro in Visual Studio. However, after I start recording the macro and switch to the Visual Studio window, none of the keystrokes are recorded in ...
1
vote
0answers
38 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 ...
0
votes
1answer
103 views

Excel formula - is it possible to return a value adjacent to a list of values, depending if that list of values matches another list?

In Sheet 1, I have a list of document numbers (alphanumeric) in Column A, which have a corresponding title listed in Column B. I need to compare another list of document numbers (alphanumeric), ...
0
votes
0answers
25 views

Web Scraping with Macros in one sheet

I got this code to download web pages, but it download each page in a separate tab. How can I make it store all in one tab till its filled than make another and so on? Code: Sub adds() For x = 1 To ...
-1
votes
1answer
47 views

How can I print only pages I have selected by a checkbox to print in MS Word?

I have a protected Word document with many macros. It is approximately 45 pages long. I want to add a checkbox on the top of each page and run a macro so that only the checked pages will be printed. ...
0
votes
0answers
40 views

Macro Hyperlink Error in Mac OS (Office for Mac 2011)

I am getting an error on a macro only when using a Mac. This macro was designed to solve a problem with a formula using the Hyperlink function to copy a link from another sheet for each row. (Excel ...
1
vote
2answers
827 views

How to get rid of “The following features cannot be saved in macro-free workbooks” in excel 2013?

Every time when I try to save a file, I'm getting the following error message. The list of available Add-ins in Excel I tested with a fresh file saved with simple word, closed, re-opened and ...
0
votes
0answers
91 views

Run-Time Error - The directory name is not valid

I am using a domain computer, and I am unable to use a macro which saves a file to a specific location. I get the error message exactly in the title of this post. I've tried disconnecting and ...
0
votes
1answer
194 views

Macros doesn't load on powerpoint startup

I have created a powerpoint macros to run a batch file when slideshow starts. This is my code Sub OnSlideShowPageChange(ByVal SSW As SlideShowWindow) If SSW.View.CurrentShowPosition = _ ...
0
votes
0answers
26 views

Control MS word add-ons using recorded/programmed macros

I have installed a Microsoft word add-on (Docear4Word - I think originally written in C#). The program installer places the program on the references menu of the ribbon although the buttons and ...
0
votes
3answers
197 views

Excel macro: Last non-empty cell in a column

This is a followup question to this one. The following formula can be used to find the value of the last non-empty cell in a column, in Microsoft Excel: =LOOKUP(2,1/(A:A<>""),A:A) My ...
0
votes
1answer
112 views

How do I prompt a user with file “Save As” dialog using a macro?

I created an Excel macro to replace data from "Quote" to "Invoice", but after running the macro, I wish for the macro to continue to run and stop at: "Save As..." mode so that the user can provide a ...