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

Access 2013 How to prevent from saving a record

I had created a form in access 2013 to add records to a table but I'd noticed that if I close the form without saving the record access still saves it to the table anyway. I would like to know how to ...
-1
votes
0answers
9 views

Macro - Creates individual workbook based on template on sheet2 and data on sheet2

Option Explicit Sub CreateBooks() Dim rCl As Range, rRng As Range Set rRng = Sheet1.Range("A1").CurrentRegion.Offset(1) Application.ScreenUpdating = False For Each rCl In ...
0
votes
1answer
6 views

Macros doesn't load on powerpoint startup

I have created a powerpoint macros to run a batch file when slideshow starts. This is my code Sub OnSlideShowPageChange(ByVal SSW As SlideShowWindow) If SSW.View.CurrentShowPosition = _ ...
0
votes
0answers
13 views

Conditional Subtotal possibly in VBA

I have a long list of data into which my macro inserts blank rows everytime a certain data changes in column D. I am trying to find a formula (Macro code) that will subtotal the amounts in Column F in ...
0
votes
0answers
7 views

Control MS word add-ons using recorded/programmed macros

I have installed a Microsoft word add-on (not specified because this problem is likely common to many add-ons out there) and I want to add some specific functionality to it. I could be wrong but I ...
0
votes
3answers
24 views

Excel macro: Last non-empty cell in a column

This is a followup question to this one. The following formula can be used to find the value of the last non-empty cell in a column, in Microsoft Excel: =LOOKUP(2,1/(A:A<>""),A:A) My ...
0
votes
1answer
15 views

How do I prompt a user with file “Save As” dialog using a macro?

I created an Excel macro to replace data from "Quote" to "Invoice", but after running the macro, I wish for the macro to continue to run and stop at: "Save As..." mode so that the user can provide a ...
1
vote
1answer
23 views

How can I assign Excel keyboard shortcuts for macros that use keys other than Ctrl + {alpha character}

I would like to assign keyboard shortcuts to Excel macros that use keys other than the standard Ctrl + {alpha character}. Based on this post it sounds like it is possible but I am not sure how: ...
1
vote
1answer
28 views

Show increase in trendline by using Excel vba

I have data in c5:c12 (sales1) and I plotted a graph and a trendline of this data. I also have data in d5:d12 (sales2). I would like to show an increase, graphically, in my existing trendline by using ...
-1
votes
0answers
14 views

Excel, printing copies with serial numbers [duplicate]

I am trying to print 100 copies of a worksheet with each copy having a unique serial number (1000-1100). I want the number to appear in cell K63. I have found similar questions answered with ...
0
votes
1answer
31 views

when criteria does not match do nothing excel vba macro

I am implementing a macro that checks column E for dates that are 7 days away from current date. If cell date - current date = 7 then an email containing the row that has the matching cell, is sent ...
0
votes
0answers
8 views

Needing an excel macro to take me from the excel cell to the folder a specific file is in

I am torn between a database program or a excel macro. I want the line to have the high level data fields that I am looking for. If I want to be sent to the complete doc I just want to be sent to a ...
0
votes
0answers
3 views

Custom View Macro

The macro below is intended to change a button to switch to a custom view. However, it does not work, and I don't know why. I have a custom view called Campaign Details, but this is telling me that ...
0
votes
1answer
32 views

Trying to highlight unique values across multiple sheets in Excel 2007

I am trying to compare the values from column A of Sheet1 (which I have renamed "AR") and column A of Sheet2 (which I have renamed "Paste Here") and highlight rows containing values that do not exist ...
-2
votes
0answers
23 views

runtime error 1004 application-defined or object-defined error [closed]

Process--> I have a macro which is doing following process. 1-->Reading 4 files from a temp folder . 2-->When mapping the target then getting the below error "runtime error 1004 application-defined ...
-1
votes
0answers
14 views

Is there some sort of sandbox to start a program in and execute macros? [closed]

What I am looking for is to something like a "cron job" but for a program. Let's say I want this to happen every time at midnight. Program opens up, a button within the program gets clicked, delay of ...
0
votes
0answers
15 views

From Macro to Add-in: Word 2010

