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)

1
vote
1answer
13 views

Resizing of images (increase the size of the screen shot) in microsoft word automatically

I need to resize (increase the size) the multiple screesn shots in word document in a single click. i have a macro with me. Following is the one.. Sub ResizePics() Dim shp As Word.Shape Dim ishp ...
1
vote
1answer
20 views

How to determine largest individual value in excel in a group of identical cells?

I am trying to figure out Column D Which SKU has highest total? how do I do that in excel with a formula? In this case I determined it manually, I tried IF=IF(A2=A3,IF(C2>C3,"Largest","NOT Largest")) ...
2
votes
2answers
40 views

IF statement formula for overdue DVD rentals

I am creating a spreadsheet for my local parish church to keep track of borrowed DVDs: The DVDs have to be returned 14 days after they are borrowed. If the current date is over 14 days after the ...
1
vote
1answer
18 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 ...
0
votes
1answer
21 views

Is it possible to have Excel's Solver reference cells in multiple sheets using VBA?

I have seen this question posted on other forums, but I don't believe it has come up here. I would like the button I assign to a Solver macro to be located in a different sheet than Solver's target ...
0
votes
2answers
8 views

How to automatically hyperlink file and cell text of the same name?

I'm not that great with Excel 2013 but I'm willing to learn how to make things easier for me. I have B1 with the text Science on it and B2 with the text Math on it. I want to know the complete code to ...
0
votes
1answer
33 views

How to make a macro universally usable on multiple workstations with different usernames

I have a macro that I built for a specific work related task. I share this macro with a few people by sending them the .xlam file as an addin. No problems there. My problem is that some of the code ...
2
votes
0answers
32 views

Outlook VBA Macro to Create and Forward Email With Images in Body [migrated]

I'm a total VBA noob and I'm trying to create an Outlook macro that will copy the body of an email and put it into a template before the user can forward it. My problem is that in the email that the ...
1
vote
1answer
9 views

Microsoft Word 2010 Macro Issue

Here's a macro I recorded, but it won't run. When I click on the name and the on Run, nothing appears. I know how to record and use them, but I can't get recorded macros to run for the ff: Circle Red ...
0
votes
0answers
34 views

Excel 2013 - Not Responding and crashing while stepping through VBA macro- Win7-64 I7 processor [on hold]

I am getting a consistent problem whereby, while stepping through a macro (or running it) Excel 2013 gives me a NOT RESPONDING message and essentially crashes; i.e.- I have to close the app. This has ...
0
votes
0answers
137 views

Changes not stored: MS Word Find and replace: italics --> all caps

Inside MS Word, I record a macro which does a bunch of find and replaces. One of which is find-->font-->italics and replace-->All Caps i.e Hello ---> HELLO When I do this, the ...
0
votes
0answers
39 views

Update all fields in Word 2010 automatically

I want a way of updating all the fields on a document automatically. I currently have a macro which is linked to F9. This macro updates all the fields in the header and footer, as well as all the ones ...
0
votes
1answer
24 views

Outlook macro to change “style set” on reply

I have to following issue: With Outlook 2010 - or Outlook in general - when you reply on a email with HTML format, then some formatting is used from the received email. Often the paragraph settings ...
1
vote
1answer
41 views

vba macro - find first blank column from specific row range

Most of the solutions I have googled were either about finding the first blank column or first blank row, but I specifically need to find the first blank column in a range of rows. What I need is to ...
0
votes
0answers
13 views

split two long column of xy data series into many new column

I have a set of data like this: Data-x Data-y A 1 B 2 C 3 (THE DATA SEPARATE BY EMPTY CELL) D 4 E 5 F 6 (THE DATA SEPARATE BY EMPTY CELL) ...
2
votes
1answer
27 views

Transforming Color Codes in VBA

I have a bunch of code in excel macro which includes following pattern ; Sheet1.Cells(i, 1).Interior.ColorIndex = 4 Sheet1.Cells(j, 1).Interior.ColorIndex = 4 As you see, I'm painting some cells ...
0
votes
0answers
8 views

MS Word MacroButton Printing Twice

