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

How can I open a PDF to a certain page from within excel?

I would like a macro code for Excel 2013 that will open up a certain page upon clicking a button in the excel cell. I am using the below code, but it is working intermittently. Please help with a ...
1
vote
0answers
7 views

Bloomberg - Excel VBA Macro to email Bloomberg <CN> screen via <GRAB>

I am looking to develop an Excel-Bloomberg macro. The excel spreadsheet will be linked to a Bloomberg Add-In and of course, a Bloomberg Terminal. The objective of the macro is to have a list of ...
1
vote
1answer
16 views

Mapped keyboard shortcuts that generate text responses (macros maybe)

I've got a seemingly simple idea where I would press a combination of keys (like Ctrl + Alt + Z) and paste a previously written(and saved) response on wherever I'm typing. This is meant to work in a ...
-1
votes
0answers
19 views

I would like a macro to find a cell, then input a number 1 [on hold]

I have a spreadsheet with names in a column and years along the top row. When I do a particular piece of work, I want to run a macro to input a 1 in the appropriate cell to show the job has been done ...
-3
votes
1answer
23 views

Find and Replace in all excel files

I am no programmer. Is there a macro/vba/tool that allows me to find and replace in all opened excel files, at once? If not, an external tool that allow me to drag & drop files, because I have ...
-1
votes
2answers
68 views

Use Excel VBA If value in column a is not in column b then add value to column c

Dim i As Variant 'For i = 1 To 5 For Each i In rngWatch Dim c As Variant c = rngWatch.Cells(i, 1).Value If i <> rngReconcile.Cells(i, 1).Value Then MsgBox i ...
0
votes
0answers
27 views

How to enable macros by hard coding using VBA

I have an attendance tool in MS Excel which is built by having macros. Now the task is to enable macros in customers system by hard coding in the same tool itself when they using this tool for the ...
-1
votes
0answers
15 views

How do I get Outlook 2010 to send a bulk (~30) email at 2:00 am PST? [closed]

I would like to get outlook 2010 to send email at 2:00 am PST. Unfortunately there is a max of 120 minute delay for bulk email and only individual messages can be sent at a specified hour. Here are ...
0
votes
1answer
26 views

Creating a macro with .sh

so I would like to write a script that will be used in the following way. ./MakeMacro 1 The basic form of the script looks like this: #!/bin/sh ...
-2
votes
1answer
32 views

What formula can I use to colouring in columns?

I am creating a planning spreadsheet for the operators to use on the shop floor. Products have a specific time in which they are made. All I want to do is, when I type a product name into ANY cell, ...
0
votes
0answers
22 views

Mac Excel 2011 xlsm file will not open

I really hope someone might be able to help. I have just saved my research data base as a macro-enabled file. The screen went grey and hence I closed the app. On reopening, the file can be seen, and ...
-4
votes
0answers
26 views

Excel copy paste if macro vba [closed]

In excel, can you help me build a macro/vba for this task: Copy-paste $M$1:$N$1 to Column M:N, if Cell in column C="price". Thank you all!
1
vote
0answers
18 views

Macro to copy multiple rows from one worksheet to another and then copy the headings into copied columns

I am new to macros and I have developed this macro that allows me to take rows that has data in them from cells B-G from Workseet "master 1" starting from row 11. I take this data and then copy it ...
0
votes
1answer
52 views

Macro: Insert a new row above a cell containing a value

I have a column containing the following values: A1 = 0 A2 = 1 A3 = 3 A4 = 4 A5 = 0 A6 = 1 I wish to select column A and insert a new column above any instance of 0. I have tried the following code ...
0
votes
2answers
29 views

How to add commonly used (non-signature) phrase in emails?

I have a text line with a hyperlink that I would like to readily use in composing emails. It is not a signature, so it doesn’t fit there. How can I build a macro that would allow me to add this text ...
-2
votes
0answers
17 views

Outlook 2010/2013 prompt when sending e-mails, providing options to insert text

I am looking for a macro that works on both Outlook 2010 and Outlook 2013. It should prompt before sending any e-mail providing me 4 options, something akin to: "You are about to send an e-mail, mark ...
1
vote
0answers
15 views

