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
12 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
98 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
6 views

Can a vim mapping trigger an Autohotkey macro?

I would like to trigger an Autohotkey macro using a vim mapping, is this possible? For example, to create a normal mode vim mapping in vim to enter CTRL-J, then use that to trigger Autohotkey. In ...
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 ...
0
votes
1answer
5 views

Excel 2007: View/focus on last rows when opening the workbook

I have about 4700 rows on my sheet. When I open the workbook, it always focuses on the first rows. I want it to focus/view on the last rows of the sheet instead. It doesn't have to select. In fact I ...
0
votes
1answer
17 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
8 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 ...
0
votes
1answer
81 views

Find and Replace upper case

I would like to use the Find and Replace function to substitute a number of words which are in all caps, normal style, by a font in which they are in small caps with the first letter of each one ...
-1
votes
0answers
11 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/...
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 ...
-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
3k views

Windows 7 (script): Create pre-defined folder structure

Is it possible to create a script, which can be activated through the right-click menu in Windows, which will create a pre-defined folder structure? Every time we get a new update at my work I have to ...
-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
38 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
2answers
3k views

Excel VBA macro to create custom lists from a selection

Hi I was wondering if anyone could help me create a macro that will add a selection to excels custom list. Typically to do this I select a a series of rows in one column, then I got to file, options, ...
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
55 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
vote
1answer
45 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....
-1
votes
0answers
28 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
votes
1answer
620 views

Excel: Merging multiple Rows/Columns based on one repeated cell

I need to merge the information of multiple rows and columns based on a common value for an specific cell. I guess I can use a macro here, as the problem is I have to merge a lot of information, ...
0
votes
0answers
27 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 ...
0
votes
2answers
284 views

VBA Code De-bugging in 2010 excel

Looking for some help in debugging some old VBA/Macro code to work in the newer version of MS Excel 2010. The macro in question is the "Material Rollup" function. The purpose of the macro is after ...
1
vote
0answers
30 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
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
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 ...
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
2answers
30 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 ...
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 ...
3
votes
1answer
8k 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?
-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
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 ...
0
votes
1answer
24 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 ...
1
vote
1answer
1k views

Macro to sharpen all images in word document

I have a 500+ page document with a lot of images. I need to convert all of these to grayscale and to increase sharpness by 40%. Both of these tasks can be done by right clicking each image and ...
0
votes
1answer
17 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 ...
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 ...
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
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): ...
0
votes
0answers
296 views

Run-Time Error - The directory name is not valid

I am using a domain computer, and I am unable to use a macro which saves a file to a specific location. I get the error message exactly in the title of this post. I've tried disconnecting and ...
1
vote
1answer
86 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 ...