tldr; I'm not sure how I can get the Add-in to recognize the active document! The goal is to set the macro to an Add-in button. I have lots of forms that have endless amounts of the old form field ...
-1
votes
1answer
13 views

Macro to open word through excel

Sub test() Set myWorkbook = Application.Workbooks.Open(Filename:=[B1]) On Error Resume Next myWorkbook.Sheets(Cstr([D1])).Activate On Error GoTo 0 End Sub How the above macro works : Mention excel ...
0
votes
2answers
31 views

Hide rows based on the value of another cell

First, I've tried these threads, to no avail (1, 2, and others which I am prohibited to mention since my rank doesn't allow for more than two links). I am almost certain I'm just missing some simple ...
0
votes
1answer
30 views

Macro to autofilter across different sheets and paste result on a different sheet

I need to create autofilter across 3 sheets based on values selected on the three dropdown lists on a separate sheet on the same workbook. The 3 sheets have the same headers from columns A to AG and ...
0
votes
2answers
41 views

Is it possible to have an excel workbook automatically save as macro-enabled if macro is added to the workbook?

Currently, in Excel 2010, when I try to save a workbook that I have created as a .xlsx file but added a VBA function or subroutine to, Excel gives a prompt asking (in a round-about way) if I want to ...
0
votes
1answer
32 views

Macro in Excel To Add an extra row

I am creating a Macros in Excel that adds a row and formats it. The code works okay although i need the value for "i" to be a variable (instead of 20 as shown) depending on the number of entries in ...
1
vote
1answer
29 views

Excel VBA format footer that contains calculated value

I have a macro for my footer that uses the RIGHT and LEN function to pull strings from various cells within the worksheet. I've tested on various sheets and this works. ...
0
votes
0answers
8 views

How to use Jitibit Macro Recorder with double pointer?

So, Jitbit Macro Recorder basically allows you to make the mouse perform specific tasks, so I can perform redundant, repetitive tasks automatically. There's also a program called Pluralinput which ...
0
votes
1answer
38 views

Macro in Excel to add the date in ISO-8601 format

For some reason, Excel forces me to use my region for footers when I insert the date. However, it also doesn't auto update when the worksheet opens. Without the formatting this is a rather trivial ...
0
votes
1answer
92 views

Macro to copy distinct values from one Excel sheet to another

I have an Excel workbook that has the following sheets, "Main" and "Count": Now the "Main" sheet has the column B with list of IDs. Is it possible to have a macro on "Count" page to copy all ...
0
votes
0answers
12 views

Auto copy predesigned row to new row

I'm looking to create a function or macro that would allow me to create a new row based off of a initial design when new information is added to the sheet. As an example, see below: Row 1 would ...
0
votes
0answers
17 views

LIBREOFFICE WRITER - Changing some fontname throught a document

Normally the document use "COMIC SANS MS" font name. In my document I use four special characters ( club (U+2663), diamond (U+2666), heart (U+2665), spade (U+2660) ). These characters should come ...
1
vote
1answer
62 views

How to align column values with their matching value in another column?

I have several columns of data that I need to align with a master column. The following is an example of what I hope to achieve, but with a table containing more larger strings and more rows. The ...
0
votes
1answer
42 views

Macro to fill in cells from a column sequentially when I click on a button

I'm having a lot of trouble trying to figure this out. This is my layout: As you can see, I have 2 buttons. What I would like each button to do is: Each time I click YES, it will insert a Y ...
1
vote
1answer
136 views

How can I stop Excel from opening a second blank window when opening a file from Explorer?

When I open an Excel file from Windows Explorer, I always get a second Excel window as well. Annoyingly, when I close it, it doesn't close, but the other window does! This seems to be a common issue: ...
1
vote
1answer
15 views

I have over written my Ctrl+V function with a macro - how do I restore the original back again

I have over written my Ctrl+V function with a macro - how do I restore the original back again. I have lost the paste function of this shortcut key by over writing it with a macro.
0
votes
0answers
37 views

copy and paste according to a order in a column

I want a macro that will fetch data from Series B and Automatically paste it according to the serial of Serial A. ASeries B and Series A data are same but Series B is not ordered. So i'm looking for ...
1
vote
2answers
107 views

Need an Excel Macro to sum a variable length range

