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
1answer
332 views

Input automation for Internet Explorer 11

I'm working on a large web app for which very frequently run tests in IE11. To commence with the test, I need to supply credentials and click the login button, then navigate to a constant URL. Is ...
3
votes
1answer
935 views

Freeze multiple columns in excel using macro

Under the Freeze panes, Excel currently offers Freeze panes, Freeze first row and Freeze first column options. I was looking for an option where I can freeze the first N-columns. I did a record macro ...
1
vote
1answer
84 views

Copy an excel file with Macros and New Tabs in the ribbon to another computer

I'm working with Microsoft Excel 2013. I'm using couple of macros I did and I made a new tab in the ribbon menu which shows the macros I did so that I can click on the this created tab then click on ...
1
vote
3answers
124 views

Remove spaces between characters in cell, but only if the space exists between two single characters

To process in 10,000 lines of excel, to remove spaces between characters in cell, but only if the space exists between two single characters. P J A JACKSON AND SONS should become PJA JACKSON AND ...
0
votes
0answers
280 views

Macro to copy distinct values to another sheet, based on value in another cell

I'm using MS Excel 2010. My data set consists of a list of calls performed by employees of three different companies. My workbook has one sheet (let's call it "Sheet1") where each row corresponds to a ...
0
votes
0answers
37 views

Detailed macro with scheduling

I have a bookmark and two bookmark folders, each with 12 other bookmarks, in my chrome bookmark toolbar. I would like to be able to schedule a macro that clicks the first bookmark, logs into that ...
0
votes
1answer
293 views

Need macro to transfer Word data into Excel

I am very new to VBA and need help ! I have VB macro in Excel that grabs the data from a Word document and imports it into Excel worksheet. Currently, the code in macro has expression that clears the ...
1
vote
0answers
48 views

MS Word, can we write a multilingual regular expression?

I want to find all the occurrences of the from x.y and change it to x,y where x and y are numbers: I was using this: ([0-9]).([0-9) and doing the replace using \1,\2 but here is the catch , if the ...
1
vote
0answers
248 views

Complete site rip of a website using wget

I am attempting to perform a complete site rip of a website, I know where the streamed videos locations are however getting the process to run as efficiently and productively is proving difficult. ...
0
votes
0answers
34 views

allow run word vba macro from user via parental control

setting up a user as a virtual assistant on windows 7 professional, want to limit programs that can be accessed. Using parental control to do that. I have given permission via parental control to run ...
0
votes
0answers
42 views

How to map a macro to RAlt in Far Manager

I have a typography keyboard layout installed (Ilya Birman layout). Right Alt is used to enter special symbols such as € (RAlt+E) or ≈ (RAlt+A). But after installing it RAlt+F1..F10 no longer work ...
1
vote
1answer
216 views

How can I write only certain rows of an Excel worksheet to CSV?

I have created an Excel (2010) workbook that takes information from various CSV files and puts them into a format that can be understood by my office's scheduling program. Using a macro I found ...
0
votes
0answers
93 views

Macro, Formula or Code? Copy data to new sheet based on specific criteria?

I have tried pulling this together with various formulas but A. A lot of the didnt work and B. it was very messy. For the example of this question lets use a Music CD with 2 Disc. The information is ...
0
votes
1answer
122 views

Debugging a macro that saves column data to another sheet

I am new with VB so I run into troubles often.. Here's the problem that I have. I have developed the following macro: Sub copycolumns() Dim lastrow As Long, erow As Long lastrow = Sheet4.Cells(...
0
votes
1answer
181 views

(Subscript out of range) Error 9

Below is a modified version of a code (i found on Stack Exchange) that I am currently using - Option Explicit Sub Main() Columns("E:E").NumberFormat = "@" Dim i As Long, c As Long, r As ...
0
votes
5answers
108 views

Can I run this Macro faster? [duplicate]

I am using this macro for over 1000 entries. The code itself works the way I want it to. Option Explicit Sub DoTheThing() Dim keepValueCol As String keepValueCol = "H" Dim row As Integer row = ...
0
votes
0answers
37 views

How can I specify “Start Time” and “End Time” in Out of Office Reply Message using VBA?

I already have a function that returns the status of the Out Of Office. And I can tell when it is enabled and when it's not. Also I have a macro that enables it and disables it. Now I need to be ...
1
vote
1answer
59 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
63 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
179 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
2answers
2k 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
373 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
471 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
65 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 ...
1
vote
1answer
26 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
226 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
1answer
106 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
948 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
46 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
85 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
28 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
42 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
389 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
468 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
209 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, ...
0
votes
4answers
9k 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
270 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
22 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
108 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
151 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
49 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
47 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
430 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
304 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
243 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
140 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
225 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
700 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
64 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
1answer
74 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 ...