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 the ...

learn more… | top users | synonyms (1)

0
votes
1answer
1k 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
52 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
30 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
159 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
65 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
22 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
3k 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
33 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
19 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
56 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
98 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
72 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
33 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
79 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
42 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
287 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
17 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
608 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 ...
0
votes
0answers
36 views

How to create a template part in Solidworks?

How can I prepare a part (like a 19" rack unit) as template with two variables? The user should be able to give values for the number of HE units and the depth and Solidworks creates a new part with ...
1
vote
2answers
75 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
85 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
0answers
76 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
1answer
258 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
229 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
59 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
25 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 ...
4
votes
2answers
506 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
306 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
0answers
104 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
1answer
45 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
81 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
200 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
327 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
206 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 ...
0
votes
0answers
149 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 ...
1
vote
1answer
64 views

How to cross data from 2 excel sheets

I'm doing a small internship at a local library. My mentor requested my help to a do lenghty job, but it has to be done over the week.. So, this is what he requested me: to look up in 2 different ...
-2
votes
1answer
639 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
59 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
0answers
34 views

MS-Word MacroButtons are highlighted when clicked

I'm building a Word doc with collapsible bookmarks and using MacroButtons to collapse and expand the text defined by a given bookmark. For example, the code to toggle the bookmark named 'Alcohol' is: ...
0
votes
0answers
73 views

How can I use Acrobat Pro to calculate the percentage of pages in a document that have more than x words of text? How can I do this in bulk?

I use ABBYY FineReader Pro 11 to OCR old documents, and I need to run a script through a folder of 800-some PDF files so that I can calculate how many pages out of the whole document have text on ...
0
votes
1answer
24 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
56 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
23 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
90 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 ...
2
votes
0answers
297 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
47 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
141 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
95 views

Adding Categories Button to the 'New Email' ribbon - no longer working?

I've used the macros at In Outlook 2010, can you add "Categories" to the "New Email" Ribbon? by @qbik to set up the Categories button on the ribbon. It was working for several ...
0
votes
0answers
317 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 ...