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

Excel worksheets not seeing their VB code

The form buttons and controls on all my worksheets suddenly stopped working. The behavior is like what you see before you respond to the security prompt-- "enable macros?", that is, when you ...
1
vote
2answers
867 views

How can I make a Msgbox pop up over other application?

I have an Excel macro that deals with thousands of lines in several tables and do some copy/paste/analyze/combine... operations. it takes almost 10minutes to run it fully. I added a MsgBox "Job Done" ...
2
votes
2answers
5k views

Add button to copy Excel rows

I want to add a button on a row in a spreadsheet that copies the contents from one cell to another if and when I click the button. I already have found the code to do this, however, I want to be able ...
-2
votes
2answers
2k views

highlighting duplicate rows in excel by VBA macro

I have a matrix which includes different/same values in first column, and different values in first row. I would like to compare all rows and highlight duplicate rows. For each row, it should check ...
2
votes
1answer
796 views

Application and Object Defined Runtime Error 1004 - using for loops to populate Cells(x, y)

I'm using the below code to try and find the intersect of Var1 and Var2, and populate the value into my userform that I'm running. I have no problem finding the intersect, but every time I try and ...
2
votes
1answer
602 views

Word macro to change page color

I am attempting to create a Word macro (Microsoft Word Professional 10) to change the page background color. I began by recording the keystrokes - this is the recorded macro: --- Sub WritingLayout() ...
1
vote
1answer
246 views

Assistance with Excel macros

My company uses Excel to track inspections and maintenance of portable fire extinguishers and I'm trying to add some functionality to it but don't have the first clue about how to do it. I'll do my ...
0
votes
1answer
374 views

Copy Full worksheet including multiple defined range names using macro or VBA

I've been trying to build a workbook for my company to use to track sales. The problem I'm running into is that I want each user to have their own workbook saved on their local computer for their ...
2
votes
1answer
853 views

Outlook macro to remove text and insert signature

