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
0answers
109 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
56 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
420 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
43 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
27 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
62 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
20 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
54 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
76 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
235 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
42 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
113 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
83 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
286 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
2k 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
0answers
193 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
33 views

Microsoft Excel, setting variable reference

I am converting a macro that used a set date range to only extract the products needed within that date range. However, as certain products have different availabilities I would like to extract all ...
1
vote
0answers
82 views

Is there a macro to filter table by some list elements?

I have a table with entries based on a list and I used a macro I found somewhere to be able to add/remove multiple elements from the list to one cell, let me show you an example: TEST TABLE test1 ...
0
votes
0answers
141 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
1answer
84 views

How to format time with decimal places with excel vba?

I'm trying to write a macro that takes a time value in seconds (decimal) and converts it to mm:ss.00 format (two decimal places.) The closest I've come is this: Application.Text((1.23 / 86400), ...
0
votes
0answers
72 views

Sidewinder x4 Media Macros

I was wondering if anyone knew how to change the macro keys on the Sidewinder X4 (uses Microsoft Intellitype). I wanted to change the play, next, and repeat button the keyboard to use Spotify instead ...
0
votes
0answers
14 views

windows “session” macro or application?

I am wondering if anything like this currently exists: Scenario: i have some files open, some applications, some explorer folders, etc. Is there a macro or application that can capture a snapshot of ...
2
votes
0answers
30 views

Open link at cursor position with keyboard shortcut

I'm using a rich web application that replaces my browser's right-click context menu with a menu of custom options. I want to be able to open a link in a new tab and right-click doesn't work for the ...
0
votes
0answers
97 views

Excel Combo box to filter a table column

I have a table that I want to filter a column of 'team names' (D10 is the column header) using a combo box (which has a list of the 10 team names from another sheet). So, when I select a different ...
1
vote
2answers
110 views

VBA macro in excel 2010 32 Bit mode

I have a excel sheet which saved using Excel 2010 64 Bit. It has a code as follows Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 1 And Target.Column = 17 Then Dim iRet As ...
1
vote
0answers
28 views

VBA to sequentially number rows in column [duplicate]

I want to number sequentially all cells on sheet4 starting at A2 (starts at 0) for 26000 cells in the A column I have been trying the get the below code to work but need help. Sheet4.Range("A2") = 0 ...
0
votes
0answers
189 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
16 views

Shortcut to bypass all animations and go to next slide in Powerpoint? [duplicate]

Is there a shortcut in Powerpoint instead of using the control panel or right-click menu to bypass animations and go straight to next slide?
-1
votes
1answer
38 views

How to Prompt Before Send in Outlook 2010

I am using outlook 2010. I would like to receive a popup after clicking on the send button. The Popup should say "Do you want to continue sending the mail?" and it should have two buttons on it ...
1
vote
1answer
169 views

Monitor Web Page with Macro/Script

I am signing up for classes for my university; however, classes have filled up and I need to keep refreshing to check when/if classes have opened up. I have a specific page that I want to refresh that ...
1
vote
1answer
148 views

Word or LibreOffice/OpenOffice - How to automatically insert footnote text in document body at footnote reference mark?

I have some docx documents that contain a lot of footnotes with usually a short footnote text (e.g. "Richard 2010." or "see section xy"). It's much more convenient to have these in the document body ...
-1
votes
1answer
29 views

Need Macro to perform formula based on cell not number

I am working on a budget workbook and in column I (I5-I1135) I have numbers that I need to upon prompt (such as CTRL C) have the numbers divide by 10 then multiply by 12.. Example: cell I5 has ...
0
votes
0answers
198 views

Windows batch script to run a macro for Epsilon editor

I have some macros for Epsilon editor defined which we are using one by one on some files, but I want to run them all at once on some set of files. Sample macro: (define-macro "string" ...
0
votes
0answers
43 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 ...
1
vote
0answers
117 views

Add-in vs sharing macro file in Excel VBA [closed]

I am writing a Macro that I want my team members to have access to on their machines so we can use it to upload some monthly data stored on some space accessible on the Network. This is my first macro ...
0
votes
1answer
362 views

excel macro to look up data from a database and copy it to another excel file or sheet

I have an excel file which looks up and calculates data for a given date. It works as follows: You enter the date in a specific cell (input) and in the same sheet the required data appears (20 cells). ...
1
vote
0answers
88 views

How to program a kinesis foot pedal macro?

The manual says that you should press Prgrm+F11, at which point the lights will start blinking (which happens), then press the triggering key, in this case the foot pedal, then the lights should start ...
0
votes
2answers
200 views

How would I write a macro in Outlook 2010 to set all folder properties to “see all items”?

How would I write a macro to set all folder properties to "see all items"? I have hundreds of folders and subfolders and need to set the folders to see all items and I can't figure out how to write a ...
0
votes
1answer
2k views

Excel 2010: dynamic update of drop down list based upon datasource validation worksheet changes

I have one worksheet for setting up the data sources of multiple data validation lists. in other words, I'm using this worksheet to provide drop down lists to multiple other worksheets. I need to ...
0
votes
1answer
39 views

VIM: How to check whether the current script is running in a macro?

In a number of cases I have some vim script that I only want to execute when it is not being run in a macro. For example, in some cases I blink the cursor to remind myself where it is now (which is ...
0
votes
0answers
45 views

Summarizing data in Excel

I'm working on rolling-up a series of charts. I'd like an easy way to summarize by category. The original looks like the sample below but by week for the entire year. I want to know all of the AD ...
-1
votes
1answer
127 views

Excel 2010 VBA on-start macro execution - Error

I have been trying to create a macro to be executed every time I open the document. I tried to use the Open event, but it does not seem to be working. The code is below: Private Sub Workbook_Open() ...
0
votes
0answers
52 views

Macro to manage sport ranking and calendar?

I need to write a macro (or a different easy way) to manage ranking and calendar for curling tournament. The event will follow the Shenkel system first match determined by general draw after that ...
1
vote
1answer
144 views

How to cancel recording a macro in Vim?

Imagine I had recorded a macro and then I've occasionally started recording a macro into the same register. Can I interrupt the recording so that the original macro is preserved in the register? I ...
2
votes
1answer
610 views

VBA to move specific data from one column to another

I've tried requesting help with this before but have received no helpful responses. I need a Macro/VBA that moves any word in red from column A into column C as a list. However if the same word is ...
1
vote
1answer
81 views

Word 2010 Macro help - Convert table to fit print layout width

I have a bunch of word docs that I've converted from HTML, which look OK in web layout, but when we switch to print layout, they are chopped off on the right hand side. I have a macro I use to convert ...
2
votes
2answers
2k views

How can I compare two columns in Excel to highlight words that don't match?

(I'm using Microsoft excel 2010) OK, lets say I have a list of phrases in both column A and column B (see screen shot below) What I would like to happen whether it be with a macro, VBA or formula ...
1
vote
1answer
792 views

Importing Text in Excel 2010 - Overwrite previous imports

I created a macro, using the recorder, to add a specific .txt file in my Excel file, using a specific shortcut key, in a specific area of the open excel file. However, I've got this problem: when I ...
0
votes
1answer
2k views

Excel 2010 VBA - Trigger macro with ONE click on specific cell

Would you mind pointing a way to start a macro in Excel 2010 by clicking only once on a specified cell? I had seen a solution somewhere, but now I can't trace it back.