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
11 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 ...
1
vote
3answers
165 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 ...
6
votes
3answers
25k views

Can I make an Excel VBA macro available to all workbooks?

Is it possible to write a VBA script in one workbook, and use it in other workbooks in the machine? I guess I'm looking for a way to write a macro package. EDIT Following the instruction in the link ...
0
votes
1answer
19 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 ...
0
votes
0answers
24 views

Email Macro Assistance [on hold]

I am not experienced in writing VBA Macros & need assistance to create the following Macro. What I am working with is 25 rows of data in Excel where I need a macro written. The request is that the ...
0
votes
0answers
14 views

Plug-in command in Notepad++ Macro

I'd like to create a Notepad++ Macro executing the following commands: 1) Plugins -> Compare -> Compare. 2) View -> Word Wrap. Is that possible? Is there another workaround for the ...
0
votes
1answer
603 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). ...
2
votes
0answers
16 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
0answers
17 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 ...
0
votes
0answers
10 views

Macro stopped working and now have a password

I use 2013 Excel at work. We have a workbook with a Macro. The Macro is unresponsive and the workbook now has a password. No one chose a password. It did this without our knowledge. This ...
0
votes
0answers
4 views

Quicksilver - Keyboard macro to select all text to right of cursor

At one point, I had this set up on another machine, but I don't have that mac anymore. I would like a global override to have cmd+shift+right arrow select all text to the right of the cursor on the ...
-2
votes
0answers
13 views

macro to collect data from number of sheets to main page and need to add the sheet name that where the data collected

Please help me..,I need a macro to collect data(Student names) form number of Sheets(Class Name).all student names collected from sheet1, then a new column added with the sheet name (i mean ...
-6
votes
0answers
27 views

Need to figure out where to start with programming and making my own macros [on hold]

When I was a Windows user, I liked the program Macro Express because it was able to speed up tasks where I needed to collect data by doing repetitive key strokes, changing windows, etc. Now switching ...
1
vote
1answer
15 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
0answers
13 views

Getting Razer Blackwidow macro keys on linux

I've read Getting macro keys from a Razer BlackWidow to work on Linux and the python script didn't work for me so I compiled the haskell from source. I changed my product ID in main.hs and everything ...
15
votes
1answer
5k views

How do I assign a keyboard shortcut to recorded macro in Sublime Text

I have a bunch of macros which I have recorded and saved in Sublime Text 2. I'm trying to assign keyboard shortcuts to each of those, but I'm kind of lost as to how to go about doing this, I had a ...
0
votes
0answers
19 views

What is the fastest way in Windows to move the cursor to the URL box of the address bar? [on hold]

In windows, I'm using the URL address box for to-do notes, etc. So I figured a way to reach it via keyboard, which is : Windows-Key + 'B' , then Shift+TAB This is 4 button-presses. I feel that we ...
1
vote
2answers
4k views

Need macro to insert custom signature in Outlook 2007 email

I need a basic VB macro to insert a specific signature into an email message. Our support team uses a variety of different signatures to respond to different types of support needs. Currently, I ...
0
votes
1answer
4k views

How to customize Paste Value Excel Short Cut

I was reading in this other post about how to set up a macro to past values in Excel. I understand how to create he macro but I would like to set the keyboard shortcut to Ctrl d but excel pops up an ...
1
vote
2answers
2k views

Office 2010 macro issues

I have some macro enabled word documents that worked fine in Word 2003, but in 2010 I cannot get the macro security settings to behave properly. When I first open a macro enabled document, I get this ...
1
vote
3answers
106 views

Can you change linked charts to embedded charts in PowerPoint 2010? Or use relative links to Excel files?

I need to replicate a PowerPoint presentation across multiple countries then send the presentations to colleagues and give them the ability to edit charts. To do this I have created an Excel file ...
0
votes
0answers
11 views

When enter key is pressed, find the next instance of searched word

I have recorded the macro for the process of finding word. Whenever I hit enter button it will go to the next occurrence of searched word.How can I do it programatically using macros. When I click ...
0
votes
1answer
27 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
0answers
6 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
9 views

Why LibreOffice control is not updated?

I have created a few simple macros that create a dialog and read one of the controls text. The ReadWrite Macro is attached to a button. It reads a text from textfield and prints it. However when I ...
0
votes
1answer
4k 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 ...
1
vote
1answer
44 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
60 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 ...
-1
votes
0answers
15 views

Excel how to freeze a range

I have used a macro that copy a cell and paste it under the cell. So i have data in A5 and my macro moves data in A5 into A6 then it moves data A5:A6 into A6:A7 etc. Then i have for instance another ...
0
votes
0answers
291 views

Access 2012 - Can't find object

When opening certain macros, whether in design or run, I get ' Microsoft Access cannot find the object 'whatever the object name is>'. This only is on certain macros, but most of them work properly. ...
2
votes
1answer
2k views

Excel 2010 macro to separate a large data file into workbooks

I found some code which works perfectly to separate a file based on a column (line 31) into separate tabs within a worksheet. I just need it to separate the files based on a column into a separate ...
-1
votes
2answers
36 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
0answers
26 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
35 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
1answer
531 views

Can I remove an OTF macro from a Razer Deathstalker?

I recently bought a Razer Deathstalker, and the other day I managed to activate the OTF macro recorder by accident, so now I have random gibberish and key presses bound to regular keys, so typing ...
1
vote
1answer
22 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
0answers
6 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
3answers
507 views

Keyboard with hardware macros?

Are there any keyboards with extra programmable keys for which there is hardward-only support for macros? In other words, the macros can be programmed and played back on any OS without installing any ...
0
votes
2answers
50 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" ...
0
votes
1answer
94 views

Create a shortcut for Notepad++ to reopen a closed tab?

To reopen a closed tab in Notepad++ you press ALT+F&1. I was wondering if there was a way to make a macro or program to do this so that I can press link it to the shortcut CTRL+SHIFT+T instead, ...
3
votes
1answer
3k views

How to add a custom command macro in Windows 8 speech recognition

I have tried a few options but its not working for me. I am using Windows 8 Pro. Can anyone show me how I can write my own custom command macros for speech recognition in Windows 8? I have tried ...
-1
votes
0answers
26 views

Macro to update Date in Specific row in excel

I want macro to update current date in cells M10, M15, M18 and M19 Ex: If format of the date is 01-11-2014,then, macro should update cells M10,M15,M18:M19 with 1 ...
0
votes
1answer
4k views

Copy/move values matching a pattern to another column

I have a worksheet where we need to move all the values matching a pattern to different columns. For example, we have a B column with values that are one or more letters followed by one or more ...
0
votes
1answer
24 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
1answer
24 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 ...
0
votes
0answers
14 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
43 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
37 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 ...
1
vote
3answers
53 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
61 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 ...