I'm EXTREMELY new to VBA, and I have been trying to produce an MS Word document that has a few MacroButtons on it that print specific sections. The problem arises when I click them, and it prints two ...
0
votes
2answers
29 views

Conditional formatting to mark rows depending on contents

I have an excel sheet that for the forseeable future will remain as a Work In Progress regarding a project. To easily be able to keep track of rows that need some work I would like to create a macro ...
0
votes
0answers
38 views

vba macro - assign value of cell from another workbook to a variable

I have workbook that have this button. And I also have another workbook that contains some values. I have the code below to open the said workbook and then assign the value of some cell there to a ...
1
vote
0answers
49 views

How to make Outlook font sizes bigger in the reading pane?

If you use outlook, you may have noticed that there is no default way to permanently and unilaterally change the zoom (font size) in the reading pane. If you click on a message, it will be defaulted ...
0
votes
1answer
36 views

Excel, pair 2 columns, then find all rows where column J is in two different Column D

SO I would like to have a formula or macro, to look at a table in Excel, pair two columns say J and M. Then find rows where M is connected to more then one value of Column J, Column J is Super Group, ...
-1
votes
4answers
108 views

How to capitalize the first letter in a cell in Excel

Recently i came across excel with cells filled with small cases,Is it there any easy way or macro to capitalize each word of the excel? For E.g Consider the below image : After conversion it ...
0
votes
0answers
33 views

How can i sort data with macro in different worksheet?

I use the following code for sorting a sheet in a workbook with a macro but when I open another workbook, it doesn't work. How I can I change the code so it can run in another workbook as well using ...
0
votes
0answers
10 views

How to batch-convert MS Word 2003 files from Letter to A4, and change margins to 20 mm at the same time?

I was looking at this answer, regarding how to batch convert MS Word 2010 documents from Letter (US) format to A4 (International) format: How to batch-convert MS Word files from Letter page size to ...
0
votes
0answers
21 views

Need help creating Macro in outlook 2013 [duplicate]

Here is a copy of my code for my macro that I created in word but I can not get it to work in outlook. I need a macro that puts the phrase "Here is your order confirmation. Please let me know if I ...
1
vote
1answer
24 views

Dealing with absolute references in a conditional formatting macro

Say I have the following simple data in Excel: A B C D E F G 2 1 3 2 5 4 2 4 2 1 3 2 5 2 1 3 2 4 I want to set up ...
0
votes
1answer
18 views

Word - Change styles without changing formatting

I've been given a document where the majority of the text is styled as Heading 1 for some reason. I want to change it to Normal without changing the formatting - is this possible? I want the font, ...
0
votes
0answers
13 views

open excel using .bat when excel error “file in use” is returned

I have created a .bat file to open Excel, then my Excel workbook which contains a macro which runs on open, all on a scheduled task timer. The problem is that occasionally the Excel files are not ...
1
vote
1answer
37 views

In the terminal what does “/path/to/file number” do? [closed]

There are a series of commands used to launch some code I'm working with. They are an absolute path followed by the number 0. e.g. /foo/bar/goo 0 Currently its not working, its just gives the ...
1
vote
1answer
62 views

Excel macro to format cells based on value and group with blank rows below

I'm trying to create an excel macro to format some data that is exported from another program. Here is an example of the data layout: ID Code SubCodes 1 A1 1 1 ...
0
votes
1answer
40 views

How to write VBA code that looks to a cell for a column header in another sheet, then returns the corresponding column? [closed]

So I have a full spreadsheet of customers as columns and products as rows, the crossing cells indicating how many of each the customer has purchased. In another sheet i want to be able to run a macro ...
0
votes
0answers
62 views

Filename path in Word vba macro is unable to find building block.dotx file saved in network drive

I have a building block that I am using a vba macro to implement. The macro pastes a building block header into a section of the word document. The pasting of the building block works, when the ...
1
vote
1answer
52 views

Outlook 2013 macro suddenly not working anymore

I've been using a macro to send mails when a reminder is triggerd. I used this guide to get it: Scheduled and recurring email in Outlook? It worked fine for a couple days but now it's not sending ...
1
vote
1answer
62 views

VBA; Fill down last line of an array to match the length of an adjacent column

