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 the ...

learn more… | top users | synonyms (1)

0
votes
2answers
69 views

Microsoft Excel Macro

I have an excel sheet that contains names (1st row), job titles (2nd row), company/institution (3rd row), and addresses(4th row) in one big column. I am trying to separate them into four different ...
0
votes
1answer
745 views

How can I apply a style to the footer in Word 2010 with VBA?

I have a macro in a Word document that generates a footer based on Bookmarks. It works, except for one detail: in one of the Ref-fields in the footer, the font is always incorrect after updating. ...
0
votes
1answer
136 views

Windows 8 and visual studio 2012 post-builds are denied macros and batches

This been killing me... Since I've changed to Windows 8 I cannot run post build events batch or macros. I've been trying to do xcopy and run some bat files (with xcopy) without success. They always ...
1
vote
0answers
151 views

Microsoft Excel Copy one row to another worksheet if cell contains specific data

I have never written a macro in excel before. I am trying to organize my PTAs spirit wear orders for ease of placing the order. I have entered all orders into a master worksheet titled "spirit wear". ...
1
vote
0answers
107 views

How to use Windows key in Autohotkey as part of a macro

I have been using autohotkey on a terminal with 122 keys. I remapped the keys so that their original funky uses are now much closer to normal modern computers. I also mapped a scancode to Windows ...
0
votes
0answers
56 views

A “clip” or active webpage on desktop/sidebar with admin access/macro

Hopefully I explain this well. I commonly log into a support system that keeps track of active tickets. Instead of navigating to the support page, logging in, and posting a query for new tickets, ...
1
vote
2answers
2k views

How to permanently add macros to Excel as part of the program? [duplicate]

I have a macro where I'm not sure when I will need to use it. I need them built into Excel to be able use them at every start of the program – like you would install some add-on (e.g. Kutools). ...
0
votes
1answer
1k views

Running a macro in current sheet and in all sheets after current one

I have a excel file, that has 12 sheets, each corresponding to a month. I have three macros that execute in a sheet they are run in. Is is possible to do it in a way, that if I run macro in sheet ...
2
votes
4answers
2k views

Word 2010 How to Create a Macro to auto-insert Author Name in the Footer?

In a template document I want to create a macro that when the template is opened and a new document is pulled up, the "author" name will automatically insert into the footer. Is this possible? I don't ...
0
votes
0answers
410 views

Create a Macro that searches, copies and Exports from two workbooks and imports into 1 master workbook

I am new to creating macros. I have tried searching for existing macros to help with my current request; however I have not found a helpful one. Please let me know if you can assist. Contents ...
0
votes
0answers
332 views

How to enable Razer BlackWidow macro keys on Windows without install Razer Synapse?

i find out how to enable razer blackwidow macro keys on linux, but i want enable macro key on windows but i don't want install any razer driver. please help me. i want use macro keys with Autohotkey ...
1
vote
1answer
207 views

Deleting entire row using macro in excel

I have and excel spreadsheet and I need to make a button that deletes the entire row in which the button is located. Lets say I have a button on cell G7. When I press it, I want the entirety of row 7 ...
0
votes
2answers
2k views

Find and name a text box in a spreadsheet using VBA

Each sheet in my Excel Workbook has one basic text box. Unfortunately these are named differently each time (Text Box 1, Text Box 17, etc.). I have a code that finds text box 1 and moves it. However, ...
0
votes
1answer
1k views

ActiveSheet.ChartObjects(“chart”) always returns Nothing?

I'm querying for a chart in the worksheet and I can see it's there but everytime I execute the following piece of code it evaluates to 'Nothing'. Why is that? Sub DeleteGraph() Dim graph As ...
0
votes
1answer
334 views

Sequential Number in Excel within Specified Range

