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
votes
0answers
10 views

How to save word file in multiple locations during editing?

I want to constantly backup to google drive, local pendrive and hard-disk at the press of a keyboard shortcut.
0
votes
0answers
20 views

Excel 2013 custom vlookup method

I have a workbook with over hundred worksheets that has monthly bonus calculation requests submitted (one for each employee) as well as a few other sheets that have the current monthly data such as ...
0
votes
0answers
47 views

.XLSM file has sharing violation when saving during remote desktop use

I have a large (~5mb) multi sheet excel macro file *.xlsm stored locally on my laptop. While using the file I occasionally connect to my office via remote desktop to do unrelated work. If I make a ...
0
votes
1answer
10 views

Run the same macros in two workbooks

I would like to run this same code in two workbooks. The code puts data labels on an xy scatter chart. Here is the code: Sub AttachLabelsToPoints() 'Dimension variables. Dim Counter As ...
1
vote
1answer
23 views

How can I run a macro changing the value of the cell (no carriage returns)?

I can run a macro whenever a value is changed in a cell. However, I have to press the carriage return button to change the value of the cell. Is there any way to run a macro whenever I press a single ...
-2
votes
1answer
27 views

How to transpose range in Excel through insertion of new lines?

My data looks like this: a 1 2 b 1 2 c 1 2 I want to reorganise it so it looks like this: a 1 a 2 b 1 b 2 c 1 c 2
0
votes
0answers
26 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
28 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
24 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
21 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 ...
0
votes
0answers
26 views

MS macro to copy and paste Outlook bodytext to Word document [on hold]

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
30 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
17 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
39 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
23 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
37 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
20 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 ...
1
vote
1answer
36 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
28 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
32 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
52 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
13 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
19 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
88 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
77 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
72 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
13 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
13 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
148 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
44 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
28 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
82 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
32 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
69 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
65 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
50 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
259 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
44 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
18 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
28 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
27 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, ...