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 [vba] tag instead of this one if the question concerns a Microsoft Office product. This helps the ...

learn more… | top users | synonyms (1)

-1
votes
0answers
10 views

importing Data from cvs files to excel and perform some steps using macro

I want to import csv files into one excel file using a macro and perform some steps for example deleting some rows based on matching the date in two columns. some times the imported information will ...
0
votes
0answers
10 views

How do I accept tracking changes for a specific symbols and reject for the rest of the text?

I would like to accept tracked change only for specific symbols like manual line break and break section and reject any other changes. How can I proceed? I guess it should be a macros which looks for ...
0
votes
1answer
19 views

How do I identify partial duplicates in an excel list?

I have a list of over 1000 company names, however some are duplicated but they aren't exact duplicates (ie: Nintendo, Nintendo Inc, Nintendo Video games, etc), is there a way to identify the ...
0
votes
1answer
7k views

Excel 2010: dynamic update of drop down list based upon datasource validation worksheet changes

I have one worksheet for setting up the data sources of multiple data validation lists. in other words, I'm using this worksheet to provide drop down lists to multiple other worksheets. I need to ...
68
votes
9answers
209k 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 ...
1
vote
1answer
43 views
+50

How to automate downloading several PDFs from a given webpage?

I am trying to download PDFs from this link. On clicking Read PDF, it opens a new window with PDF in it. On clicking the download button, it opens a dialog box and asks the user to specify the ...
1
vote
2answers
3k views

Workbook doesn't find macro

I created a macro in a workbook which is being used by several persons on their own computers. For some of them, it seems to work fine, but for other a message appears that it can't find the macro on ...
-1
votes
0answers
11 views

Why macro template is not working using my log in but works perfectly using my colleague's log in?

Could you please advise on this? Macro is working perfectly fine using my colleague's log in but whenever I log in and try to run the macro template, macro didn't finish generating the report. When I ...
15
votes
16answers
86k views

Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...
0
votes
1answer
23 views

How to run Sub with parameter in Excel VBA?

I have procedure in Excel VBA which is need range parameter and also will produce output range exactly in active cell. The code looks like this : Sub test(oSource as Range) Dim oTarget As Range ...
3
votes
1answer
7k views

Can i stop a blackwidow macro while its being executed?

I'm trying to make a macro for my blackwidow keyboard, which has to be executed until i press a different button. Can anyone tell me how to do this, or how tp stop a macro from being executed halfway? ...
0
votes
1answer
42 views

add space after nth commas in Excel, Notepad++, or emEditor?

Notepad++ 6.8.8 I want to be able to turn several lines that start like this: 0,2,3,45,67,89,01,234,567,890,123,4567,8901 0,7,8,9,0,11,12,13,14,151,162,173,184 x,z,q,r,n,f,t,a,e,f,z,n,a into 0, ...
0
votes
1answer
12 views

Hardwareinventory - Copy Record with values in Access 2016 Web App

