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

Using a loop to extract data to excel

first timer here and I'm new to Excel 2013 so if I screw up somewhere let me know! I am trying to gather stats from the Detroit Red Wings from 1932-2014 I recently learned that I can pull data from a ...
0
votes
2answers
18 views

Macro for cleaning all sheets in a workbook (VBA - Excel 2010)

I have a macro file with 5 sheets and I would like to add a VBA command button into the same file to clean all workbook contents with a single click. Does anyone know how to do it by using VBA on ...
0
votes
0answers
17 views

Macro to update Date in Specific row in excel

I want macro to update current date in cells M10, M15, M18 and M19 Ex: If format of the date is 01-11-2014,then, macro should update cells M10,M15,M18:M19 with 1 ...
0
votes
1answer
20 views

Macro to merge data on to template

I am attempting to basically do a mail merge in Excel. I would like to take employee data from one Excel worksheet and populate fields on an Wxcel template. So far I have written code to open the ...
0
votes
2answers
35 views

how to automatically run an Outlook macro?

i have developed an outlook macro and want this macro to run automatically without any prompt or mail from the user whether the outlook is on or not. Private Declare Sub keybd_event Lib "user32" ...
-1
votes
0answers
28 views

VBA/Excel meter codes [on hold]

Hello Someone help me out in writing the VBA code for the Meter in the excel, like 3 colors RED(<98%), AMBER(98% to 99%) & GREEN (>99%). if i key the percentage in one of the cell the meter ...
0
votes
0answers
12 views

file type association error

i keep my doskey macros in a separate file with .macro file extension, and can load them using doskey /macrofile=macros.macro for the specific console session i want to use windows os feature of file ...
0
votes
1answer
37 views

Open a Specific File in a Specific Folder, along with a Specific Sheet

The code below opens up a specific file in a specific folder, but not a specific sheet: Sub test() Dim myfile As String myfile = Cells(1, 1).Value & Cells(1, 2).Value & ...
0
votes
1answer
22 views

macros for multiple queries [on hold]

I'm engaged with a project. I have a worksheet with table incorporated to it. The table starts from columnb "B" while the column "A" is just the sheet column. now the queries what i have here is ...
0
votes
1answer
28 views

excel macro to reset/refresh a table column having dropdown

A newbie to excel macro so kindly bear if my question looks stupid. I have created a table (listobjects ) in worksheet having four columns. The fourth column is incorporated with drop downs through ...
0
votes
1answer
56 views

Copy Active Cell Comment in Excel into a new word file

i do not know much about Macros, is it possible someone could help me out. I have a simple excel file with names of Clients that have a lot of comments on each name. is there a fast way other than ...
1
vote
3answers
49 views

Checking whether a label exists between two other labels in a column

I have a column (call it A) in Excel lists off different items and their properties. Every item has the word "Type" associated with it and so there is a cell with that label in column A so that in ...
0
votes
1answer
18 views

Get buffer with all macros expanded in org-mode

I'm trying to troubleshoot some macro expansions in my org-mode file, how to I get a buffer that is the org-source with all org-mode macros expanded?
0
votes
0answers
6 views

Noweb syntax everywhere in Org Mode

I'd like to be able to use noweb syntax to invoke macros defined as src blocks everywhere in an org-mode file as a replacement for the org-mode macro system. Is there a way to do this? My question is ...
-4
votes
0answers
25 views

Macro Outlook - email to sql database [closed]

I'm a novice with outlook macro and I can see some codes but not really for what I'm looking for so here is my question: Does somebody has an exemple of macro outlook code for inserting the email ...
-1
votes
0answers
23 views

Excel 2010 macro that will search for multiple values in a very large worksheet, and then copy full rows into a new sheet when value is found? [closed]

I'm new here, so forgive me for the length and any rookie questions. I have a very large worksheet, about 100k lines, filled A-AD. Row 1 is header (I will need this in the new sheet, but can easily ...
0
votes
1answer
20 views

Track the username and date in one sheet when the user is opened

I have written the below code in the VBA code sheet. Private Sub Workbook_Open() MsgBox ("Welcome to Tracker, " & Application.UserName) End Sub Result is " Welcome to Tracker, Sakaray, Kiran" ...
-1
votes
1answer
29 views

