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 the [vba] tag instead of this one if the question concerns a Microsoft Office product. This helps the ...
2
votes
0answers
12 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 ...
3
votes
3answers
716 views
vim: Continue macro after error in submacro?
I'm in the process of beautifying some source code using vim. {1}
I've created a couple of vim macros that do the individual steps: removing trailing whilespace, removing empty lines after {, ...
2
votes
1answer
480 views
How to split cell in a row with Excel
I am trying to create a macro to split a cell containing two or more line of characters. I would like to keep the others cells of the row.
For example
_____________
| | A |
|Row 1| B |
| ...
0
votes
3answers
72 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 ...
0
votes
0answers
13 views
Change border color in OpenOffice - macro
When I have table in Open Office and I´ve got there some values (for example 23 and 26) and I need circumscribe all numbers beteen this values, how can I do it in macro?
For your imagination, I post ...
0
votes
2answers
3k views
Need macro to insert custom signature in Outlook 2007 email
I need a basic VB macro to insert a specific signature into an email message. Our support team uses a variety of different signatures to respond to different types of support needs. Currently, I ...
0
votes
1answer
50 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 ...
2
votes
2answers
1k views
Word macro: how to replace strings in a text, based on a 2 column-table?
So I have a series of strings that I'd like to search and replace in Word documents.
My strings would be displayed as a two-column table. I'd probably create the table with Word, then would convert ...
0
votes
2answers
24 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
18 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
1answer
40 views
How can I update this macro to only copy columns B thru F onto the new sheet? [closed]
I have multiple search strings such as: SearchForString 503, TH00000, XYZ if ColE, ColF and ColC are met I only want to copy columns b,c,d,e & f in that row
How can I update this macro to only ...
0
votes
0answers
34 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 box. ...
-2
votes
0answers
20 views
Copy Sheet and rename based on two columns in a sheet [closed]
I need a macro for the below mentioned problem. Say for example: I have a column A and B in a sheet and in column A say I have 1,2,3,4,5, and in column B say I have A.b.c.d.e against each. Macro ...
0
votes
0answers
16 views
Get rid of the warning box when save an Excel macro-enabled file? [duplicate]
When save such .xlsm file, I got the below snapshot warning which is quite annoying every time I hit Ctrl-S to save.
How can I get rid of it?
1
vote
1answer
983 views
Office 2010 missing macros
I'm running a newly installed Office 2010 installation on a Windows XP machine, but whenever I try using some of its features, like equations in Word, I get this message:
The function you are ...
0
votes
0answers
59 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 ...
-3
votes
1answer
47 views
How to code this macro? [closed]
Well, I tried to look this up on the internet, and I did find something, but I couldn't understand how I could change the macro to relate to my Excel document.
This is the link to my 'something I ...
3
votes
1answer
21 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 ...
2
votes
2answers
4k views
Excel data into PowerPoint slides
I have already found some helpful sites but I'm still unable to do what I want. My Excel file contains few columns and multiple rows. All the data from one row would be in one slide but data from ...
-1
votes
0answers
25 views
Setting up a script to change the password to a random string [closed]
I am working with several colleagues on buying and selling virtual items. In the system we set up, we basically have to pool our resources into one account to have enough money to buy some of the more ...
0
votes
0answers
57 views
Need to find four common data columns in different locations in multiple workbooks
I am working from reports generated from different projects. Each report has varying columns but all have the four columns that I need. I would like to be able to boil the sheets down to these four ...
1
vote
2answers
936 views
Office 2010 macro issues
I have some macro enabled word documents that worked fine in Word 2003, but in 2010 I cannot get the macro security settings to behave properly.
When I first open a macro enabled document, I get this ...
0
votes
0answers
23 views
Outlook 2010 - performing a macro on all mail
I'm hoping this is a straightforward question - I have a working Macro that performs an action on the Inbox folder. I would like to modify this so that it looks at, and performs its action, on all ...
0
votes
0answers
28 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
31 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
2answers
45 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 ...
0
votes
1answer
1k views
Copy/move values matching a pattern to another column
I have a worksheet where we need to move all the values matching a pattern to different columns.
For example, we have a B column with values that are one or more letters followed by one or more ...
0
votes
1answer
21 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
19 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 ...
0
votes
1answer
31 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
0answers
12 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 ...
-6
votes
0answers
28 views
can I get other ip addresses to run a macro for me? [closed]
Need this done by tomorrow night.. says I can vote as many times as I want but my % is not going up. Anyone willing to let me forward them this macro and they run it? Max it at 500-1000?
1
vote
2answers
38 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 ...
0
votes
0answers
11 views
Disable delete table option
I have several tables in my word document template and the table numbers are used in macros. If an user of this template delete a table then the macros would go for a toss. How do I programmatically ...
2
votes
2answers
1k views
Excel 2007 VBA macros don't work in Parallels
I've got a complex Excel spreadsheet I need to use at work. My colleagues use the spreadsheet on Windows PC's, with no special configuration required. I want to run it on a MacBook Pro running Snow ...
0
votes
1answer
262 views
How to add a macro button to toolbar or ribbon in Word?
How can I add a button to a toolbar or the ribbon in Word 2013 to run a custom macro? I can run it using the keyboard but I want a button.
0
votes
0answers
49 views
How can I copy/move values below the matching pattern to another column?
I have found this script from this site which moves matching cell values to another column.
Sub MoveData()
Dim myrange, cell As Range
Set myrange = ActiveSheet.Range("B:B", ...
-1
votes
1answer
28 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
37 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]"
...
0
votes
1answer
350 views
Username password Macro or tool
I write extensions for a program. The program has a username/password dialogue box. There is no "remember my password" option. The task of entering this information is quite cumbersome and breaks my ...
3
votes
1answer
65 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
62 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 ...
1
vote
1answer
73 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 ...
-3
votes
1answer
43 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
102 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 ...
0
votes
1answer
54 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 ...
2
votes
4answers
5k views
Subscript/Superscript Hotkey for Excel 2010 Macro?
Background
In Excel 2010, for some ridiculous reason, there is no built-in hotkey (or even a button on the toolbar) for subscripting/superscripting text within a text cell.
You can, however, ...
0
votes
1answer
44 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
...
2
votes
2answers
33 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??
29
votes
7answers
86k views
How to control master volume in Windows 7?
Some keyboards have volume controls on them that can be pressed anytime to control the master volume. My keyboard does not have that. Is there a way that I can create a key macro that will work like ...
