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)

-1
votes
0answers
16 views

Excel Macro to add rows until today's date and update following columns accordingly

I got an excell sheet with 3 worksheets that I update like every 2-3 days manually by dropping down the date column and it automatically updates the columns based on the date. For example: Let's say ...
0
votes
1answer
7k 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
2answers
31 views

Excel macro to copy rows with unique name in column A to accordingly named wosksheets

I am an Excel novice, and would appreciate help with a macro which does the following. There are a total of 58 genes (column A) with 2 entries for each gene. The image only shows 4 genes. Upon ...
-2
votes
1answer
27 views

Simple excel macro and editing VBA, what changes do I need

I have a macro that I use from time to time. It successfully deletes the columns I want it too but it doesnt sort the columns as I want. When I debug the VBA I see it references the original excel ...
1
vote
2answers
4k 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
7 views

Accessing macro function for all documents

I have created a macro function as: Sub updateFontCC() Dim doc As Document Set doc = ActiveDocument Dim i As Integer For i = 1 To doc.Range.Characters.Count If ...
-2
votes
0answers
9 views

Creating a macro in excel that will copy and paste data from different worksheets [on hold]

I am trying to create a macro in excel that will copy all the rows in different worksheets that have the word "Rounding" and paste it into a new worksheet. Would anyone be able to help? Coy
0
votes
0answers
200 views

How to create an Outlook macro that updates a table's attributes to shrink a table to the contained text without wrapping?

Version: Outlook 2013 I want to be able to... Alter the font-size of the text in the table. (Done) Remove (uncheck) the "Preferred Width" attributes from the table, collumn, and cell active ...
3
votes
1answer
7k views

Can i stop a blackwidow macro while its being executed?

I'm trying to make a macro for my blackwidow keyboard, which has to be executed until i press a different button. Can anyone tell me how to do this, or how tp stop a macro from being executed halfway? ...
2
votes
1answer
3k 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
1answer
2k views

How to Prompt Before Send in Outlook 2010

I am using outlook 2010. I would like to receive a popup after clicking on the send button. The Popup should say "Do you want to continue sending the mail?" and it should have two buttons on it ...
0
votes
0answers
38 views

Excel 2010 - Combine specific sheet in >200 separate files into single worksheet?

I have tried solutions in other posts like this and so far nothing has worked :/ I have >200 separate excel files, and essentially I would like a specific sheet from each of these files combined into ...
0
votes
0answers
27 views

MS Word Macro to change string to Numbers in long documents?

I am as beginner as it gets with VBA and macro. I am looking to record a macro for MS Word documents that converts string to number. For example the document will have like (one thousand and four) or ...
0
votes
0answers
12 views

How do I create a macro in Excel for Mac?

I have found this thread on this topic How to get the list of sheet names of ms-excel? But I have no idea how to create the macro people are talking about. I will be grateful for your help on how to ...
-1
votes
0answers
35 views

How to create an intelligent macro script to automate tasks?

I want to automate a particular set of repetitive processes using a macro software. The one am using is "jitbit macro recorder". What it does is simulate mouse clicks and keyboard strokes. The problem ...
14
votes
7answers
6k views

Mapping Super+hjkl to arrow keys under X

I'm trying to map: Super+h -> Left Super+j -> Down Super+k -> Up Super+l -> Right globally under X. The idea is I don't want to leave my home row that often to use the arrow keys, so ...
1
vote
4answers
24k views

How do I get an Excel macro to copy data from a specific column and the same row that is selected at activating macro?

Example: I have selected any row and any column, let's say D6. The data I am looking for is in column H. So, I want the macro to copy the data in row 6, and column H, i.e. H6. If I have selected G14, ...
2
votes
2answers
52k views

Trigger macro with ONE click on specific cell

Would you mind pointing a way to start a macro in Excel 2010 by clicking only once on a specified cell? I had seen a solution somewhere, but now I can't trace it back.
3
votes
2answers
4k 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 ...
0
votes
1answer
16 views

If using radio buttons, do I need to save the file as macro enabled?

I have this .docx document in which I inserted some radio buttons. And each time I save the document I get this message. And I choose 'Yes' every time because as far as I know I'm not using any ...
3
votes
2answers
2k views

How can I keep every fifth row in Excel

I have a data set in excel with 3084 rows. I need to delete 4 rows, then keep one: deleting Tuesday, Wednesday, Thursday, Friday but keeping Monday to create a weekly rather than daily data set. ...
0
votes
0answers
4 views

Creating Macros that reference templates in email folders

I can create a macro to use a template saved on my local drive, but how do I create a macro to reference a template stored in an email folder? How can I access a template in my email on my iPhone?
0
votes
1answer
3k views

Sharepoint Document's macros

I'm trying to upload an excel document with a few macros to a 2013 SharePoint, I don't know if I can use the macros via "View in Web Browser" option. I cant get them working, although if I download ...
-1
votes
2answers
12 views

Map key combo as WinKey [duplicate]

I just bought a ThinkPad style desktop keyboard that has no Windows key. Is it possible to configure a specific key combo to behave like the Windows key?
0
votes
0answers
9 views

Office Templates (with macros) in CrossOver Office 2010

I have a very specific problem. I am a policy debater, and I'm trying to install a Word template called Verbatim http://paperlessdebate.com/verbatim/SitePages/Home.aspx on my Chromebook for ...
-1
votes
0answers
23 views

Excel macro or VBA script to create rows from columns

I have a monthly project time spreadsheet which lists each project as a separate row, and each day for the month across as a column, i.e.: I would like to create a macro or VBA script which will: ...
4
votes
8answers
22k views

Keyboard macro to change default audio device

