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
28 views

My macro's print cell formulas instead of spreadsheet

Excel 2013: I wrote a macro to print 2 copies of a selected portion of my spreadsheet. When I activated the macro, it randomly printed out my cell formulas instead of the sheet. Tyson: here is the ...
0
votes
0answers
20 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
12 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
49 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
24 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
20 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
29 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
21 views

TeXstudio select whole line

I like the CTRL+L shortcut in SublimeText and would like to have it in TeXstudio, too. What it does: It selects the whole current line and places the cursor at the beginning of the next line. That ...
0
votes
0answers
27 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
25 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
133 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
70 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
30 views

I need a macro to separate a column of names into 4 different shifts

Our system creates a report for accuracy. Our manager wants it separated by shifts. From those lists, it will go to a report 'by shift' along with the information on the row with each. I need a macro ...
0
votes
0answers
170 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
72 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
30 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
14 views

excel macro to populate one cell in a sequence from a given rage

currently after I enter a number in cell a1 the data in the spreadsheet changes and then I run a macro " macro1" to save to pdf. The problem is I need to enter more than 30 such numbers into the ...
0
votes
0answers
42 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
54 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
47 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
18 views

Pasting a formula on many excel files using a macro

So basically I have around 500 excel files with different names. But they are in same format. I want to paste my formula in sheet(3), Cell (AW6:BL6). This is what i'm trying. Private Sub ...
0
votes
0answers
210 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
188 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
55 views

Change Excel cell value on each saved revision

Is there a way of increasing cell values on each file save? I have a version number on a macro-enabled spreadsheet, and I want it to increase by say 0.1 each time I save the file. I would rather not ...
0
votes
0answers
124 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
681 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
46 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
18 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
98 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
87 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
60 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
58 views

Script/Macro to print 1st page of 1000 pdf to same printer

I have a folder with 100+ PDF documents each of varying number of pages. I need to print the first page of each document to a printer which adds a VAT code to the document (kind of like an ...
0
votes
0answers
126 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
121 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
37 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
47 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
196 views

When I saved my excel file xlsm and reopened it, the macro was reported to be correct

I've been learning vba recently and a disturbing question came up to me. I simply tried the message box code: MsgBox("hello world"), and then saved the excel file with .xlsm extension. When I reopened ...
0
votes
0answers
63 views

Force pasted address to show on one line separated by commas

I am pasting addresses into a cell in my document before printing. The cell is wide but not very tall which means when the address is pasted into the cell the bottom couple of lines are not visible. ...
0
votes
0answers
63 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
37 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
74 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
474 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
88 views

Reformat a text file using a macro in Excel

I need to reformat a report I receive every month as a text file so I can perform spend analysis on the data in Excel. The report was in a statement format before converted to a text file because the ...
0
votes
0answers
191 views

I'm looking to create some VBA code to search for other instances of certain string, move original instance above found

Please excuse me if I'm posting incorrectly in any way- this is my first go round on superuser. I'm looking to create a fairly basic VBA macro to automate a process in excel I'll otherwise have to ...
0
votes
0answers
124 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
261 views

how to convert data in table format to pivot format

I would need help in converting table which is in table format to a pivot format. Below is the sample data which i have: ![Input File][1] Product Currency Value US UK Japan Ind ...
0
votes
0answers
420 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
328 views

VBA Macro to sort and apply conditional formating to a range of cells with dynamic number of rows

I have a range (the image below). Please note that: Range is generated by another application, so number of rows is ever changing, and is not formatted as an Excel 'table' The number of columns, ...
0
votes
0answers
236 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: ...