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
31 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 ...
0
votes
0answers
34 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
0answers
34 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
0answers
14 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
57 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. ...
0
votes
0answers
64 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
17 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
29 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
0answers
64 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
0answers
16 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
0answers
24 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 ...
0
votes
0answers
37 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 ...
0
votes
0answers
71 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
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
0answers
8 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
0answers
45 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
0answers
26 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
0answers
14 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
44 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 ...
0
votes
0answers
74 views

copy and paste according to a order in a column

I want a macro that will fetch data from Series B and Automatically paste it according to the serial of Serial A. ASeries B and Series A data are same but Series B is not ordered. So i'm looking for ...
0
votes
0answers
117 views

Excel 2010 shared workbook - image buttons disabled

I have several Excel workbooks which were originally created in a 2007 version. They are shared workbooks, and contain some VBA code, and are protected to prevent users from changing certain content. ...
0
votes
0answers
53 views

when filter takes out all data, macro copies the titles over. Why?

I am using a macro that copies multiple columns into other documents. I use filters to determine which other documents it should be inserted into. When the set of data does not contain data for one ...
0
votes
0answers
18 views

Access 2010 - macro running

I have a macro running a series of Maketable queries. It runs one query then exports the data to a .csv file, and repeats the process with the next query. My problem is that for each query I have to ...
0
votes
0answers
122 views

OSX macro to simulate holding down mouse button

I would like to setup a keyboard macro on a Mac OSX that, when triggered by a keyboard command, (say ctrl+m), simulates the left mouse-click button being HELD DOWN. When I hit the combination again, ...
0
votes
0answers
74 views

Update to: Macro to merge cells in a column if the same rows are merged in a different column

I have a large (over 10k rows) spreadsheet with text data I want to concatenate from multiple rows into a single row. The text data corresponds to a date that is in a merged cell in a neighboring ...
0
votes
0answers
26 views

Plug-in command in Notepad++ Macro

I'd like to create a Notepad++ Macro executing the following commands: 1) Plugins -> Compare -> Compare. 2) View -> Word Wrap. Is that possible? Is there another workaround for the ...
0
votes
0answers
32 views

Quicksilver - Keyboard macro to select all text to right of cursor

At one point, I had this set up on another machine, but I don't have that mac anymore. I would like a global override to have cmd+shift+right arrow select all text to the right of the cursor on the ...
0
votes
0answers
106 views

Getting Razer Blackwidow macro keys on linux

I've read Getting macro keys from a Razer BlackWidow to work on Linux and the python script didn't work for me so I compiled the haskell from source. I changed my product ID in main.hs and everything ...
0
votes
0answers
81 views

When enter key is pressed, find the next instance of searched word

I have recorded the macro for the process of finding word. Whenever I hit enter button it will go to the next occurrence of searched word.How can I do it programatically using macros. When I click ...
0
votes
0answers
33 views

Why LibreOffice control is not updated?

I have created a few simple macros that create a dialog and read one of the controls text. The ReadWrite Macro is attached to a button. It reads a text from textfield and prints it. However when I ...
0
votes
0answers
33 views

Macro to increment date from a start date to finish date

I'm a beginner in macros. I have start_date value in cell B4 and end_date value in cell C4. I need a macro that can write the dates from a start_date (the saturday just before the start date) to ...
0
votes
0answers
65 views

Noweb syntax everywhere in Org Mode

I'd like to be able to use noweb syntax to invoke macros defined as src blocks everywhere in an org-mode file as a replacement for the org-mode macro system. Is there a way to do this? My question is ...
0
votes
0answers
36 views

Excel 2013 Split One sheet into separate books

I have one sheet called Invoiced Jobs report containing the information for 10 invoices the invoice number is in Column X can I make a macro to split each invoice into a separate workbook?
0
votes
0answers
229 views

Mac Excel 2011 xlsm file will not open

I really hope someone might be able to help. I have just saved my research data base as a macro-enabled file. The screen went grey and hence I closed the app. On reopening, the file can be seen, and ...
0
votes
0answers
160 views

