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 ...
0
votes
2answers
18 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
8 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
35 views
How can I update this macro to only copy columns B thru F onto the new sheet?
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
31 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
19 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
1answer
32 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
2answers
63 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
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?
-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 ...
-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
49 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 ...
0
votes
0answers
20 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
30 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
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 ...
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 ...
0
votes
1answer
28 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 ...
-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?
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
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 ...
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
48 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
25 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]"
...
3
votes
1answer
64 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
61 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
37 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
67 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 ...
1
vote
1answer
68 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
50 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
0answers
51 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
32 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
42 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
41 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
0answers
28 views
Excel 2010 macro - Personal Macros only available in new spread sheets?
I have recorded macros and stored them in the Personal Macro Workbook. The macros are available when I create new spreadsheets but they aren't available when I am working on existing spreadsheets. ...
0
votes
2answers
36 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
119 views
Word macro that loops through a table and stops at the end
I have movie scripts. First column is time code, second column is speaker, third column is dialog.
I want to loop through the entire script, but only doing something to the third column (dialog).
I ...
0
votes
1answer
58 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
62 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 ...
1
vote
1answer
46 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
53 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
313 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 ...
-1
votes
1answer
64 views
Data appears different after opening .xls file through a macro
I have extracted a file from a SAP system and saved it as spreadsheet with extension .xls.
I have another excel file which contains a macro to open the former:
Workbooks.Open Filename:= _
...
2
votes
1answer
145 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 ...
0
votes
0answers
40 views
Macro to link folder in Word 2010
I am new to macro and would be grateful if anyone can give me idea on this.
Users want to have a Word document with links. Each link is to open a folder by Window Explorer. I think I can create a ...
1
vote
1answer
64 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
82 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
86 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. ...
