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

Excel: Add new rows to a table with a subtotal row, when data added to a specific column on the last row

How do I get an Excel table (with a subtotal row) to automatically add a new row when I enter data in column C of the last row? At the bottom-right of the table I have 3 cells with basic SUM formulae,...
0
votes
1answer
41 views

Export/Import Macros to/from Nox APP Player (Android Emulator)

I am using Nox APP Player (3.7.0.0) on Windows 7 to run Android Applications. Nox includes a Macro Recorder, I try to figure out how to export and import saved macros.
0
votes
1answer
15 views

autohotkey simultaneous keystrokes with repeats

I got this right now settitlematchmode,3 SetKeyDelay, 350 ^o:: $stop := 0 Loop, { controlsend,,{a 30},ahk_pid 12144 controlsend,,{a 30}{s 30},ahk_pid 12144 controlsend,,{s 30},ahk_pid 12144 ...
0
votes
1answer
5 views

Outlook 2010 - Macro to run Quick Step then categorize

I need a macro to first, select my Quick Step named "NTP", then categorize it as "Vacancy" before I send it. I added the categories selection drop down to MY QAT already so I can add categories to ...
-1
votes
0answers
9 views

EXCEL with macros, locked worksheets STOP WORKING

I am using Microsoft Excel 2013. When I select some columns in any of worksheets (or something like that) and right-click, then Excel stop working. Workbook properties are: contains macros locked ...
0
votes
2answers
30 views

Advice for combining right-click context menu actions in Windows?

For windows 10 is there a method to combine context menu actions into one click. In particular, I'm after a method that will allow multiple anti-virus and anti-malware programs to scan a single file, ...
-1
votes
0answers
17 views

Macro from source file to destinationfile

I have a source file with a macro in it (.docm). This source file is used to merge data from an excel sheet. The source file is used as a source :P and therefore word opens a new file where the ...
-1
votes
0answers
10 views

How using (office 2016) Excel VBA, Auto copy and/or save a web page image

EXCEL 2010. After navigating to a web page using Excel VBA I wish to copy an image into excel AND/OR save it to a documents folder IE: <img alt="" src="/images/rp_251x251/Product/94031/...
-1
votes
0answers
14 views

Macro replaces values in different cells, only first time used in sheet, how can i fix this?

I co-created a macro that toggle's between European and American data format. But when I run it for the first time in a file it replaces the value in to the first empty row from above. (when i convert ...
1
vote
1answer
32 views

Can't make the import sheets from directory function dynamic?

Can I modify the code below into a dynamic import of sheets, so I can run it in any sheet from my personal macrobook instead of a sheet called import-sheets.xls? Found the code for importing below. ...
0
votes
1answer
8 views

Running Macro disables formula entry

Run a Macro on an Excel 2007 workbook, now formulas no longer work in the modified workbook? I can type a simple (like "=5") in a blank cell and hit enter and what I typed is shown, not the result of ...
-2
votes
0answers
16 views

Combine Certain Part of Certain Tabs From Hundreds of Workbooks

I'll try and be as clear as I can. What I need seems very simple but I'm really struggling (I'm fairly new to VBA). I have 700 separate workbooks that I need to combine, removing the duplicates as ...
0
votes
2answers
36 views

Making Text To Columns Range Dynamic

I would like to make the text to columns range dynamic in my macro. But if i try to put the myRange in there it doesn't work. I can't find any information around the web to make the text to columns ...
0
votes
0answers
9 views

Sync Two Files for Collaboration

So I have a group of git repositories (on Windows) that I am using to collaboratively write some papers with in latex. For these projects I have a file: macros.tex that I want to use for all of them. ...
0
votes
0answers
13 views

Microsoft Outlook 2016 Custom Fields

Is there a way to add a quicktask or button to automatically insert dynamic data into an email? For example when I respond to an email with several questions I would like to type my responses within ...
0
votes
0answers
20 views

copy data from one opened excel workbook to another opened workbook excel VBA

I try to copy data between two workbooks which already exist but it didn't work. I don't know how to write a code without opening two files every time I run the macro. Sub CopyRangeToAnotherSheet() ...
0
votes
0answers
7 views

Is it possible to share an Icon which is created in my Outlook 2010 Quick launch toolbar, with my team members?

I have written a macro in Outlook 2010 to automatically generate an Outlook template form on clicking an Icon in my "Quick Launch toolbar". But is it possible to display this icon on my team members's ...
2
votes
1answer
51 views

Macro to autofill columns in Excel

I've recorded a macro in Excel that fills the columns with formulas.  However, it's limited to the range I was using in my test data, i.e., it doesn't fill down to the last row of data when I use a ...
0
votes
0answers
12 views

Split Excel sheet to Multiple sheets

can anyone help me out on how to split data in one excel sheet to multiple sheets based on two columns criteria us VBA
0
votes
0answers
6 views

How to make Camtasia Macro?

I'm working on Windows 8.1 where I have admin control. I am working in Camtasia making tutorial videos. For every course that I make, I need to export 20 or 30 videos, so naturally I would like to ...
-1
votes
0answers
26 views

VBA Mail merge save individual docs not working

I have this code which worked before, so I'm not sure what's gone wrong. As far as I can tell the code stopped working after I edited my template, but I can't find anything online about the template ...
1
vote
1answer
43 views

PowerPoint VBA - Run Macro When Slide Changes in Edit Mode

I know I could do the following to run code when the slide is changed in presentation mode - Sub OnSlideShowPageChange() Dim i As Integer i = ActivePresentation.SlideShowWindow.View....
0
votes
0answers
26 views

Formatting similar MSWord (pasted from MSExcel) tables in batch

I've got a lot of similar spreadsheet (same dimensions, different numbers) in MS-Excel, like this : To present them in my report in MS-Word. I have to format them in this way : To avoid ...
1
vote
0answers
27 views

How to Mirror Cells when the source is a data validation list? (Excel 2010)

I have a workbook with two tabs. The first tab is being used as a table for data validation lists I'm creating in the second page. For example, one list is called "Supervisors". This list starts cell ...
0
votes
0answers
15 views

Word 2010: Macro or Automatic Method to Remove Space Between Table Cells

I have a large document full of tables that need to be formatted, including removing the spacing between cells. I currently use a macro for most table formatting and was hoping to incorporate this ...
0
votes
0answers
23 views

Excel Expanding Selection within IF THEN

So I have this code in a few related macros, I tried integrating the D_CN into the main macro, but if would always fail at that line, so I moved it to a call, and it worked. What I want to do is get ...
-1
votes
0answers
16 views

copy data against unique id in excel macro

Sheet 1 contains ID User1 User% User2 User% User3 User% Count 1396865 a 60 t 78 e 92 3 1458125 s 58 1 ...
0
votes
1answer
23 views

Send bulk mail using Excel VBA

Was working on a project which will be sending bulk mail to different people if the conditions are met. Conditions : Column U contains the final status (Open or WIP) (will not send if Closed no ...
0
votes
0answers
23 views

Apply formula to cells with data

Is it possible to apply a formula to cells with data without using macros? For example, user enters "A3 A6 A8" in a cell, and then it applies UDF "CONCATENATEREF()" to that cell that gets those ...
1
vote
1answer
39 views

Splitting one Row with Multiple Columns into Multiple Rows

So I picked up this VBA code ... Sub NewLayout() For i = 2 To Cells.Find("*", [A1], , , xlByRows, xlPrevious).Row For j = 0 To 2 If Cells(i, 3 + j) <> vbNullString Then ...
0
votes
1answer
16 views

Word Macros missing from a word doc in the network drive

I had lot of macros/VBA scripts for processing comments, merging etc in one few he word doc(word 2013)files on shared drive. i changed my computer and now i don't see any of the macros in those ...
0
votes
2answers
29 views

How do I use the delete key for a macro shortcut?

I would like to use Ctrl + Del for a macro shortcut. How can I do this ? Something about using Application.OnKey seems to pop up a lot, but I don't have ANY idea what that means. Can someone please ...
1
vote
1answer
13 views

Libreoffice macro basic: skip to next paragraph test for upper case

I'm trying to write a macro, and I need to skip to the next paragraph, where I will test the first letter for capitalization. I've spent hours and have only found inaccurate or hard to follow ...
1
vote
1answer
82 views

Macro to loop through a web query - keeps bombing

I have built a macro intended to loop through stock tickers and in a column and use a web query to pull data on those stock tickers from yahoo finance It runs fine for 10,15,20 web queries but ...
-1
votes
1answer
31 views

Compare 2 sets of data in EXCEL and return what it should be

I need some help with comparing 2 sets of data in Excel (see screenshot below). As you can see I have data from 2 sources. Source 1 is the correct data. Source 2 may have been correct at some point ...
0
votes
0answers
13 views

List Sort with New Rows - Excel Macros

I am trying to record a macro that sorts my list, but am currently at a wall - I need this sort to adjust to my list depending on adding/removing rows. My current code scans the list for which cell ...
1
vote
0answers
15 views

How to auto-update exports of a document?

Assuming I have a document Report.docx which gets frequently updated and has exports as say Report.pdf and Report.md. How do I adjust Word to automatically update the PDF and Markdown-Versions of the ...
1
vote
1answer
49 views

MS word: a macro to turn ON/OFF some proofing settings

What macro could turn ON/OFF some proofing settings? (Unfortunately macro recording doesn't record the setting change) I'm looking for a way to turn ON/OFF 2 proofing settings (at the same time): ...
-1
votes
1answer
69 views

Best way to prevent running malicious/virus macro on PC

I've got a question. Could You provide some hints/solutions about preventing running suspicious macro's in Office apps? What I've already know: there is a possibility to turn off all macro's without ...
0
votes
0answers
8 views

assistance on one of your macros

I used one of your macros and was wondering if it's possible to alter accordingly for my use. the macro you advised is as follows: Sub PrintCopies_ActiveSheet() Dim CopiesCount As Long Dim ...
0
votes
3answers
107 views

Linking two excel sheets on different computers without sharing files

I have two excel sheets, both are linked. one is input sheet and another one is output sheet. the data entered in input sheet updates on output sheet automatically as both are linked (both sheets are ...
1
vote
1answer
42 views

Send separate attachements in Outlook 2010 to separate email addresses

I have separate attachments I want to send out to 70 different email addresses. Is there some kind of macro or script one can run to make this possible instead of having to send each email one by one?
0
votes
1answer
36 views

Execute batch file on computerA to open excel file and trigger macro on computerB

So basically, the reason why I need this is because we can't install excel in the server, so we will have to use another server(computerB) to host all our excel files and macro. Current process is ...
0
votes
1answer
38 views

How do I set up a macro where it will do the following actions each time

I'm a complete newbie here and am stuck with a task I have to repeat over the next few days. I would very much appreciate your kind help. Thanks so much in advance. Setup: There are 2 sheets. ...
-1
votes
1answer
54 views

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

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
10 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 IsNumeric(doc.Range.Characters(...
0
votes
2answers
39 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 ...
0
votes
0answers
36 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 (...
1
vote
0answers
66 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
19 views

How do I create a macro in Excel for Mac? [duplicate]

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