I want to make a WebApp in Access which help me inventory all our Hardware. Below is a VERY wip ERM for the Database behind it. Every CPU-Object is its owm physical thing (if we have 2x i5-3450 there ...
2
votes
1answer
3k views

Excel 2010 macro to separate a large data file into workbooks

I found some code which works perfectly to separate a file based on a column (line 31) into separate tabs within a worksheet. I just need it to separate the files based on a column into a separate ...
-1
votes
1answer
13 views

How do I solve “runtime error type 13 Type mismatch” in excel VBA when clearing contents?

I have some VBA code that clears contents from several cells. Most of those cells have data validation so that a value must be selected from a list of options (yes, no, NA), the rest are open for any ...
0
votes
0answers
14 views

Excel 2010, “Runtime Error '32809': Application-defined or object defined error”

I am having this error when I open up certain workbooks that contain macros. The files are stored on a network drive and this error only happens on a few computers which leads me to believe the ...
9
votes
7answers
56k views

How to turn hundreds of text URLs in Excel into clickable hyperlinks?

How do I turn a column of urls into hyperlinks, so that users can click on the url in a cell and have it open in a browser? I pasted 100 urls and each went into its own cell. When I double-click in ...
-1
votes
1answer
18 views

Excel macro to print 3 pages with same number and then increment

I have an excel sheet to print a set of 3 pages which I use for a timesheet. I need some kind of macro which can change numbers after every three sheets printed . So, the first three sheets are 0001 ...
0
votes
0answers
10 views

How to Create Keyboard Macro to Adjust Sound Level Momentarily

Basically what I'm trying to do is figure out a way to somehow reduce the sound output level of my system to a certain level (say half volume) and bind that to a keyboard shortcut. Ideally, the volume ...
0
votes
0answers
21 views

Microsoft Excel - Run-time error '1004': Application-defined or object-defined error

I received this workbook from a co-worker. Each time I run the marco I get an error that says "Run-time error '1004': Application-defined or object-defined error". All I believe this marco does is ...
0
votes
2answers
35 views

Need help to hide/show excel rows based on value in a cell, but allow for moving rows around later

In Row 4 I ask a question and D4 will contain the answer of either Yes or No. If the answer is Yes in D4, I want hidden rows 5 and 5 to appear with follow-up questions. This is working for me: If ...
0
votes
0answers
10 views

Automatically adjust row height with text wrap and merged cells

I'm copying text from worksheet 1 which has merged and wrapped cells in the same row, into a cell on worksheet 2, the cell in worksheet 2 is text wrapped and merged with other cells in the same row ...
0
votes
1answer
44 views

how to add a background color to my IF statement

if have the following IF statement: =IF(R1=R3,"GreenBG","RedBG") how can i add a background color using the IF statement (is it even possible)?
-2
votes
0answers
31 views

ActiveX 'Command Button' causes Excel 2016 to crash?

This problem has started occurring recently, although I've had no issues in the past. I have not updated or otherwise changed the program environment. I have several 'Command Buttons' (a type of ...
2
votes
2answers
4k 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
0answers
30 views

Opening Google Chrome with macro instead of IE

I have a question regarding a VB macro that opens automatically a file in IE 11. The problem is I cannot get the download prompting to disappear (believe me, I've tried everything from Tools in IE, to ...
4
votes
7answers
21k views

Keyboard macro to change default audio device

Windows 7, Logitech G110 keyboard 2 audio devices (headphones and speakers) I am hoping to find a quick way to macro a key to switch to headphones, and a key to switch to speakers. Anyone have a ...
-1
votes
0answers
27 views

How to convert VBA code from Excel to Word?

I really would love to get the following code working in a VBA for Word. But it doesn't work, i found some other code but it just didn't do what the code below does. I would like to mark all the text ...
2
votes
2answers
5k views

Can I remove an OTF macro from a Razer Deathstalker?

I recently bought a Razer Deathstalker, and the other day I managed to activate the OTF macro recorder by accident, so now I have random gibberish and key presses bound to regular keys, so typing ...
2
votes
1answer
107 views

Excel Macro to create 8 character username

I'm trying to use an Excel VBA macro to create an eight character username and what I came up with fails. If entered in a cell, the formulas seem to work. In my spreadsheet, I have the last name in ...
0
votes
1answer
29 views

Excel Spreadsheet - Distributing Master Sheet rows and deleteing duplicates

I have a master sheet that I have the row distributing to different sheets with specific labels. I want to have each row distribute to the appropriate tab (from the Master) dependent on the ...
1
vote
1answer
52 views

Macro to change font in email, dependent on which email account is being used

I have several different email account for different companies I work with, and each one has a different corporate font for emails. Anybody got any ideas how to quickly change this over when ...
0
votes
1answer
4k views

Excel 2010 Legend key color based on text

Background I've an excel template. This template I populate with data by running a program I've written. The excel template has a pivot table on a sheet that get's data from another sheet that I've ...
-3
votes
0answers
63 views

Vba formula that colors a certain data in a column when the corresponding data of the other column were found having more than 1 value

I have serial numbers of different products in column D. Each serial is duplicated several times through out the column. I want the serials that have more than one price corresponding to them in ...
1
vote
1answer
18 views

Assigning a variable based on a formula in VBA Excel

I'm trying to do a simple a macro that runs a formula and displays it in a msgbox. Right now I have: Sub basic_messagebox() Dim CAT1 As Integer MsgBox "The total number of possible Cat I: " ...
0
votes
0answers
24 views

Need a Word doc “Submit” button which attaches doc to Lotus Notes 8.5 email with defined recipient

I need to create a "submit button" (Macro) at the end of a Microsoft Word document template form. When button is clicked it attaches the document to a Lotus Notes e-mail (we are using 8.5) and has ...
1
vote
2answers
3k 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 ...
2
votes
1answer
3k views

Pull Data from Excel Worksheet to Another Based on Defined Values

I have two excel worksheets which have data cells. I want that if a cell in column J equals a certain value, let's saying "Negotiating", then it automatically pulls that row to a new worksheet. The ...
0
votes
1answer
46 views

Add a Word 2016 startup folder for macros in the registry

I need to set a startup-folder for my macros for Microsoft Word 2016. I thought that adding a "AltStartup" registry key would work - because it works in excel but it does not seem to work with Word. ...
0
votes
1answer
3k 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 ...
-1
votes
2answers
40 views

Macro (on button) to modify row where the cursor is

I want to be able to have a button on an Excel sheet, place cursor on any row/column on the sheet, click on button and the entire row defined by cursor row/column will modify (color fill and maybe ...
2
votes
2answers
3k views

VBA to move specific data from one column to another

I've tried requesting help with this before but have received no helpful responses. I need a Macro/VBA that moves any word in red from column A into column C as a list. However if the same word is ...
0
votes
0answers
18 views

How can I protect excel macros - Office 2013 on OS X

I've Googled how to protect macros in Excel. I keep getting directed to go to "project properties" under "tools" in the VBA editor. However I can't actually find this option. I'm guessing its because ...
0
votes
1answer
30 views

How to create multiple sendkeys macro linear order of operations

Range ("D5").Select ActiveCell.Resize(1, 25).Select SendKeys ("%y1"), True 'Alt+Y1 SendKeys ("%y2"), True 'Alt+Y2, Activates third part add-in SendKeys ("~"), True 'Enter, initiates the merge add-in ...
0
votes
1answer
12 views

Add four spaces at the beginning of every selected new line in batch

In order to add lines of code to a post properly, I'd like to add four spaces (U+0020) at the beginning of every selected new line, the previous line ending in a paragraph break, so that I can just ...
1
vote
1answer
52 views

exclude specific strings of words using wildcards

I cannot seem to come up with the appropriate wildcard (I suppose it must be [!]) which would exclude from the expression argument[oales]{1,4} the following three words argumentos argumenta ...
2
votes
2answers
36 views

Can I retrieve and access a simple JSON object via HTTP in LibreOffice Calc?

I've located a web API resource that I'd like to access from LibreOffice Calc. It returns a simple JSON/JavaScript object that's basically just a handful of name value pairs, one of which I want to ...
3
votes
1answer
61 views

Apply an Excel VBA function to many files

I have an Excel VBA function and around 30 files with data (and the same data structure) to which I would like to apply the function to. My approach would be to write a macro in a separate Excel file ...
2
votes
0answers
22 views

Converting Multiple .doc files to searchable .pdf

I have a batch command file that runs daily converting data extract files to .txt, .doc, and then to .pdf formats. I run a series of formatting macros in Word on the .txt file before saving to .doc ...
6
votes
4answers
14k views

How do I create a Macro/short cuts in Eclipse?

How do I create a Macro in Eclipse? For example: I want the combination alt+s will print on the page //********************************************************************