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
1answer
70 views

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

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
6 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
18 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
25 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
22 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
15 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
24 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
1answer
42 views

My keyboard input somehow got registered onto my roommate's computer [closed]

My roommate and I are both connected to our school's internet via ethernet. All of my peripherals are wired. He has a wired keyboard and a wireless mouse. I use autohotkey to quickly enter my login ...
0
votes
0answers
28 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
46 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
80 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
25 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
9 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
14 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
22 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
33 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
13 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
25 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
15 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
80 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
61 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
126 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
29 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
42 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
98 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
54 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
79 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
59 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
57 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
38 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
58 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
624 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 ...
0
votes
0answers
13 views

Auto copy predesigned row to new row

I'm looking to create a function or macro that would allow me to create a new row based off of a initial design when new information is added to the sheet. As an example, see below: Row 1 would ...
0
votes
0answers
33 views

LIBREOFFICE WRITER - Changing some fontname throught a document

Normally the document use "COMIC SANS MS" font name. In my document I use four special characters ( club (U+2663), diamond (U+2666), heart (U+2665), spade (U+2660) ). These characters should come ...
1
vote
1answer
117 views

How to align column values with their matching value in another column?

I have several columns of data that I need to align with a master column. The following is an example of what I hope to achieve, but with a table containing more larger strings and more rows. The ...
0
votes
1answer
67 views

Macro to fill in cells from a column sequentially when I click on a button

I'm having a lot of trouble trying to figure this out. This is my layout: As you can see, I have 2 buttons. What I would like each button to do is: Each time I click YES, it will insert a Y ...
1
vote
1answer
755 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: ...