How to select a cell relative to a button with a macro?

I am trying to create a macro in Excel which I can assign to a number of buttons (one in each row), each of which will operate on the data in the row in which the button is located. Is it possible to ...
1
vote
0answers
40 views

Reset Numbered List with Text Style VBA macro MS Word

I'm trying to make a VBA macro to create a Word document from Excel... Currently I'm having issues with setting up the Lists properly. I want the list indexes linked to my 2 header types. Like so: ...
0
votes
0answers
19 views

Find and replace multiple values within selected cells using another workbook

I was wondering whether anyone could point out what's wrong with the VBA code below. It's based on the following: Find and replace multiple values within selected cells I want it to take the find ...
1
vote
0answers
17 views

Show Lync Status on Interactive Page

I have an idea for a concept and i'm not sure in what format it can/will be: Our organisation has many employees that sit across a very large office. We have a desk plan hard-copy that shows names ...
0
votes
0answers
27 views

I need a macro to separate a column of names into 4 different shifts

Our system creates a report for accuracy. Our manager wants it separated by shifts. From those lists, it will go to a report 'by shift' along with the information on the row with each. I need a macro ...
-1
votes
0answers
28 views

vba method cells of object _global failed

I have this vba code. In the conditional statement, if the met condition is in env2, the code works fine. however if the condition met is in env1, the code fail with the error run-time error 1004. Why ...
1
vote
2answers
28 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
82 views

vba excel macro runtime error 1004

Dim lastC As Long lastC = wb2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'highlighted in debug SourceRange.Copy wb2.Worksheets(2).Cells(1, lastC + 1).PasteSpecial Paste:=xlPasteValues, ...
0
votes
1answer
66 views

modify Excel macro to reference list of text rather than hard code

I’m trying to get some help with the last step of an Excel Macro I’ve been working on. I’ve set up a Macro that will take data from sheets from two different workbooks, and paste them into a third ...
-1
votes
0answers
12 views

Batch export text from one Word Document to a new Word Document

Several years ago one of our employees batch converted our documents (which are templates) onto new letterhead because the company logo changed. I know that the person used a macro. This happened ...
0
votes
0answers
26 views

Excel VBA macro - i need to insert column and add a default value to all the cells in that column

I have created a macro but i could not insert columns in it and i could not add values to that coulmn. I want to insert a column and the default value to that entire column should be CH. column ...
0
votes
0answers
8 views

Libre Office Calc - how to suppress search results window when performing a macro search?

I work with a macro that finds and replaces certain characters in a spreadsheet. I use this macro a lot and I don't need the "search results" window to pop up after every search since I am not ...
0
votes
0answers
5 views

excel macro to populate one cell in a sequence from a given rage

currently after I enter a number in cell a1 the data in the spreadsheet changes and then I run a macro " macro1" to save to pdf. The problem is I need to enter more than 30 such numbers into the ...
-1
votes
1answer
63 views

Excel Macro to do a Sql Query

I need to do a Macro in Excel Worksheet such for the following process. User will enter a string in the Text field and click a button. When the button is clicked the VBscript should match the ...
0
votes
1answer
48 views

Spreadsheet data checking columns

I am trying to separate datas from columns(A,B&C) based on datas from an index table at columns (E&F) I need to list only those data from columns A/B/C when column B data has no corresponding ...
0
votes
0answers
22 views

Word macros to resize a picture to its original size and then back to “thumbnail” size

Workflow: 1. Insert a larger picture in a MS Word 2010 document 2. Reduce the picture size to a smaller "thumbnail" size 3. Save and close the document 4. Reopen the document 5. Select the picture ...
0
votes
2answers
36 views

How can I perform search & replace in a text file based on conditions?

I have a large text file (.bib) with lots of double entries for some fields. Essentially, the file is a .bib-file (more info here) which has roughly 1000 entries. The content is structured like this: ...
1
vote
1answer
35 views

Defining math shortcuts/macros for Microsoft Word

