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
1k 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
262 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
68 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
519 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
926 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
51 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
178 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 ...
10
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
160 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
274 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
193 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
100 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
502 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
864 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
163 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
230 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
431 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
74 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
574 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
120 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 ...
1
vote
2answers
3k views

How to find document variables in MS Word without using a Macro

I have document with some document variables in and I'm trying to use those variables in the document. But since the variables are set by an external system (which is not well documented) I'm playing ...
0
votes
3answers
428 views

How do I separate three different phone numbers concatenated in one cell into three new rows?

I am doing work for a client and need to know how to separate these phone numbers. I have 0121 396 0501 / 0121 123 434* / 0797 978 8265 in one cell and I want to end up with the same row ...
3
votes
1answer
50 views

How can I make scripts that communicates with 3rd party programs and do work?

For example, if I were using a mechanical detailing software such as AutoCad and I was adding dimensions to a drawing which has somewhat of a repetitive cycle and I wanted to automate this task. How ...
0
votes
0answers
35 views

How to change the conditions of a macro under circumstances?

Well, what I want to do is edit if a particular cell has a particular value. For example, if cell A18 has any number higher than 6, it will make the value of cell O2 say =A18*0.5, however, if it says ...
1
vote
1answer
211 views

Inserting pictures automatically using their file paths in the text

I have a text document where image paths are written explicitly such as: Lorem ipsum dolor sit amet, consectetur adipiscing elit. c:\Users\userx\Documents\img_000180.jpg I am looking for some ...
0
votes
1answer
40 views

Office 2007: assign a different keyboard shortcut to “find”

I'm trying to assign a single key (F2) to the "find" command, but I cannot find it in the list of commands. As you can see here, I can see the "find" command when it comes to add it to the Quick ...
-1
votes
1answer
58 views

How to use macros created in outlook 2007 to work in outlook 2010

I recently was upgraded from Outlook 2007 to 2010. I cannot see any of my macros that I created in 2007. I also do not see any tags or buttons on how to call up any macros previously written in an ...
1
vote
0answers
52 views

Using Macros for Automatic Formatting in Word?

We're trying to create something that will allow us to copy lines from a technical document which is unformatted and in font X, and paste them into a form or into something that will produce it in a ...
0
votes
1answer
3k views

How to customize Paste Value Excel Short Cut

I was reading in this other post about how to set up a macro to past values in Excel. I understand how to create he macro but I would like to set the keyboard shortcut to Ctrl d but excel pops up an ...
0
votes
2answers
248 views

Turning paragraph count in MS word into a useable Variable for looping

I have a macro that lifts a selected amount of text from Document A, pastes it into document B, polls Word for the total number of paragraphs in document B, then does a routine to that text in ...
1
vote
2answers
200 views

How to create and run a macro that runs on current visual selection?

I'd like to create a macro so that if I select a piece of text (either by a keyboard or a mouse) and invoke this macro, it adds [b] and [/b] around the text (for example). I'm familiar with recording ...
-1
votes
1answer
45 views

How to merge with macro? [closed]

From input of this kind: CUSTOMERCODE DATE QTY 890550 16/04/2013 10 890550 16/04/2013 20 890550 17/04/2013 20 890551 18/04/2013 30 890551 18/04/2013 30 ...
0
votes
1answer
69 views

Can someone correct this Excel 2010 Macro?

Well, I recorded a macro but it is not working correctly. It is as followed: Sub OpenCase1() ' ' OpenCase1 Macro ' ' Range("G5").Select ActiveCell.FormulaR1C1 = "=R[-4]C[-3]" ...
3
votes
1answer
381 views

Send an email when computer restart

I want to receive an email from PC everytime it restart. I think about adding EXE file - which send an email - to windows schedule. but I don't know how I write one. any other ideas?
0
votes
2answers
179 views

How to automatically post on a forum after a random interval? [closed]

I am a regular user of the forum: http://forums.vr-zone.com/ Currently, I am selling a laptop on the marketplace. As it gets very crowded in there, I have to manually bump my post every few minutes ...
-3
votes
1answer
253 views

How to combine these two Macros? (Excel 2010)

I have absolutely NO experience in programming Macros (but I can still record Macros, and that is what helps me) So, I'm asking how to 'slot' this part of a macro, into a whole macro code? Here they ...
0
votes
1answer
512 views

Why is this macro not working correctly in Excel 2010?

Well, I'm curious as to why this macro isn't working. The macro is supposed to work like this. I have a cell with black background and black text. What is supposed to happen is that this cell's ...
2
votes
1answer
497 views

Speech Recognition and Macros for Linux

Recently I have been working on a little project involving speech recognition in Windows, I used the Windows Speech Recognition software that comes pre-installed and also the Windows Speech ...
0
votes
1answer
2k views

How to assign a macro to Sort & Filter in Excel 2010?

Well, I know nothing about assigning Macros (and I'm hoping not to anytime soon) so I'm hoping to do this as painless as possible. I want it that, for example a picture, when I click it, it will ...
0
votes
1answer
164 views

Excel 2003 Macro runtime error 1004 application-defined or object-defined error

We are using a macro to remove rows of data from our excel 'database' that have been tagged as being completed/done. this is the coding ... Private Sub cmdRemove_Click() Dim varResult As ...
2
votes
2answers
86 views

Excel macro checks if there is formula

I want to make a macro that checks if that cell get its value from a formula. I cann't find anything similar. Any tips??
0
votes
1answer
109 views

Excel popup window after using macro

This is the excel sheet i am using When i run this macro Sub Value_fla() Dim k As Long With ActiveSheet k = .Cells(.Rows.Count, "D").End(xlUp).Row End With ...
0
votes
2answers
77 views

How to disable “This workbook contains macros”

This prompt comes up each time I open a file which I trust, is there a way to disable it permanently?
0
votes
2answers
84 views

Need help creating macro in excel rows to columns

I have a data dump in Excel that consists of customer_id data with multiple equipment listed against the same customer. Data looks like this; customer_id equipment 1 xx 1 ...
0
votes
1answer
193 views

Split a file with macro in excel

I know there are 2 similar questions. I have a very large Excel file separated in sections by 3 blanks lines. I was wondering if there was a way to split the spreadsheet into other every time there is ...
0
votes
1answer
254 views

Is it possible to create a macro in PowerPoint 2007 that controls the size and location of chart objects

I'm trying to add a little visual basic to a PowerPoint slide. I usually work in Excel and was surprised to learn PowerPoint doesn't offer a record feature. My slide currently has six charts on it ...
2
votes
1answer
444 views

How do you save a recorded macro in TextMate 2?

TextMate 2 has a round red button in the bottom right corner of each window that pulses when clicked and records a macro of your actions while it is on. As far as I can tell the only way to replay a ...
0
votes
1answer
900 views

Sharepoint Document's macros

I'm trying to upload an excel document with a few macros to a 2013 SharePoint, I don't know if I can use the macros via "View in Web Browser" option. I cant get them working, although if I download ...