Find and replace multiple values within selected cells using another workbook

I was wondering whether anyone could point out what's wrong with the VBA code below. It's based on the following: Find and replace multiple values within selected cells I want it to take the find ...
0
votes
0answers
186 views

vba excel macro runtime error 1004

Dim lastC As Long lastC = wb2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'highlighted in debug SourceRange.Copy wb2.Worksheets(2).Cells(1, lastC + 1).PasteSpecial Paste:=xlPasteValues, ...
0
votes
0answers
117 views

Excel VBA macro - i need to insert column and add a default value to all the cells in that column

I have created a macro but i could not insert columns in it and i could not add values to that coulmn. I want to insert a column and the default value to that entire column should be CH. column ...
0
votes
0answers
47 views

Libre Office Calc - how to suppress search results window when performing a macro search?

I work with a macro that finds and replaces certain characters in a spreadsheet. I use this macro a lot and I don't need the "search results" window to pop up after every search since I am not ...
0
votes
0answers
77 views

Word macros to resize a picture to its original size and then back to “thumbnail” size

Workflow: 1. Insert a larger picture in a MS Word 2010 document 2. Reduce the picture size to a smaller "thumbnail" size 3. Save and close the document 4. Reopen the document 5. Select the picture ...
0
votes
0answers
64 views

Copy-pasting between two computers , or a virtual machine and host?

In my work, I find myself hopping between a VPN machine and my host machine to do work. Lately I've been using https://www.cl1p.net/ a lot , for copy-pasting between 2 computers. A nice site, ...
0
votes
0answers
79 views

Excel Macro for preserving line breaks in cell text

I have an excel sheet containing text that I require copying and then pasting into a 3rd party application (bit like notepad). I need to use a button to copy the text so it cannot be edited or ...
0
votes
0answers
255 views

Select item from drop down menu and run macro

I have a drop down list in a sheet called 'Report', cell B9. The source for this list is in another sheet in the same workbook, 'List' with range 'A1:A32'. When the different items in this list are ...
0
votes
0answers
290 views

Prevent 'Run-time error '7' out of memory' error in Excel when using macro

I keep getting this error whenever I run a macro in my excel file. Is there any way I can prevent this? My code is below. Debugging highlights the following line as the issue: ...
0
votes
0answers
164 views

Could not load an object as it is not available on this machine - Excel 2010

Got an issue that is driving me mad. Every time a user accesses this file, he always gets the error messages: "Could not load an object as it is not available on this machine" & "Compile error in ...
0
votes
0answers
1k views

Hack for running multiple iMacros in random fashion

I have 20 iMacros (for browser) and they are specific to different URLs. I run these macros one after another, and then repeat or loop all of them 10 times. But within that loop, i need those 20 ...
0
votes
0answers
167 views

How can a Macro sort dates from oldest to newest?

I'm doing account statements in a bank and I need to be able to make them fast, so I am using macros for making this process. However, there is a step that I always have to do that a macro won't let ...
0
votes
0answers
161 views

Can I write a Macro to export data from Web?

I need to write a macro that can import data from the web (salesforce.com). Is it possible to pull data from the web through a macro? The data I will pull from salesforce.com, is a monthly task. Can a ...
0
votes
0answers
90 views

Macro for hiding table colums, in multipile files, and another on to reverse it

I know almost anything about VBA so I can't really code the Macro that I need for MS Word. I hope that I could get some help here. The basic functionality that I want is to take a Word document with ...
0
votes
0answers
56 views

Text Macros For Chrome

I am not really what this would be called or what to search for, so I apologize if this has been answered before... I am a software developer, so as an example, I am going to use a function call, but ...
0
votes
0answers
103 views

“Filter by Selected Cell's Color” is so slow

I have a row includes like 60-70 thousand lines. 30.000 of them colored. And I'm trying to filter them by "Filter by Selected Cell's Color" but it's so slow. It take forever to filter just 70.000 ...