Is it possible, in any version of Microsoft Word, to define shortcuts for recurring mathematical expressions? (preferably in a way that allows updating all occurences at once if needed) For instance, ...
0
votes
1answer
25 views

Running a set of data through multiple calculations and outputting the results back on the data sheet

Using Microsoft Excel 2013. I am creating a calculation sheet for quickly evaluating the metrics of rental properties. I have a sheet called CALCULATIONS with several calculations, and several ...
0
votes
0answers
37 views

Copy-pasting between two computers , or a virtual machine and host?

In my work, I find myself hopping between a VPN machine and my host machine to do work. Lately I've been using https://www.cl1p.net/ a lot , for copy-pasting between 2 computers. A nice site, ...
0
votes
1answer
59 views

Excel 2010 Formula: Finding a dynamic column based on string value, then count # of “0's” within that column

I have tried looking at many different potential avenues at solving this; INDEX, MATCH, DCOUNT, HLOOKUP with INDEX & MATCH, COUNTIF with INDEX & MATCH. What I'm looking for is a way to set the ...
0
votes
0answers
29 views

Excel Macro for preserving line breaks in cell text

I have an excel sheet containing text that I require copying and then pasting into a 3rd party application (bit like notepad). I need to use a button to copy the text so it cannot be edited or ...
0
votes
1answer
32 views

Keyboard Shortcut to Run Macro in Excel for Mac

Basically the title says it all. In the editor in Excel on Windows, all you have to do to run a macro is press F5. What is the keyboard shortcut to do this on a Mac?
0
votes
0answers
13 views

Pasting a formula on many excel files using a macro

So basically I have around 500 excel files with different names. But they are in same format. I want to paste my formula in sheet(3), Cell (AW6:BL6). This is what i'm trying. Private Sub ...
1
vote
1answer
98 views

AutoHotkey, don't get the solution

I really need your help. I trying to program an AutoHotkey script but I not quite getting a working solution. My current AutoHotkey script is: #IfWinActive Guild Wars 2 shift & 1:: Send, 1 sleep ...
0
votes
1answer
34 views

How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2 And i have macro called "AAA" in instance 1 and "ASD" in instance 2 i want to call "ASD" in instance 2 ...
0
votes
0answers
181 views

Select item from drop down menu and run macro

I have a drop down list in a sheet called 'Report', cell B9. The source for this list is in another sheet in the same workbook, 'List' with range 'A1:A32'. When the different items in this list are ...
0
votes
0answers
85 views

Prevent 'Run-time error '7' out of memory' error in Excel when using macro

I keep getting this error whenever I run a macro in my excel file. Is there any way I can prevent this? My code is below. Debugging highlights the following line as the issue: ...
0
votes
0answers
42 views

Macro to copy values to new sheet and prompt user where they want to save

I'm looking to create a macro in Excel 2007 which will do the following: copy the formatting and values from a sheet called 'report', insert this into a new workbook, naming the file with the value ...
0
votes
1answer
67 views

Excel: How to extract group of the same rows and their values into columns?

How can I extract the second table from the first one? I need to extract those titles that have exactly three costs (in the following example: f1 and f3). I tried using pivot tables but could not ...
1
vote
0answers
109 views

run-time error 1004 Application Defined or object-define error

I have this macro that I wrote: Dim lastColumn As Long lastColumns = wkbWorkbook2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'this is the highlighted part in debug SourceRange.Copy ...
0
votes
1answer
44 views

Autohotkey - How to overwrite an existing hotkey, while remapping the original hotkey

I want to do a seemingly simple action but I'm having trouble figuring out how. I want to remap Ctrl+F -- which natively opens a 'find' window in the program I'm using -- but I want to create a new ...
1
vote
1answer
29 views

How to change superscript text so that it is displayed in parenthesis in Word?

How to change superscript text so that it is displayed in parenthesis in Word? I have a massive amount of interlinear text in the format: x y where y is the translation of the word x. I would like ...
0
votes
1answer
114 views

Use an user defined function for data validation

I created a named range which is the result of a user definer function. Let say my rage is named List and has three items, if I select three cells and enter =List and press Ctrl+Shift+Enter, I get ...