Empty email content with macro

Using the thread Here I have created a macro that will open up a template in a new message window. My signature is still at the bottom though. I want to empty the email content before adding the ...
0
votes
1answer
18 views

Returning non-editable MathType equations to their original size

I have a Word document with about 200 pages and .docx format. There are many MathType formulas in it. After many edit on my file, most of the formulas converted to picture. I did this but it doesn't ...
0
votes
0answers
12 views

Resettting the keyboard's macros

I have accidentally assigned macros to my multimedia keys such as volume up and volume down. I have no clue how to reset the keyboard's default settings. The keyboard was made by AULA which is a ...
1
vote
1answer
28 views

Macro: Insert a new row above a cell containing a different numbers

I have an excel with two columns. Column A contains numbers and column B contains text data. Numbers are continuous like 1 2 3 with several blank cells between them as shown below. For example: 1 ...
1
vote
1answer
27 views

How to export full data from excel as a csv using macro?

I want to export an excel file as a csv using macro, but my code is only exporting the header only. How to export the full data? Here's my code: Sub CSVFile() Dim My_filenumber As Integer Dim ...
1
vote
1answer
44 views

EXCEL - EXTRACTING Data From Multiple Worksheets where the layout is varied

I have a spreadsheet which contains Bill of material data and Labor costs for manufactured parts. The first worksheet contains the master part numbers for the assemblies Each Worksheet represents the ...
0
votes
1answer
30 views

excel copy past repeat macro

At the moment I am working on a research project for my university in excel. Now I have a certain range BF1:DJ293 which has to be copied and past for 238 times to the right. So this range has to be ...
0
votes
4answers
111 views

Combining all combinations of data from three columns in excel

I have a few columns of data that I would like to combine, and get each unique combination. Concatenating across a row or set list is easy enough, but I would rather not have to enter each possible ...
0
votes
1answer
30 views

How Can I Comment a Block of Text in Microsoft Office Visual Basic Editor?

Sometimes when I'm writing a macro in Excel's Visual Basic Editor (VBE), I want to comment out a block of code to test the macro without it. I know I could go to each line and type an apostrophe ('), ...
0
votes
1answer
78 views

How to create a macro in Outlook 2010 to add the the date to the subject line

I am new to the VBA format of writing code and I have been researching how to get the current date to AUTO input into the Subject line of an email when commanded. I need to know how to complete the ...
-1
votes
2answers
37 views

Is there a way i can copy this macro i made but have it change for the next tickbox

I have made this macro to Select cell A3 copy the value and paste it into cell Y3. it then clears cell A3 as that's a dropdown box, by doing this the dropdown option can be now selected in A4. ...
0
votes
1answer
24 views

Macro to create a text file with values from cells and text

Im trying to create a macro in excel that creates a text file which some of the parameters are on excel cells. The output would be for example: The kid is 'cell (1,1)' old. His name is 'cell ...
-1
votes
0answers
18 views

Excel 2010 duplicate winner

I run a prize draw and want to make sure that no one wins twice. I have a Spreadsheet to record all the previous winners. How do I tell Excel to check the current entry list against this previous ...
0
votes
1answer
26 views

Doskey Variable Expansion

I'm thinking the answer to this question is no, but it shouldn't be. From the command prompt normally, the following (as an example): C:\> FOR %I IN (*) DO ECHO %~xI would give me the ...
0
votes
0answers
11 views

Excel 2013 Split One sheet into separate books

I have one sheet called Invoiced Jobs report containing the information for 10 invoices the invoice number is in Column X can I make a macro to split each invoice into a separate workbook?
1
vote
0answers
14 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 ...
0
votes
0answers
19 views

Bloomberg - Excel VBA Macro to email Bloomberg <CN> screen via <GRAB> [on hold]

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
2answers
28 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 ...
-3
votes
1answer
29 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
140 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
1answer
32 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
38 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
49 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 ...
1
vote
0answers
53 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
109 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
32 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 ...
1
vote
0answers
16 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
110 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
30 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
27 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
vote
2answers
61 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
138 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, ...