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
41 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
244 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
41 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
15 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
497 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
31 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
56 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
61 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
73 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
161 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
1answer
145 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
50 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
24 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
1answer
405 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
293 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
91 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
43 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
73 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
169 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
260 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
177 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
129 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
61 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
516 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
44 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
32 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
66 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
22 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
82 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
265 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
43 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
123 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
90 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
297 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
204 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
35 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
88 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
152 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
94 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
75 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
32 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
103 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
121 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
200 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?