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
13 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 ...
0
votes
0answers
16 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
6 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
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
0answers
43 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 ...
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 ...
0
votes
0answers
51 views

Microsoft Excel - Run-time error '1004': Application-defined or object-defined error

I received this workbook from a co-worker. Each time I run the marco I get an error that says "Run-time error '1004': Application-defined or object-defined error". All I believe this marco does is ...
0
votes
0answers
19 views

Automatically adjust row height with text wrap and merged cells

I'm copying text from worksheet 1 which has merged and wrapped cells in the same row, into a cell on worksheet 2, the cell in worksheet 2 is text wrapped and merged with other cells in the same row ...
0
votes
0answers
79 views

Opening Google Chrome with macro instead of IE

I have a question regarding a VB macro that opens automatically a file in IE 11. The problem is I cannot get the download prompting to disappear (believe me, I've tried everything from Tools in IE, to ...
0
votes
0answers
39 views

Need a Word doc “Submit” button which attaches doc to Lotus Notes 8.5 email with defined recipient

I need to create a "submit button" (Macro) at the end of a Microsoft Word document template form. When button is clicked it attaches the document to a Lotus Notes e-mail (we are using 8.5) and has ...
0
votes
0answers
24 views

How can I protect excel macros - Office 2013 on OS X

I've Googled how to protect macros in Excel. I keep getting directed to go to "project properties" under "tools" in the VBA editor. However I can't actually find this option. I'm guessing its because ...
0
votes
0answers
42 views

my code works fine as a macro yet fails when i run it in a button

So far, one line is failing as i try to pick apart the macro that works fine as a macro but fails when i copy the code to a command button click... Sheets(c.Value).Range("a1:i330").Copy Destination:=...
0
votes
0answers
25 views

Modify properties of tables in batch

I am working on a MS word document which contains several tables, and I want to modify the properties of all of them at once, such as alignment, text wrapping, borders and shading etc., and either for ...
0
votes
0answers
47 views

How to create macro in excel to print selected cell and cell nexto it

I have an excel sheet which I fill in each day, is there a way of printing a selected cell say B2 and the cell to the left B1 to a dedicated label printer? If I select the bottom set of E numbers I ...
0
votes
0answers
227 views

Applescript/Automation in Outlook 2016 for Mac

Im trying to script some automation for some repetitive tasks I do in my workflow. My script (as of now) needs to accomplish only a basic task, but nonetheless, timesaving. I need it to (when called ...
0
votes
0answers
17 views

Excel 2016 formula (from macro) not being calculated

I am using Office 360 (or Office 2016 by another name I believe). I have created a macro with the following code: Function CheckColor1(range) If range.Interior.Color = RGB(217, 217, 217) Then ...
0
votes
0answers
8 views

Razor Black Widow - Manually Edit Macros

I love Razor's hardware, but their software is absolutely terrible. Is there any way of editing macros so that I don't have to go through Razors UI? I imagine there is some XML file sitting ...
0
votes
0answers
55 views

Macro that can import data from a worksheet to another worksheet but placed on specific columns

Can someone kindly assist me in creating a macro that can manipulate data as needed? source file: [2 columns] [05:51:59] SANJEEV: Hello [05:52:03] Dennis: Hello, Sanjeev. [05:52:05] SANJEEV: HI ...
0
votes
0answers
26 views

Sublime Text 3 - Find and Replace

I have a rather large page of code where none of the test cases were numbered via line comment. The numbering comes in handy when a test fails, so we can quickly find the failing test case and mark it ...
0
votes
0answers
161 views

VBA/Macros Runtime Error Fix (Run-time error '13': Type mismatch)

Run-time error '13': Type mismatch Is the error code. A previous person made a macros which hides all blank rows and assigned it to a button. Recently someone made some changes which affected many ...
0
votes
0answers
39 views

Formatting paragraphs in Word based on leading characters

I'm trying to prepare some VBA code to be easily readable, so I'd like to highlight all the comments in the code by applying a more visible Style. However, there's quite a lot of them, so I'm looking ...
0
votes
0answers
9 views

Pasting entire macros in a remote console shell

I am configuring a server using its remote console (which is not SSH, as I haven't installed the OS yet). Unfortunately after a long series of driver failures I end up repeating typing the following ...
0
votes
0answers
43 views

Creating a dropdown submenu in PowerPoint

I would like to know if it's possible to create a dropdown submenu in PowerPoint like the one for inserting a WordArt: If it's possible can you share with me some documentation about this?
0
votes
0answers
23 views

EXCEL macro opens document but does not ask to “update links”

I have an WORD doc with links to cells in an EXCEL document If I open the linked document manually, it asks to [Update automatic links] and works perfectly but, when I use the macro objWord....
0
votes
0answers
24 views

why does this select statement fail? it works as a macro but not as a button

i recorded a macro that selects a sheet and then a range. it works as a macro but it fails as a button, just want to know why? Private Sub CommandButton3_Click() manfix = InputBox("Enter in fixture ...
0
votes
0answers
10 views

Excel, Ascending Workbook Default Filenames

Disclaimer: I'm very new to using VBA, so please bear with me! I'm currently using the following macro to quickly export 4 specific pages from a larger workbook to a new workbook that gets emailed ...
0
votes
0answers
95 views

Create macro in notepad++ that copies line of text from one text file and pastes to another text file?

For example, I have a text file that has a tons of lines, but I only need the lines in the file that include the text "Employee_user_id". So I was thinking of doing something like this, using notepad+...
0
votes
0answers
217 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 ...
0
votes
0answers
70 views

Excel 2013 VBA Macro when another workbook is opened and closed will leave the empty Excel Window

Excel 2013 VBA Macro,when another workbook is opened programmatically from active workbook, it will open in different excel window (due SDI behaviour). When that workbook is closed from the active ...
0
votes
0answers
35 views

Auto Update data from one column in Excel file A to another column in Excel file B

I have 2 excel files for example myemployee.xls and salary.xls. In myemployee.xls, I have two columns: employees code and names like this and new employees will be entered here continously. A ...
0
votes
0answers
68 views

Use VBA in Word 2010 to search and manipuate a string

I have a macro that uses wildcards to find a particular string. I want to find another string within the result (preferably using wildcards), extract that substring and do something else with it. I ...
0
votes
0answers
27 views

I need assistance writing macro that will update a range of cells based on other cell values

I need help with a macro that will update a range of cells based on other cell values: For example on sheet one, I have names in column A1 and in rows B through Z I have their allocated hours by date ...
0
votes
0answers
62 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 ...
0
votes
0answers
113 views

Solver Across Multiple Worksheets

I've scoured the internet and Superuser for an answer to this, but found nothing that works... As I change data within my 7-worksheet workbook, I need to re-run solver across those 7-worksheets. ...
0
votes
0answers
23 views

(MAC) - Is it possible to be running a macro loop in the background while I work in another window?

I'm trying to essentially create a virtual mouse of some sort to run a macro in the background whilst I do other things in other windows without disrupting the process. Any software available to ...
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
0answers
9 views

excel sheet updating / copied sheet isn't

my excel spreadsheet is set on auto calc. The original sheet is updating when I make corrections. The sheet I have copied into my financial workbook (with the same formulas in it) is not updating ...
0
votes
0answers
29 views

Font style formatting of a specific script among several scripts of a document

I am working on a document in which different language scripts pop up every now and then, even in the same sentence, e.g. the following excerpt [...] الْقُرْآن (al-Qur’ān). Now, 暴れる behave violently ...
0
votes
0answers
23 views

Unicode code points converted to characters in batch

To convert code points to characters you can, for example, place the cursor next to one of them and press Alt+x. I have a document full of Unicode characters' code points. I would like to substitute, ...
0
votes
0answers
13 views

Best way to perform action (e.g. open hyperlink in firefox) upon certain criteria met when clipboard contents changed?

At work, I lookup info on vehicles by their VIN (17-digit) code, e.g. 1FMCU59H98KC63209. What I want to be able to do is perform a certain action (open hyperlinks in Firefox to start iMacro actions ...
0
votes
0answers
120 views

Set keyboard macro to launch Windows 10 Metro apps

Recently picked up a keyboard with macro keys for the first time and they're incredibly useful, but it seems I can't set a macro that launches default Windows 10 apps (like Mail, Calendar, People, etc....
0
votes
0answers
59 views

Hide column in report based on combo box on form

In Access 2010 I am trying to get a report to show or not show the contents of one column based on the value of a combo box on a form. For example, the column name in the report is "foo" and I only ...
0
votes
0answers
21 views

Notepadd ++ Macro

str# / xt / Name / Brief Description of Issue / Phone Number I'm trying to make a macro that would take this information and paste information into the fields of the table below to the appropriate ...
0
votes
0answers
164 views

Excel macro, paste not working

The macro I've written doesn't work and complains either of paste area not the same size as copy area, or a global not having been defined. The purpose of the macro (or at least the part that I'm ...
0
votes
0answers
696 views

Copy Data from one Workbook to Another in Specific Worksheet

I'm looking for a macro that can copy data from source workbook and paste it to master workbook based on specified sheet tabs. I not good at VBA. Searched the net and came across below code Sub ...
0
votes
0answers
15 views

Inserting Another Files Information into Excel (last few characters are always changing)

I'm not sure if excel can even do this but I have created a file (Top 3 Sort) and I am working on creating a macro to pull information in from other files and put them into a formula {this part I ...
0
votes
0answers
47 views

Using a macro, or any other way to sync date/time in different tables in excel?

I'm using a macro to sync data from a webserver, by import of CSV. The tables are unfortunately not synced and does not contain data for the same timestamps. I would like to use some way to ...
0
votes
0answers
42 views

Excel macro shortcuts do not work for macros showing absolute macro name in “view macros” window

Sorry for the long title, but that pretty much covers it. We are using a spreadsheet at work - it has a number of macros, all of which have keyboard shortcuts assigned to them. Some of them always ...
0
votes
0answers
160 views

ImageJ: How to measure multiple ROI in Batch Process using Macro and save each ROI's result in individual measurement table

I have 1000 images in a folder. Each images have four ROIs labelled A, B ,C and D and I wanted to measure it's grey value (min, max and mean). Is it possible to run a Macro from Batch Process that can ...
0
votes
0answers
39 views

Excel 2010 merge rows where data in duplicated except 7 columns

I have a xls file. I has some duplicate rows of customer names and other data that is identical. I want to be able to find the identical rows by customerid and copy data from one row to another ...