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
0answers
54 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, ...
15
votes
1answer
5k 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
217 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
324 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
283 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
134 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
843 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
230 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
478 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
702 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
84 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
691 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
153 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 ...
2
votes
2answers
5k 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
771 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
53 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
36 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
495 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
41 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
63 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
80 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
4k 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 ...
1
vote
2answers
275 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
70 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
656 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
265 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
297 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
604 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
702 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
4k 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
211 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
103 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
177 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
112 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
106 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
218 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
342 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
555 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
1k 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 ...
0
votes
2answers
5k views

Excel macros how to autofill cells?

Hi i am not familiar with VBA code but i know java. I am looking to create a macro that checks if a cell is not blank and autofill the cells in another column but in the same row with the formula ...
2
votes
1answer
370 views

How do I refactor VBA code to iterate over worksheets applying a set of cell operations?

This is my code: 'copy cells Sub start() 'variable for all worksheets in the workbook Dim sh1 As Worksheet Dim sh2 As Worksheet Dim sh3 As Worksheet Dim sh4 As Worksheet Dim sh5 As Worksheet Dim sh6 ...
1
vote
1answer
1k views

How to inspect / view an Excel macro before “enabling macros” for a sheet?

I'm receiving occasionally an xls file that contains a macro which I should use. If I don't have complete trust in the sender, I wish to look at the macro's source in order to verify that it indeed ...
0
votes
1answer
286 views

Cutting and Pasting in Excel Macro

I have approximately 9,000 columns (goes to column MGN) which have 14 rows of data points. I need to get the data in a single column with the format Column B below A, C below B, etc. Is there any ...
-1
votes
2answers
297 views

How to extract text from within a cell using macro?

I have the following text in a cell that i want to concatenate to another cell. Pre-Condition: 1. ABC 2. ABC 3. ABC 4. ABC PQRSTUV I want to extract the following text: Pre-Condition: 1. ABC 2. ...
1
vote
1answer
69 views

Excel_macro_pivot table_analyzing data

I have two problems with my data in Excel. I have this table, so for every day in the year I have got 24 values, that´s 365 columns. I need to write a macro, that transform the data vertically, ...
0
votes
1answer
120 views

I need to know how to swap the contents of two adjacent cells in Excel based on the content of a third cell

I am trying to swap the content between two cells in Excel based on the content of a third cell. So, I have a column in Excel - say Column C. I want to swap the values of the corresponding cells in ...
2
votes
0answers
214 views

Resizing window in Word 2010 on Windows XP

Two macros I have, one to size down a Word window down to 20% of the RH side of the screen, and the other to 80% on the LH side, have stopped working. (They are for reference files while I work on the ...