Windows 7, Logitech G110 keyboard 2 audio devices (headphones and speakers) I am hoping to find a quick way to macro a key to switch to headphones, and a key to switch to speakers. Anyone have a ...
0
votes
2answers
4k views

Excel 2010 Legend key color based on text

Background I've an excel template. This template I populate with data by running a program I've written. The excel template has a pivot table on a sheet that get's data from another sheet that I've ...
0
votes
3answers
45 views

How to optimize VBA macro

I need your help optimizing this macro in Excel. I'm using it to generate data for labels for chemotherapy drugs in our hospital. The macro works fine right now, but sometimes it takes a long time to ...
2
votes
1answer
3k views

Pull Data from Excel Worksheet to Another Based on Defined Values

I have two excel worksheets which have data cells. I want that if a cell in column J equals a certain value, let's saying "Negotiating", then it automatically pulls that row to a new worksheet. The ...
0
votes
0answers
11 views

My Excel Macro book crash after enable content

I have number of macro workbook. when I open it on VDI network and click on enable content Excel crashes, and I am not able to work. But when I open this workbook on Laptop it works fine. VDI ...
0
votes
0answers
25 views

Shortcuts to move the cursor between languages

I am working on a document in Microsoft Word using two different scripts, namely Arabic (I created a customized layout keyboard using the Microsoft Keyboard Layout Creator 1.4, which has Arabic (Saudi ...
0
votes
2answers
351 views

VBA Excel 2011 for Mac: Create custom category for user defined function error

I created several functions i.e.: "cal_adval". I would like to add it to a new function category named "Custom Clearance" I read the documentation, and wrote this macro: Sub add_category() ...
2
votes
2answers
3k views

VBA to move specific data from one column to another

I've tried requesting help with this before but have received no helpful responses. I need a Macro/VBA that moves any word in red from column A into column C as a list. However if the same word is ...
1
vote
1answer
33 views

Disable all Microsoft Office macros globally for all users

Due to popular "locky" and similar malware out there I need to disable macros for all installed Microsoft Office products (Word, Excel...) globally for any user who logs in into a particular server ...
1
vote
2answers
2k views

Chart Series name referencing cell address Excel 2010 VBA

I am using Excel 2010. I have a XY scatter chart built and formatted the way I like. I reuse this chart many times, so I just copy and paste the chart into a new worksheet containing the new data ...
-2
votes
0answers
5 views

Cluster network issue

Does cluster head of a clustered network may change the data packets of nodes other than forwarding packets of nodes to main server ? In more detail, as every node of a cluster send their data to ...
1
vote
1answer
101 views

How to automate downloading several PDFs from a given webpage?

I am trying to download PDFs from this link. On clicking Read PDF, it opens a new window with PDF in it. On clicking the download button, it opens a dialog box and asks the user to specify the ...
0
votes
0answers
17 views

How do I accept tracking changes for a specific symbols and reject for the rest of the text?

I would like to accept tracked change only for specific symbols like manual line break and break section and reject any other changes. How can I proceed? I guess it should be a macros which looks for ...
0
votes
1answer
26 views

How do I identify partial duplicates in an excel list?

I have a list of over 1000 company names, however some are duplicated but they aren't exact duplicates (ie: Nintendo, Nintendo Inc, Nintendo Video games, etc), is there a way to identify the ...
70
votes
9answers
213k views

How to control master volume in Windows 7?

Some keyboards have volume controls on them that can be pressed anytime to control the master volume. My keyboard does not have that. Is there a way that I can create a key macro that will work like ...
15
votes
16answers
90k views

Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...
0
votes
1answer
27 views

How to run Sub with parameter in Excel VBA?

I have procedure in Excel VBA which is need range parameter and also will produce output range exactly in active cell. The code looks like this : Sub test(oSource as Range) Dim oTarget As Range ...
0
votes
1answer
51 views

add space after nth commas in Excel, Notepad++, or emEditor?

Notepad++ 6.8.8 I want to be able to turn several lines that start like this: 0,2,3,45,67,89,01,234,567,890,123,4567,8901 0,7,8,9,0,11,12,13,14,151,162,173,184 x,z,q,r,n,f,t,a,e,f,z,n,a into 0, ...
0
votes
1answer
29 views

Hardwareinventory - Copy Record with values in Access 2016 Web App

I want to make a WebApp in Access which help me inventory all our Hardware. Below is a VERY wip ERM for the Database behind it. Every CPU-Object is its owm physical thing (if we have 2x i5-3450 there ...
-1
votes
1answer
37 views

How do I solve “runtime error type 13 Type mismatch” in excel VBA when clearing contents?

I have some VBA code that clears contents from several cells. Most of those cells have data validation so that a value must be selected from a list of options (yes, no, NA), the rest are open for any ...
0
votes
0answers
29 views

Excel 2010, “Runtime Error '32809': Application-defined or object defined error”

I am having this error when I open up certain workbooks that contain macros. The files are stored on a network drive and this error only happens on a few computers which leads me to believe the ...
9
votes
7answers
57k views

How to turn hundreds of text URLs in Excel into clickable hyperlinks?

How do I turn a column of urls into hyperlinks, so that users can click on the url in a cell and have it open in a browser? I pasted 100 urls and each went into its own cell. When I double-click in ...
-1
votes
1answer
26 views

Excel macro to print 3 pages with same number and then increment

I have an excel sheet to print a set of 3 pages which I use for a timesheet. I need some kind of macro which can change numbers after every three sheets printed . So, the first three sheets are 0001 ...
0
votes
0answers
12 views

How to Create Keyboard Macro to Adjust Sound Level Momentarily

Basically what I'm trying to do is figure out a way to somehow reduce the sound output level of my system to a certain level (say half volume) and bind that to a keyboard shortcut. Ideally, the volume ...