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
2answers
39 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
27 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
22 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
24 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
17 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
43 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
23 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
96 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
9 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
23 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
27 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
25 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
17 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
29 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
34 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
85 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
18 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
11 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
15 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
17 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
24 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
38 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
17 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
18 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
95 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
42 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
65 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
132 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
33 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
45 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
107 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
56 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
28 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
93 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
62 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
63 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. ...