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

Automatic backups (history) in LibreOffice (OpenOffice)

LibreOffice can create a backup copy when you enable it in settings (Options > Load/Save > General), but it saves only the previous state (one only). It has also an versioning feature (File -> ...
0
votes
1answer
56 views

Identify Image in Excel - VBA

I have an Excel sheet, and I want to create some macros using VBA. Specifically, I want to change an image with a predefined one, every time I press a button or every time I press on an image. ...
1
vote
2answers
79 views

Outlook : Prepend time to appointment subject

I want the title / subject of every appointment to be prepended with the its time. I want the title to automatically be updated to correspond to the event's time (If I change the date, so does the ...
-5
votes
1answer
184 views

VBA for “IF formula” with multiple results in a single cell [closed]

How can I convert this to VBA? Using this formula, it cover 6 rows only and the formula is already too long. My report has 600 rows. =IF(AND('Risk & Issue Log'!$K$2=$D5,'Risk & Issue ...
0
votes
2answers
56 views

How do I make a button to add new fields in Excel?

I have a formula which uses a constant. Every time I copy and paste the cells for a new day, I want the constant to update to the new one. I was thinking I could create a button to copy the fields ...
0
votes
2answers
108 views

Remove the second literal \N per line in Notepad++

I have a text file with several hundred lines similar to below: Here are some examples lines,\Nthis text needs to strip out\Ncertain, Here are some examples lines. Here are some. Here are some ...
1
vote
1answer
47 views

Searching the string in a text sitting on 1 coulmn

I'm very new into VBA coding, I would like to have some assistance as I have been trying for two days, I have got data fixed in column A, I would like to search for a string in that column, eg ...
0
votes
1answer
3k views

How do I select text between two “bookmarks” in Word VBA?

Note: Originally I asked how to select text from a certain point downward, but I've got a solution for that: Dim f As Word.Field For Each f In ActiveDocument.Fields If f.Type = wdFieldAddin And ...
0
votes
0answers
68 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
1answer
236 views

Excel - How can I highlight duplicate cells in near-matching worksheets?

I'm running a March Madness bracket tournament using Excel spreadsheets. I have one sheet where I will input the actual winners. I have an additional sheet per participant that is near-identical, only ...
0
votes
1answer
119 views

Update macro values when cell value changes

I have a checkbox control with a macro that takes value from cell 6 columns over and inserts it in either the 8th or 9th column over depending on whether the checkbox is checked or unchecked. This is ...
0
votes
0answers
41 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
1answer
8k views

hide/unhide rows based on cell value [duplicate]

Based on a cell value = true or false, I conditionally formatted rows to turn black. That means that I need to scroll down to find the set of rows that did not turn black. I would prefer that all my ...
0
votes
0answers
34 views

Is there a way or code that will pull data from Excel and place it in specific order on powerpoint presentation? [duplicate]

I'm going crazy trying to figure this out, there has to be an easier way. I will try to explain as best as possible: I am preparing a powerpoint presentation for a trial, it will contain aprox. ...
0
votes
2answers
21 views

How to change the Range for the Location of Workbook and Sheet in macro?

I have Found a macro on this site: How can I compare two columns in Excel to highlight words that don't match? My question is how can i change the link or the range of the column to different ...
0
votes
0answers
83 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
3answers
231 views

How to automatically copy randomly generated text from a website

I am not sure how best to ask this, as this my be a multi-pronged question, requiring different avenues of attack and my preconception of the solution is a basic input-function-output scenario. I am a ...
0
votes
1answer
145 views

How to combine several excel workbooks into a single book

I have several, multi-sheet workbooks which I would like to combine so that I can search them all simultaneously. So, the merged workbook will contain tabs 1,2,3, of the first workbook, then tabs ...
-2
votes
2answers
40 views

How to write a macro in exel?

I need to cut the contents of the cell, to write a quotation mark, paste the contents of the cell to write another quotation mark then move to the next cell. Or anything else with the same result.
1
vote
1answer
240 views

How to know which macro is assigned to a certain toolbar button in Word 2003

I have a Word 2003 toolbar made by someone else long time ago. The toolbar contains lots of buttons and assigned macros. Until now I have been able to set breakpoints in the VBA code in order to ...
0
votes
1answer
54 views

Adding two numbers using macros failed to execute

How to add 2 numbers using macros? I tried below but i am not able to execute. Sub auto_open() n1 = InputBox("enter fiest number") n2 = InputBox("Enter 2nd number") ...
0
votes
0answers
514 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
2answers
42 views

Go to end of `===` but not include `$`

Consider the following example lines: $some ==thing(); $some == thing(); $some ==$thing; $some == $thing; I am writing a macro to improve these lines. With the cursor on the space after $some, I ...
0
votes
1answer
18 views

Find and then ask to perform action

I have a few macros to help refactor code that I have inherited. For instance, this macro adds spaces around a = character: nnoremap <leader>bg /[^ ]=[^ ]<Return>a <Esc>la ...
0
votes
1answer
1k views

Deleting entire row in excel if missing data in certain column or columns?

I just downloaded a Micosoft CSV file from Google Contacts and I would like to modify it so that I can organize the contacts in my phone. I am going back to my "dumb" phone as part of an experiment of ...
1
vote
2answers
814 views

Workbook doesn't find macro

I created a macro in a workbook which is being used by several persons on their own computers. For some of them, it seems to work fine, but for other a message appears that it can't find the macro on ...
0
votes
1answer
257 views

How can I create an Excel Menubar Button to run a Macro?

Background: I created a macro for a friend that will create a pivot table from a large worksheet of data. The data will always have the same number of columns with the same column headers; the number ...
0
votes
1answer
672 views

Outlook 2010 Run Script via Rules

I have the following subroutine in ThisOutlookSession: Sub receiveMtgRequest(Item As Outlook.MailItem) MsgBox "You have received a meeting request: " & Item.Subject End Sub I have set it to run ...
0
votes
2answers
1k views

How to merge rows with same Name merging data of each ?related column

I need to merge rows with same Name preserving data of each column. For example, if we have two rows with the name "Mr Bean" on the first column "Name" then merge data of each column related to rows ...
1
vote
1answer
118 views

How can I force Excel to recalculate after a UDF macro error?

I created a bug in a user-defined function that is called from a large number of cells on many tables in an Excel workbook (not the way I would design it, I just "inherited" it). But now, I can't ...
1
vote
0answers
28 views

Use two keyboards; One for macros?

I'm wondering if it is possible to actually use another keyboard as a set of "macro keys"? I have searched a lot online for this, and nowhere can I see that it is possible. Do you know of something ...
5
votes
2answers
1k views

Using English macros in French version Excel

I am currently in France and am using a computer on which all Office programs are in French. I need to use a Macro which has been written in English VBA, but it fails. I assume the issue a language ...
0
votes
1answer
721 views

Macro to Import CSV files into Excel

I have a bunch of CSV files in a folder. I'd like to import each file into Excel using the 'Import from Text' tool by typing the name of the file into a cell. I then need to format all of the data ...
0
votes
1answer
51 views

What's the most portable way to easily allow users to add a letterhead to a Word document?

I would like a way to allow users to easily add a letterhead (some text and a logo) to pre-existing Microsoft Word documents. Methods I have considered have been macros, templates, and quick-parts, ...
0
votes
0answers
137 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
1answer
308 views

How can I create a persistent data connection from MS Project 2013 to Excel 2013?

I'm trying to get dates from an MS Project file to come across to a separate Excel file which I'm using to run conditional formulae on to handle the project status matrix. The catch is that I need ...
0
votes
2answers
850 views

Why would Chrome randomly go back multiple pages?

My browser just jumps back several pages. Other issues: Cannot click in task bar while in any window. Cannot click inside a window if it is brought up from the task bar (only alt-tabbing into a ...
0
votes
2answers
390 views

VBA macro to remove everything before and after <div> tag [duplicate]

I'm creating a report that has a column with lots of cells that have HTML tags in almost every box. I'm trying to create a VBA macro that will remove some HTML tags from this column. So in one ...
-2
votes
1answer
1k views

Excel 97-2003 Macro does not work in Excel 2013

I have an Excel file that was done in Excel 97-2003. It contains a macro. The macro runs fine in Excel 2010 but have now had to convert to Excel 2013 and the macro does not work. I am only a basic ...
0
votes
1answer
90 views

Open Commonly Edited File Easily in Sublime Text 2/3

Can someone please tell me how I can setup Sublime Text 2 or 3 so that my F1 key on the keyboard opens up a file that on my system sits in: C:/users/myname/projects/main/intranet/web.config I ...
0
votes
1answer
28 views

How to size multiple images in Word 2011 via macro

I am importing screen shots from an Evernote file, into Word 2011 (Mac OS X). They look fine in Evernote, but are huge (20") in Word 2011. I need to quickly shrink them to 4" wide, and center them. ...
1
vote
1answer
73 views

How to create multiple rows combining data sets

I have three tables and i need an out put which has data from two tables, i would like to create the same using macro. Table A A B C D Table B Apple Orange Pears Table C Americas Asia Europe ...
1
vote
0answers
26 views

Is there a program to move the mouse according to an svg?

Basically, I want a program that will look at an svg, then 'act' it out on a set canvas. For drawing.
0
votes
3answers
118 views

Combine rows in Excel

I have data in column 1 and data in column 2 as follows: 1234 eggs 1234 bacon 1234 toast 4321 Orange Juice I want it to appear as follows: 1234 eggs-bacon-toast 4321 ...
1
vote
0answers
571 views

Splitting an excel 2010 spreadsheet into multiple workbook files based on column value

I find and clean a lot of contact data, sorted by country, which I am currently using excel to manage. Mainly because it is easier to clean and manipulate the data I find this way, and I can easily ...
-1
votes
2answers
138 views

How to assign a MS Word macro to a hotkey? [duplicate]

I've created a macro in MS Word 2007, but to run it, it seems I have to open Developer > Macros > Run each time. Surely there is a way to run this over and over with a hotkey, but how?
-1
votes
1answer
283 views

How to generalize a macro to any row

The Excel macro below is written to function on a specific row (row 2) of Excel. I would like to be able to apply it to any row that I select rather than just to row 2. Does anyone know how to adapt ...
0
votes
0answers
494 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
2answers
7k views

Checkbox in dropdown list

I have a table in excel where I can select multiple items from a dropdown list in one cell. Now, using my macro I have to pick all of the options separately, and they are added to a cell one by one. ...
0
votes
1answer
362 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, ...