I am trying to create a Macro that is able to recognize how many rows have values above it and only sum that range. If you look at the attached image, I need to be able to click in cells B4, B10, and ...
0
votes
1answer
13 views

Access 2010 - Macro to set dropdowns to preset fields

I work with a form in Access daily in which I repeatedly have to type the same words into the same fields. I would like to automate this (those fields auto-fill to predetermined text when I press a ...
1
vote
0answers
60 views

Excel VBA that calls Powershell ActiveDirectory cmdlet, but Module won't load?

I have a powershell script I use to dump user and computer lists to csv files; it works great and I don't want to touch it much. It uses the ActiveDirectory cmdlet, and the Get-ADComputer and ...
0
votes
1answer
83 views

Combine duplicates in Excel based on values from 2 columns, produce the sum and and % from others, remove dups

I have been struggling with my Excel report trying to roll up duplicate rows based on 2 column values. Also need to calculate the sum of the 3rd and 4th column and calculate the percentage. Here is ...
0
votes
0answers
72 views

Excel 2010 shared workbook - image buttons disabled

I have several Excel workbooks which were originally created in a 2007 version. They are shared workbooks, and contain some VBA code, and are protected to prevent users from changing certain content. ...
0
votes
0answers
30 views

when filter takes out all data, macro copies the titles over. Why?

I am using a macro that copies multiple columns into other documents. I use filters to determine which other documents it should be inserted into. When the set of data does not contain data for one ...
0
votes
1answer
32 views

Vim `cpp` Syntax highlighter prematurely ends macros mid-word

FINAL EDIT: I have "manually migrated" this question to the new Vi(m) SE site: http://vi.stackexchange.com/q/2219/1060 My Vim syntax highlighter for ft=cpp is prematurely ending some macros ...
0
votes
1answer
25 views

how to run an powerpoint add-in from the command line

I'm trying to open a powerpoint from the command line and run an add-in, or alternatively add an existing macro to a powerpoint programatically and then run the powerpoint with the macro. I see the ...
3
votes
1answer
32 views

How to set up a Macro/Hotkey to convert or batch convert PDF to word (with OCR)?

I frequently (like 10+ times a day) need to convert pdf's to word. I use the "Save as" feature in Acrobat Pro. Is there any good way to speed up this process, and boil it down to one click? Ideally, a ...
0
votes
1answer
52 views

Is there a way to copy data with a macro/button filter?

I have a worksheet with employee ids on the top and dates on the side. Then I need to put a Y or a N at there name every day I have 96 employees so it's really long. Is there away with a button or ...
1
vote
1answer
97 views

VBA - Populate cell if adjacent cell is not empty

I have created a macro that opens and edits excel workbooks for me. Firstly, it adds a new column A and then changes the title for A1, B1, C1, D1. After this, I want to create some sort of formula ...
0
votes
1answer
20 views

Vim macro: increase last number of a line by 1

I have a csv file whose last column contains either integers, or the character "-". I need a vim macro that does the following: If last element of current row is "-": Turn "-" to "1" Else ...
0
votes
1answer
52 views

Is there a way to record macros to do things I would normally do in Windows explorer? E.g. Open an Excel file read-only? [closed]

Countless times a day, I go into Windows Explorer, shift-right click on an Excel file, Copy as path, then go into Run, type Excel /r (paste), which opens my Excel file as read only. Is there a way to ...
0
votes
0answers
7 views

Access 2010 - macro running

I have a macro running a series of Maketable queries. It runs one query then exports the data to a .csv file, and repeats the process with the next query. My problem is that for each query I have to ...
0
votes
1answer
42 views

Keyboard Hotkey/Macro Software [closed]

Im looking for a simple easy-to-use software, that can do the following for me: When I hold down spacebar, it actually taps it (click down, release, click down, release... etc.) And then stops when I ...
0
votes
1answer
78 views

How do I generate random numbers between a range in cells? [duplicate]

I'm wanting to create a button that generates a string of 10 random numbers into cells, and pulls the range for these random numbers from, for instance, in B1 and B2. Basically, I'm looking to use the ...
-1
votes
1answer
274 views

Excel macro to group rows based on a cell value

I have a hierarchical list of items in an Excel worksheet and want to create a macro to group each row based on a cell value that gives the level of indention. The data looks like this: Index Level ...