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)

0
votes
0answers
4 views

Merge multiple Personal.xlsb

There are SO and SU answers for merging the contents of spreadsheets, but has anyone merged macros to only keep distinct macros and/or highlight differences.
1
vote
1answer
15 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
41 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 ...
0
votes
1answer
6 views

How to autosort descending in excel?

I have some simple data in sheet 1 and in sheet 2 I have a data relating to sheet 1 that sorts by highest number first. So in sheet 1 I Have +---+---+---+---+ |Col|n01|n02|tot| ...
-1
votes
1answer
19 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
18 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
87 views

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

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
8 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
22 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
26 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
23 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
11 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
16 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
votes
0answers
19 views

Replace cell references with values without F9 using macro (2) [duplicate]

I tried to use the macro in this post but it doesn't work on mine. Can you help to tweak this macro abit? I want to change from this: =((J26*J27*J28+J34*J35*J36+J30*J31*J32)*24/1000000) ... to ...
-1
votes
0answers
25 views

Extract address from HYPERLINK cell in Excel 2010

I have a HYPERLINK cell in Excel 2010 where I have many rows on it. I want to extract underlined address from that HYPERLINK cell. Below macro is not working for me. Function GETURL(HyperlinkCell As ...
0
votes
0answers
7 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
30 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
47 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
19 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
81 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
16 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
15 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
26 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 ...
-1
votes
0answers
10 views

Putty connection manager login macro not working - carriage return represented as ^J

I've configured a putty connection to a server with login macro, and when I click to connect, the login prompt appears properly, however the login macro enters the user name and password without a ...
0
votes
0answers
14 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
15 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
23 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
34 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
16 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
27 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
17 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
1answer
83 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
40 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
63 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
24 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
128 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
31 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 ...
1
vote
1answer
43 views

How can I assign Excel keyboard shortcuts for macros that use keys other than Ctrl + {alpha character}

I would like to assign keyboard shortcuts to Excel macros that use keys other than the standard Ctrl + {alpha character}. Based on this post it sounds like it is possible but I am not sure how: ...
1
vote
1answer
43 views

Show increase in trendline by using Excel vba

I have data in c5:c12 (sales1) and I plotted a graph and a trendline of this data. I also have data in d5:d12 (sales2). I would like to show an increase, graphically, in my existing trendline by using ...
0
votes
1answer
101 views

when criteria does not match do nothing excel vba macro

I am implementing a macro that checks column E for dates that are 7 days away from current date. If cell date - current date = 7 then an email containing the row that has the matching cell, is sent ...
0
votes
0answers
5 views

Custom View Macro

The macro below is intended to change a button to switch to a custom view. However, it does not work, and I don't know why. I have a custom view called Campaign Details, but this is telling me that ...
0
votes
1answer
55 views

Trying to highlight unique values across multiple sheets in Excel 2007

I am trying to compare the values from column A of Sheet1 (which I have renamed "AR") and column A of Sheet2 (which I have renamed "Paste Here") and highlight rows containing values that do not exist ...
0
votes
0answers
27 views

From Macro to Add-in: Word 2010

tldr; I'm not sure how I can get the Add-in to recognize the active document! The goal is to set the macro to an Add-in button. I have lots of forms that have endless amounts of the old form field ...
0
votes
2answers
86 views

Hide rows based on the value of another cell

First, I've tried these threads, to no avail (1, 2, and others which I am prohibited to mention since my rank doesn't allow for more than two links). I am almost certain I'm just missing some simple ...
0
votes
1answer
61 views

Macro to autofilter across different sheets and paste result on a different sheet

I need to create autofilter across 3 sheets based on values selected on the three dropdown lists on a separate sheet on the same workbook. The 3 sheets have the same headers from columns A to AG and ...
0
votes
2answers
60 views

Is it possible to have an excel workbook automatically save as macro-enabled if macro is added to the workbook?

Currently, in Excel 2010, when I try to save a workbook that I have created as a .xlsx file but added a VBA function or subroutine to, Excel gives a prompt asking (in a round-about way) if I want to ...
1
vote
1answer
39 views

Excel VBA format footer that contains calculated value

I have a macro for my footer that uses the RIGHT and LEN function to pull strings from various cells within the worksheet. I've tested on various sheets and this works. ...
0
votes
0answers
16 views

How to use Jitibit Macro Recorder with double pointer?

So, Jitbit Macro Recorder basically allows you to make the mouse perform specific tasks, so I can perform redundant, repetitive tasks automatically. There's also a program called Pluralinput which ...
0
votes
1answer
60 views

Macro in Excel to add the date in ISO-8601 format

For some reason, Excel forces me to use my region for footers when I insert the date. However, it also doesn't auto update when the worksheet opens. Without the formatting this is a rather trivial ...
0
votes
1answer
638 views

Macro to copy distinct values from one Excel sheet to another

I have an Excel workbook that has the following sheets, "Main" and "Count": Now the "Main" sheet has the column B with list of IDs. Is it possible to have a macro on "Count" page to copy all ...