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
12 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
12 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
26 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
43 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
83 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
37 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
9 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
77 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
58 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
21 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
23 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
76 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
44 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
27 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
31 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
45 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
31 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
180 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
104 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
171 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
85 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
39 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
48 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
59 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
66 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
219 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
218 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
133 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
853 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
47 views

Excel workbook contains a userform which opens up black on 8.1 office 2010

The userform within the worksheet opens black on windows 8.1 office 2010, yet it opens fine on XP with office 2010. It's a excel 79 to 2003 xls file. We checked trust centre on 8.1 but no joy, ...
0
votes
0answers
20 views

Server Tasks Automation

I would like to run some tasks on my Windows 2008 R2 server and need some kind of automation. Right now I am running the tasks with my Macro Recorder - BUT - I need to be connected via RDP in order ...
0
votes
0answers
113 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
107 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
68 views

Convert HTML to Word and embed file hyperlinks as attachments.

I have some HTML files that I'm opening with Word and saving as docx files. I have some macros I run to break the links on the graphics so that they get embedded in the doc file, but I haven't figured ...
0
votes
0answers
146 views

VBA Excel: Macro working well, add-in does half of the job

I created a macro that: 1.takes the value in cell "D11" then 2.trims the value acording to some criteria, then 3.opens another workbook ans searches the trimmed value then 4.copies some info to ...
0
votes
0answers
123 views

Automation of solver in Excel by VBA macro code

I'm solving a 3rd degree polynomial equation, e.g., -0.003x3 +0.195x2 -1.087x -180 = 0 in Excel. I can do this by SOLVER of Excel and can find the value of x. The problem is the constant term ...
0
votes
0answers
24 views

Open image on specific monitor (trigger with Windows Speech Recognition)

I am using a speech recognition macro to open an Image with Irfanview on my Windows 7 system. What I want to do moreover, is to force any new window emerging due to the macro to open in a specific ...
0
votes
0answers
39 views

LIBREOFFICE: Macro to convert LTR to RTL selectively. (BiDi issue)

I use Scrivener to write my essay that consists of BiDi text formatting. The sources I quote are in Arabic whereas the commentary is in English. I then export my file from Scrivener to ODT format. ...
0
votes
0answers
52 views

Windows filename formatter BAT script?

At work we upload files for publishing to the web. The filenames people use are atrocious. Is there something easy out there like a .BAT file that they can drag the file on to to have it clean up the ...
0
votes
0answers
69 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
42 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
85 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 ...
0
votes
0answers
517 views

How can Ez Macros work on Windows 8?

EZ Macros (a nice software that records "keyboard macros") doesn't work on Windows 8 (64-bits), and I am looking for a way to make it work. When we try to record a macro, we can see the message ...
0
votes
0answers
138 views

MS Access Personal Macro Workbook

In MS Excel I have a personal macro workbook that is with me no matter what excel file I open. Is there a similar solution available for MS Access? The reason I am working on this is that i want to ...
0
votes
0answers
499 views

Fill a web form with data from excel (macro)

I am new to VBA and I am struggling to find a solution for my problem. I have an excel database with UNs and PWs for a number of profiles. I also have an administrator UN and PW and each time I want ...
0
votes
0answers
249 views

Excel 2013 - Is there a macro to sort and split the contents of a spreadsheet

I know there any many similar questions to this, but none seem to match exactly... I have a basic Stock List, and want to help to speed up stocktaking, so am looking to create a macro to do the below: ...
0
votes
0answers
328 views

Using VBA to sort cells to match the values in an adjacent column

What I would like to do is write a macro that sorts the values in the range B3:D9 on the left side of the linked image to produce the intended result (shown on the right side). For every value in ...
0
votes
0answers
67 views

Excel Macro looping

I used this macro and it worked fine, but I needed a little bit more. I had to change LookAt:=xlWhole to LookAt:=xlPart and add the color formatting. Now, when I select a column, the Macro appears ...
0
votes
0answers
181 views

Creating a macro to click links on a webpage, if a certain web-page loads?

My ISP (T-Mobile 3G, due to living in rural England) redirects all web-pages to a T-Zone page every time I use 250MB of data. As a result, I cannot download large files overnight as after 250MB has ...
0
votes
0answers
273 views

Excel4Mac - can't find my VBA modules?

I have an Excel sheet with several macros, coded on a Windows machine. I used to keep the file in a dropbox folder for easy sharing with my home computer, which is a mac. I never had any problem ...