(Note: I've never messed with VBA before; sorry for probably terrible code!) I'm trying to make a macro that first removes paragraphs containing specific terms (hardcoded into the macro), then sets ...
1
vote
1answer
12k views

How to use Excel 2010 VBA to set series line color, marker fill, and marker line color

I am trying to write an Excel 2010 VBA subroutine to format charts according to a predefined (i.e., defined by me) standard. The particular attributes that I want to be able to set are merely the ...
2
votes
2answers
11k views

Can't click on ActiveX control in Excel 2010 Standard

I have a .xlsm file that has ActiveX control button with a module macro assigned to it. Problem is I can't click the ActiveX button from my Excel 2010 Standard. I tried to repair and reinstall Excel ...
1
vote
1answer
405 views

How to highlight multiple searched words in a document?

I have a file which has words to be searched in it. I want to highlight those words in active document. For example: style.docx: school Agro commercial abovementioned some words physics Active ...
0
votes
1answer
1k views

ESC key on laptop keyboard not working - use a macro instead

I spilled beer on my laptop and now the esc key on my laptop’s keyboard does not work. I have Windows 8 installed on the laptop. Is it possible to define a macro to simulate the esc key? I am ...
0
votes
1answer
27 views

How to edit Sublime Text 2 Macros

How can I edit Sublime Text 2 Macros? What program to use to open the file (example - MyMacro.sublime-macro)? Also, how can I delay the keyboard typing in playing the macro? I hit record macro, then ...
0
votes
0answers
36 views

Macro to increment date from a start date to finish date

I'm a beginner in macros. I have start_date value in cell B4 and end_date value in cell C4. I need a macro that can write the dates from a start_date (the saturday just before the start date) to ...
1
vote
0answers
102 views

MS Word 2010 - How do I create a universal macro that will auto-insert a header if none exists?

I'd like to create a macro enabled template that will automatically insert a header into a document if none exists. This is in order to work around a printing issue that cuts off the top of the ...
1
vote
2answers
186 views

TeXstudio select whole line

I like the CTRL+L shortcut in SublimeText and would like to have it in TeXstudio, too. What it does: It selects the whole current line and places the cursor at the beginning of the next line. That ...
1
vote
1answer
46 views

Outlook 2007: Is There an Event That Fires If a Rule Is Being Enabled or Disabled

I have written a bunch of macros that allow me to enable or disable a specific Outlook rule (i.e., delayed sending of messages) via a toolbar button. They also change the button's appearance to show ...
0
votes
1answer
411 views

VBA code to select the first shape in the current active paragraph

In Word 2013, I need a simple VBA code in my macro which selects the first shape that exists in the current active paragraph. Note: the shape that I need the code to select is a custom shape that I ...
1
vote
2answers
7k views

Macro for cleaning all sheets in a workbook (VBA - Excel 2010)

I have a macro file with 5 sheets and I would like to add a VBA command button into the same file to clean all workbook contents with a single click. Does anyone know how to do it by using VBA on ...
0
votes
1answer
150 views

Macro to merge data on to template

I am attempting to basically do a mail merge in Excel. I would like to take employee data from one Excel worksheet and populate fields on an Wxcel template. So far I have written code to open the ...
0
votes
2answers
3k views

how to automatically run an Outlook macro?

i have developed an outlook macro and want this macro to run automatically without any prompt or mail from the user whether the outlook is on or not. Private Declare Sub keybd_event Lib "user32" ...
1
vote
1answer
48 views

file type association error

i keep my doskey macros in a separate file with .macro file extension, and can load them using doskey /macrofile=macros.macro for the specific console session i want to use windows os feature of file ...
0
votes
1answer
532 views

Open a Specific File in a Specific Folder, along with a Specific Sheet

The code below opens up a specific file in a specific folder, but not a specific sheet: Sub test() Dim myfile As String myfile = Cells(1, 1).Value & Cells(1, 2).Value & ...
0
votes
1answer
367 views

excel macro to reset/refresh a table column having dropdown

A newbie to excel macro so kindly bear if my question looks stupid. I have created a table (listobjects ) in worksheet having four columns. The fourth column is incorporated with drop downs through ...
0
votes
1answer
556 views

Copy Active Cell Comment in Excel into a new word file

i do not know much about Macros, is it possible someone could help me out. I have a simple excel file with names of Clients that have a lot of comments on each name. is there a fast way other than ...
1
vote
3answers
125 views

Checking whether a label exists between two other labels in a column

I have a column (call it A) in Excel lists off different items and their properties. Every item has the word "Type" associated with it and so there is a cell with that label in column A so that in ...
0
votes
1answer
39 views

Get buffer with all macros expanded in org-mode

I'm trying to troubleshoot some macro expansions in my org-mode file, how to I get a buffer that is the org-source with all org-mode macros expanded?
0
votes
1answer
579 views

Tracking Username and datestamp when the user open the sheet

I have written the below code in the VBA code sheet. Private Sub Workbook_Open() MsgBox ("Welcome to Tracker, " & Application.UserName) End Sub Result is " Welcome to Tracker, Sakaray, Kiran" ...
-1
votes
2answers
90 views

Empty email content with macro

Using the thread Here I have created a macro that will open up a template in a new message window. My signature is still at the bottom though. I want to empty the email content before adding the ...
0
votes
1answer
253 views

Returning non-editable MathType equations to their original size

I have a Word document with about 200 pages and .docx format. There are many MathType formulas in it. After many edit on my file, most of the formulas converted to picture. I did this but it doesn't ...
1
vote
1answer
400 views

Macro: Insert a new row above a cell containing a different numbers

I have an excel with two columns. Column A contains numbers and column B contains text data. Numbers are continuous like 1 2 3 with several blank cells between them as shown below. For example: 1 ...
1
vote
1answer
677 views

How to export full data from excel as a csv using macro?

I want to export an excel file as a csv using macro, but my code is only exporting the header only. How to export the full data? Here's my code: Sub CSVFile() Dim My_filenumber As Integer Dim ...
1
vote
1answer
5k views

EXCEL - EXTRACTING Data From Multiple Worksheets where the layout is varied

I have a spreadsheet which contains Bill of material data and Labor costs for manufactured parts. The first worksheet contains the master part numbers for the assemblies Each Worksheet represents the ...
0
votes
1answer
74 views

excel copy past repeat macro

At the moment I am working on a research project for my university in excel. Now I have a certain range BF1:DJ293 which has to be copied and past for 238 times to the right. So this range has to be ...
0
votes
4answers
8k views

Combining all combinations of data from three columns in excel

I have a few columns of data that I would like to combine, and get each unique combination. Concatenating across a row or set list is easy enough, but I would rather not have to enter each possible ...
-1
votes
1answer
531 views

How Can I Comment a Block of Text in Microsoft Office Visual Basic Editor?

Sometimes when I'm writing a macro in Excel's Visual Basic Editor (VBE), I want to comment out a block of code to test the macro without it. I know I could go to each line and type an apostrophe ('), ...
1
vote
1answer
4k views

How to create a macro in Outlook 2010 to add the the date to the subject line

I am new to the VBA format of writing code and I have been researching how to get the current date to AUTO input into the Subject line of an email when commanded. I need to know how to complete the ...
-1
votes
2answers
45 views

Is there a way i can copy this macro i made but have it change for the next tickbox

I have made this macro to Select cell A3 copy the value and paste it into cell Y3. it then clears cell A3 as that's a dropdown box, by doing this the dropdown option can be now selected in A4. ...
0
votes
1answer
365 views

Macro to create a text file with values from cells and text

Im trying to create a macro in excel that creates a text file which some of the parameters are on excel cells. The output would be for example: The kid is 'cell (1,1)' old. His name is 'cell ...
0
votes
1answer
183 views

Doskey Variable Expansion

I'm thinking the answer to this question is no, but it shouldn't be. From the command prompt normally, the following (as an example): C:\> FOR %I IN (*) DO ECHO %~xI would give me the ...
1
vote
0answers
332 views

How can I open a PDF to a certain page from within excel?

I would like a macro code for Excel 2013 that will open up a certain page upon clicking a button in the excel cell. I am using the below code, but it is working intermittently. Please help with a ...
-1
votes
2answers
4k views

Use Excel VBA If value in column a is not in column b then add value to column c

Dim i As Variant 'For i = 1 To 5 For Each i In rngWatch Dim c As Variant c = rngWatch.Cells(i, 1).Value If i <> rngReconcile.Cells(i, 1).Value Then MsgBox i ...
0
votes
1answer
157 views

Creating a macro with .sh

so I would like to write a script that will be used in the following way. ./MakeMacro 1 The basic form of the script looks like this: #!/bin/sh ...
-2
votes
1answer
61 views

What formula can I use to colouring in columns?

I am creating a planning spreadsheet for the operators to use on the shop floor. Products have a specific time in which they are made. All I want to do is, when I type a product name into ANY cell, ...
1
vote
0answers
497 views

Macro to copy multiple rows from one worksheet to another and then copy the headings into copied columns

I am new to macros and I have developed this macro that allows me to take rows that has data in them from cells B-G from Workseet "master 1" starting from row 11. I take this data and then copy it ...
0
votes
1answer
3k views

Macro: Insert a new row above a cell containing a value

I have a column containing the following values: A1 = 0 A2 = 1 A3 = 3 A4 = 4 A5 = 0 A6 = 1 I wish to select column A and insert a new column above any instance of 0. I have tried the following code ...
0
votes
2answers
392 views

How to add commonly used (non-signature) phrase in emails?

I have a text line with a hyperlink that I would like to readily use in composing emails. It is not a signature, so it doesn’t fit there. How can I build a macro that would allow me to add this text ...
1
vote
1answer
36 views

How to select a cell relative to a button with a macro?

I am trying to create a macro in Excel which I can assign to a number of buttons (one in each row), each of which will operate on the data in the row in which the button is located. Is it possible to ...
1
vote
1answer
739 views

Reset Numbered List with Text Style VBA macro MS Word

I'm trying to make a VBA macro to create a Word document from Excel... Currently I'm having issues with setting up the Lists properly. I want the list indexes linked to my 2 header types. Like so: ...