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

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

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 ...
0
votes
0answers
12 views

Selecting random entries from lists in Excel with VBA

In Column A, I have n number of names. In Column B, I have n number of Order numbers for each name. In one cell I will be inputting the number of orders I want to pick randomly. Once I input the ...
0
votes
1answer
30 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" ...
0
votes
0answers
11 views

Update links to another excel workbooks

I have a excel work books that I use VBA programmed macros to open serval another workbooks (WB's). In the main WB I have a lot fomulas that is linked to the another WB's. After open all files, I ...
-1
votes
1answer
13 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 ...
-1
votes
0answers
7 views

Word VBA to insert Relative Hyperlinks [on hold]

I'm looking for VBA macro to do the following: Search a document identified as CM1010 and find the following three types of document references to insert a relative hyperlinks for the following: ...
-1
votes
1answer
13 views

I want to set up Excel Macro IF ShowLevels to toggle. [on hold]

I'm trying to get a button to toggle between expanding and collapsing groups. I'm new at this, and I'd like to get it working. This is what I have: If ActiveSheet.Outline.ShowLevels(RowLevels:=1) ...
0
votes
1answer
66 views

Automatic backups (history) in LibreOffice (OpenOffice)

LibreOffice can create a backup copy when you enable it in settings (Options > Load/Save > General), but it saves only the previous state (one only). It has also an versioning feature (File -> ...
1
vote
1answer
31 views

Notepad++ macro for changing a certain part of a string

I want to define a Notepad++ macro that takes any string that contains "foo", and creates its new versions only changing the foo to "bar1", "bar2" etc. so if my file contains abc_foo_def when I ...
0
votes
0answers
11 views

OSX macro to simulate holding down mouse button

I would like to setup a keyboard macro on a Mac OSX that, when triggered by a keyboard command, (say ctrl+m), simulates the left mouse-click button being HELD DOWN. When I hit the combination again, ...
1
vote
0answers
14 views

How to replace fonts of some characters as typing in Microsoft Word 2013

I want to replace fonts of digits and some other characters automatically as I type in Microsoft Word 2013 (something like word Auto-correct option). How can I do this by Macros?
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 ...
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 ...
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 ...
-2
votes
2answers
129 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 ...
0
votes
1answer
20 views

Include in user defined macro fails

I'm trying to use gpp (Generic Preprocessor) to add some additional information before and after an #include. The code is as follows: \define{\code{filename}}{PRE \include{\filename} POST} ==> ...
0
votes
1answer
10 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 ...
-1
votes
1answer
25 views

How can a macro be created to insert a text box pre-populated with text in Word 2010?

I am attempting to create a Macro to insert a textbox populated with predetermined text when a shortcut key is selected. I am able to record a Macro to generate the text but I am unable to get it to ...
0
votes
1answer
46 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 ...
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
vote
2answers
3k 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
2answers
55 views

Chart macro displaying incorrect labels from non-sequential visible rows on filtered worksheet

This macro displays text labels from the source worksheet when double-clicking a dot on a scatterplot chart. The chart is updated when the source worksheet is filtered on any of several columns. The ...
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 ...
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
0answers
31 views

Update to: Macro to merge cells in a column if the same rows are merged in a different column

I have a large (over 10k rows) spreadsheet with text data I want to concatenate from multiple rows into a single row. The text data corresponds to a date that is in a merged cell in a neighboring ...
2
votes
2answers
72 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 ...
0
votes
0answers
22 views

My macro's print cell formulas instead of spreadsheet

Excel 2013: I wrote a macro to print 2 copies of a selected portion of my spreadsheet. When I activated the macro, it randomly printed out my cell formulas instead of the sheet. Tyson: here is the ...
1
vote
1answer
165 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 ...
1
vote
2answers
44 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" ...
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 ...
2
votes
1answer
65 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 ...
1
vote
1answer
30 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 ...
1
vote
2answers
119 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 ...
2
votes
1answer
51 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
51 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 ...
6
votes
3answers
26k 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
60 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
17 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
647 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
47 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 ...
0
votes
0answers
8 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 ...
1
vote
1answer
26 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
29 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 ...
16
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 ...
1
vote
3answers
193 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
17 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
89 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
16 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
74 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 ...
0
votes
0answers
301 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. ...