I have been looking for the macro since last week but with no luck till yet. Would appreicate the efforts if you please get me out of the problem that i am facing, I have created excel template (used ...
0
votes
1answer
78 views

exec 2010 VBA related error: “can't find project…”

Have made a (refinery process industry-)model under Excel 2010 with many macro's (based on a Excel 2003 sheet) Had some difficulties getting it to run wih the right addins but OK now. However, other ...
0
votes
1answer
132 views

How do I customise MS Word's UI to make commands easier to access?

The question is as stated above in the title. What follows is just background info you can freely skip... Someone posted an off-topic mini-rant as a comment on one of my answers, bemoaning the loss ...
0
votes
1answer
933 views

How to make Excel cells' values cannot be changed its value via keyboard inputs

Let's take this simple Excel file as a sample for my question. Please note that it contains permutation macro VBA script. I want cells in column B to be read-only/unchangable to keyboard inputs i.e. ...
3
votes
1answer
6k views

Find and replace multiple values within selected cells

I want to run a find and replace on multiple values within a range in excel with values from 2 columns: A with the original word; B with the translation. I already found the VBA code to get this ...
0
votes
1answer
3k views

Expanding only selected rows in Excel using VBA Macros

I have written the following VBA code that contains a condition where if the Cell#="Yes" then expand the bottom row, else if Cell#="No" then collapse the bottom row. Private Sub ...
1
vote
1answer
497 views

Add a button to an e-mail which runs a macro when clicked

I'd like to send a friend an e-mail that has a clickable button in the message body... The button will run a macro. I know you can do macros on your side of things, such as: Private Sub ...
0
votes
0answers
80 views

Powepoint VBA animations do not appear in .WMV

PowerPoint 2010, Windows 7. I have a very complex PowerPoint presentation with lots of objects moving. Some of them are moved with animations, some are moved with a macro. I had to use a macro to ...
0
votes
1answer
131 views

Excel macros how to autofill cells?

When I run a macro, the value in cell AB2 changes. I want another macro named copyStuff to run automatically when the value in cell AB2 changes to 6. Please help.
0
votes
1answer
983 views

Writing VBA code to fill down to the end of a range which varies in length

I am writing a macro to automate the completion of a report which is of the same columnar structure (i.e., the same fields in the same columns month after month). However, the number of records in the ...
0
votes
1answer
27 views

Rows in Excel VBA Macros

I have recorded a macro to get a filtered set of 6 numbers and paste them in row 1.I want to get another set of 6 numbers in row 2 when I next run the macro and a third set in row three and so on when ...
1
vote
1answer
434 views

VBA to move a text box works, and then stops working

This code should find an ordinary/basic text box on a worksheet and then move it left. Then go to the next sheet and do the same thing. Do until the last sheet. It works (as I cycle through it using ...
1
vote
1answer
1k views

Copy text from a basic “Text Box” and paste it into a cell

I'm trying to access the text inside "Text Box 1", copy it and then paste it into a range beginning at A37. UPDATE: the text boxes in question are simple text boxes that have been inserted using: ...
0
votes
2answers
876 views

How to record macro of formatting tables in Excel 2010?

I'm working with Excel 2010 and made over 20 tables in one sheet. I just want to work more efficiently by making a simple macro for auto formatting table. This is the style I want to apply with the ...
0
votes
2answers
2k views

Creating a command to clear clipboard in Excel 2010

I would like to make a command that will clear (reset) Clipboard while I am using Excel 2010. I would prefer this as a button in Excel, but it can be a shortcut on the desktop as well. Is there any ...
3
votes
1answer
2k views

How to add a custom command macro in Windows 8 speech recognition

I have tried a few options but its not working for me. I am using Windows 8 Pro. Can anyone show me how I can write my own custom command macros for speech recognition in Windows 8? I have tried ...
0
votes
1answer
285 views

NOTEPAD++ Need macro or typeitin for automation of large lists

I'm sure there is a way to do this but I can not seem to figure it out. I will try my best to explain this. I have a list with 20,000 lines in notepad++. I have two tabs open in notepad++. The right ...
0
votes
3answers
69 views

EXCEL 2007 macro

I have a macro which connects to db and fetches data for me and makes it comma separated. But the problem is the comma is getting appended to the last row, which I don't want. I'm struggling here. ...
0
votes
1answer
567 views

Excel macro to delete empty rows isn't stopping

How do I make it stop after a certain amount of rows? I've taken a VBA course and my teacher explained how to delete empty rows. I'm now trying to put this in place but my macro isn't stopping. I ...
0
votes
1answer
1k views

MS Excel Vba/Macro equivalent in LibreCalc or OpenOfficeCalc

is there an equivalent macro/vba in libre calc that does this routine; - Read/open xls files in a path and do a batch import/copy of read sheets and merge it with the current open workbook. Here's the ...
1
vote
0answers
53 views

MS Word macro developed on Windows 7 stopped working on XP machine [closed]

Sub test(imagePath As String) Dim kl As Shape Dim rng As Range Set rng = ActiveDocument.Bookmarks("bkmk1").Range Set kl = ActiveDocument.Shapes.AddPicture(FileName:=imagePath, ...
1
vote
0answers
209 views

Macro to copy and insert rows by variable number

I have an Excel 2003 worksheet with names and addresses, unique per row, to be used for shipping monthly magazines. Some members receive more than one copy of the magazine, which will be indicated in ...
11
votes
1answer
3k views

How do I assign a keyboard shortcut to recorded macro in Sublime Text

I have a bunch of macros which I have recorded and saved in Sublime Text 2. I'm trying to assign keyboard shortcuts to each of those, but I'm kind of lost as to how to go about doing this, I had a ...
0
votes
1answer
166 views

Organizing Sales Data Using Excel Macros

I am writing a macro function in Excel to organize a set of monthly sales data. The original format uses 6 rows per entry, and the organized table uses only 1. The number of sales changes every ...
1
vote
1answer
282 views

Macro to import CSV file into Excel 2010 without losing leading zeroes or cell formatting

We have a UI based application that exports data out of a form into a CSV file. The data entered may have leading zeroes in some numeric fields and/or text with line feeds in other fields. ...
1
vote
1answer
215 views

Is it feasible to use a gaming mouse for software development? [closed]

I was just thinking, after seeing this question over at stackoverflow, if it would be possible to assign such macros to the macro keys of gaming mouses. I'm not entirely sure how much sense that makes ...
1
vote
0answers
105 views

Pasting and re-sizing a screenshot

I often take screen shots of random drawings and i want to re-size them using a macro. I want the macro to automatically paste the screenshot then re-size it to fit to a height of 5.9 inches and a ...
1
vote
1answer
576 views

How can I easily toggle display of page breaks for all worksheets in an Excel 2010 workbook?

Excel 2010 only allows turning page breaks off or on for one worksheet at a time via File → Options → Advanced → "Display options for this Worksheet": I previously came up with a VBA ...
0
votes
1answer
1k views

Excel VBA Macro to Create Custom Lists From a Selection

Hi I was wondering if anyone could help me create a macro that will add a selection to excels custom List. Typically to do this I select a a series of rows in one column, then I got to file, options, ...
0
votes
0answers
175 views

Is it possible to save or print a website (google search) via MS Excel (vba coding) as a pdf?

Is it possible to save or print a website (google search) via MS Excel (vba coding) as a pdf? I have a set of data in which I want to do specific google searches on. Instead of manually doing this ...
0
votes
0answers
31 views

I need help writing a macro that will check a condition, and then paste a value into a different cell [duplicate]

I want to have a macro that will check to see if a specific value exists in a data range, and if that value does exist in that data range, then I want to past a line of text in a different cell. Could ...
1
vote
1answer
284 views

Why don't I see this code as a macro in Excel?

I tried using a bit of code provided from this previous Super User Answer: Sub OpenCsvAsText(ByVal strFilepath As String) Dim intFileNo As Integer Dim iCol As Long Dim nCol As Long ...
3
votes
2answers
518 views

Get first and last value from range in a spreadsheet using other column's data for filter criteria

I have data in my spreadsheet in a worksheet like this: Where the data goes in this format [ID] | [Date] | [Hour] | And I have another worksheet where I want the data to be like this: Where I ...
0
votes
2answers
78 views

Need simple macro for “match” formula

Are column B cells hidden somewhere anywhere in column C? Give results in column A. (true/false or yes/no) I'm unable to post the simple Excel image I've created as I'm a guest, but it shows simply ...
0
votes
0answers
583 views

How do I control MS Access navigation pane by macro or VBA?

I would like to use either macro's or VBA to programatically control the Access Navigation Pane (i.e. hide and unhide it). I've found plenty of resources to hide the Navigation Pane (e.g. ...
0
votes
0answers
125 views

Why does my Excel macro fail when run from a hotkey and work when run from the macros ribbon?

I am really confused by what is going on with a macro I created to parse out space delimited files. The macro runs successfully as long as I select the macros ribbon and the macro from the dialog ...