So for an early stab at VBA I'm writing a macro: I'm pasting in a set of data that increases in numbers of rows each month; data is well organised with no blank values/columns I have formulae in ...
1
vote
1answer
56 views

Quick Steps in Outlook quick access toolbar

How can the quick steps in Outlook (2013) be added to the quick access toolbar? The Microsoft forums have an (un)helpful answer. Quick steps exist on the Home tab of the ribbon in a box, but I have ...
0
votes
1answer
37 views

VBA Code Isn't “holding” ThisWorksheet Parameter

I want to retrieve one column of values from another workbook and populate a tab in my current workbook. This will ultimately go into a much longer module I've written that works great. I just wanted ...
0
votes
0answers
32 views

Find and replace by a single dot several series of two dots attached to the end of words

I want to replace every series of two dots in a document by a single dot, excluding the cases where there are three dots in a row, i.e., the written ellipsis (...). Yet, the series of two dots always ...
2
votes
1answer
31 views

Numerical index structure out of a folder structure

I'm new to this and I will do my best to ask this question correctly. I need to create a numerical index structure out of a folder/document structure as such. I have this information: ...
0
votes
0answers
34 views

Combining all combinations of data from 8, 9 and 10 columns in excel

I'm attempting to figure out how to run all possible combinations for data in 8, 9 and 10 columns (each on different pages) and would love to have a macro for each. Below is a macro for three ...
0
votes
1answer
17 views

Autofill in a Excel macro

I have the following macro in Excel Sub IHIAddWeeks() ' ' IHIAddWeeks Macro ' ihi-table ' ' Keyboard Shortcut: Ctrl+Shift+I ' ActiveCell.FormulaR1C1 = "=YEAR(RC[1])&WEEKNUM((RC[1]))" ...
1
vote
1answer
23 views

Macros in “Word commands”

Recently, I created a macro and named it TableProperties and saved it. This macro will change the AltText in table properties of all the table in the document. I opened a different document today and ...
-1
votes
2answers
47 views

Find and replace {0,} occurrences in Word

Are there any alternatives to the concept {0,} which is not allowed in MS Word? For example, if I wanted to replace, by a single abbreviation, the next five terms: articul articulo articula ...
0
votes
2answers
49 views

Automating reconnection of internet

I use WiFi with a router that drops my connection rarely, which is too often. This usually happens at night, when I'm not using the computer. I would like to automate this: Detect Internet ...
0
votes
1answer
65 views

Loop through cells in a column and concatenate

I would like to take all cells in column A: *bla* *someWord* *two words* *two & words* *other - words* Loop through them and concatenate as follows: “my custom text” + “(”+“*[index1]*”,” * ...
0
votes
1answer
46 views

Calling a function from another workbook

I've got a pile of data in one worksheet that I am trying to save to individual workbooks based on values in several columns. The approach I am taking (for better or worse!) is to copy the relevant ...
0
votes
1answer
37 views

Merge multiple Personal.xlsb

There are SO and SU answers for merging the contents of spreadsheets, but has anyone merged VBA macros to only keep distinct macros and/or highlight differences.
1
vote
1answer
37 views

Only Show a Watermark When Document is Printed

I have a series of ISO controlled documents that need to have a watermark appear only when printed that says something like "UNCONTROLLED WHEN PRINTED". This watermark would appear in the footer of ...
1
vote
1answer
45 views

How can I add a fixed amount of time to all “hh:mm” strings in a document?

I have a document that's a transcription of a video interview. The video itself has embedded SMPTE timecode as well as burnt-in timecode (BITC). The SMPTE timecode and BITC correspond to the time of ...
-1
votes
1answer
58 views

Excel Macro to Find Cells that Contain “<6” in Columns with Header “n” and Replace the Adjacent Cell with “S”

I'm relatively new to Excel VBA programming and I'm having problems generating a macro. My data looks something like this. In column A titled "N" I have counts going down several rows. If a count was ...
0
votes
0answers
35 views

Clear find result in notepad++ with keystrokes or plugin

I'm trying to find a keystroke or plugin (that I could assign a hotkey to) to do the following: Focus the "Find Result" window (I know the F7 key does the focusing, but I think it's also a toggle) ...