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

Excel x64 file corruption in .xlsb files for Office 2013

I have a number of Excel files, all created in Office x64, all in .xlsb format and all containing macros. Every now and again, these files become corrupted and I cannot get them to run. I can however ...
0
votes
1answer
22 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
18 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
16 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
votes
0answers
21 views

MS macro to copy and paste Outlook bodytext to Word document

It sounds pretty simple. I am trying to create a macro to copy and paste Outlook’s e-mail bodytext to a placeholder text in a Word document. I have been trying for hours to record different workflows. ...
1
vote
3answers
43 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
23 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
16 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
35 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
22 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
27 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
19 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
7 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 ...
0
votes
0answers
15 views

Macro Issue Microsoft Excel 2013 [closed]

I'm currently having trouble with Excel 2013 (Recently upgraded from 2010) Issue is when running a macro in any sheet it stops me from using any other sheet ie. inputting data into another sheet ...
1
vote
1answer
33 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
26 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
27 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 = ...
0
votes
1answer
48 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
88 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
12 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
18 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
24 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
85 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
56 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
55 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
12 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
38 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
12 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
147 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
42 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
26 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
62 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
16 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
30 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
11 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
32 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
59 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
63 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
45 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
193 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
42 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
16 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
26 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
20 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
14 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
78 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
61 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
87 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 ...