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)

-3
votes
1answer
23 views

Excel Sheet Data Networking [on hold]

I am trying to find a formula where I can automatically update information across many sheets in excel, when data changes on one master sheet that will be added to daily. I am making a sheet for each ...
0
votes
0answers
7 views

My Excel Macro book crash after enable content

I have number of macro workbook. when I open it on VDI network and click on enable content Excel crashes, and I am not able to work. But when I open this workbook on Laptop it works fine. VDI ...
1
vote
1answer
21 views

Disable all Microsoft Office macros globally for all users

Due to popular "locky" and similar malware out there I need to disable macros for all installed Microsoft Office products (Word, Excel...) globally for any user who logs in into a particular server ...
-1
votes
0answers
5 views

Cluster network issue

Does cluster head of a clustered network may change the data packets of nodes other than forwarding packets of nodes to main server ? In more detail, as every node of a cluster send their data to ...
0
votes
0answers
9 views

best Macro tool to to fill up the forms/frames built in java applets [on hold]

I am looking for the automation of testing done on my application built in hava applets having tabs and forms where i need to fill up the form. I tried imacros but dint find it good enough to caputre ...
-2
votes
0answers
37 views

Compare two Columns and delete the gap Using Macro [on hold]

I have an Excel file and i want to compare the date in columns A and D and delete the gap between them. For example based on this picture: Time in column A start at 15:25:15 and in D at 15:23:52. ...
0
votes
1answer
23 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
0answers
16 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 ...
-1
votes
0answers
13 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 ...
0
votes
1answer
25 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 ...
1
vote
1answer
95 views

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 ...
0
votes
1answer
14 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 ...
0
votes
1answer
44 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, ...
-1
votes
1answer
17 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
16 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 ...
-1
votes
1answer
19 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
11 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
22 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
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 ...
-2
votes
0answers
35 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 ...
0
votes
0answers
34 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 ...
-1
votes
0answers
28 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
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
31 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 ...
0
votes
2answers
36 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 ...
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 ...
-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 ...
0
votes
1answer
51 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. ...
-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 ...
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
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 ...
0
votes
1answer
34 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 ...
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 ...
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 ...
0
votes
0answers
33 views

my code works fine as a macro yet fails when i run it in a button

So far, one line is failing as i try to pick apart the macro that works fine as a macro but fails when i copy the code to a command button click... Sheets(c.Value).Range("a1:i330").Copy ...
0
votes
1answer
50 views

Set printer Excel vba macro

Im trying to print through a macro to a shared printer on a colleagues PC. I have tried the following but to no avail Sub Tag() ActiveCell.Resize(1, 1).Copy Worksheets("Sheet1").Range("A1") ...
0
votes
0answers
23 views

Modify properties of tables in batch

I am working on a MS word document which contains several tables, and I want to modify the properties of all of them at once, such as alignment, text wrapping, borders and shading etc., and either for ...
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)?
0
votes
1answer
23 views

How to wrap my macro in a IF EXIST clause [duplicate]

I have the following code: If Sheets("EstimateTemplate").Visible Then Sheets("EstimateTemplate").Select ActiveWindow.SelectedSheets.Visible = False Sheets("Navigation").Select Else ...
-1
votes
1answer
59 views

Merge Data From Multiple Columns - Sharepoint Survery Results

I am using SharePoint to collect data through its survey feature. However, I want to make the output data more manageable. As such, I want to take the multiple columns and consolidate them into a few. ...
1
vote
2answers
31 views

Excel duplicate row consolidation

Could someone please help me out with this one I have no idea how to go about it. Here is the data set I want to combine the data from each colour from each method into 1 row. In this example ...
0
votes
0answers
32 views

How to create macro in excel to print selected cell and cell nexto it

I have an excel sheet which I fill in each day, is there a way of printing a selected cell say B2 and the cell to the left B1 to a dedicated label printer? If I select the bottom set of E numbers I ...
0
votes
0answers
84 views

Applescript/Automation in Outlook 2016 for Mac

Im trying to script some automation for some repetitive tasks I do in my workflow. My script (as of now) needs to accomplish only a basic task, but nonetheless, timesaving. I need it to (when called ...
0
votes
1answer
36 views

Unhiding a row using a macro based on cell value (for 10000 rows)

I am very new to macro. However, I found a macro on this website to hide rows with the value of False. I edited the macro to also make it unhide the row again, and it worked fine. The problem is that ...
0
votes
2answers
40 views

How can I delete rest of the line after a second the same specific character on string?

dagaga2.com:8ddagd1:dbcc:eLXLBdRdd?a'badagahaha dadadagh.com:299515:dgan6hhna:992969199269196 dad2agh.com:299515:dganhna:992969199269196 dadada5uwuwgh.com:299ju515:dgaenhna:9929691998d269196 ...
0
votes
0answers
16 views

Excel 2016 formula (from macro) not being calculated

I am using Office 360 (or Office 2016 by another name I believe). I have created a macro with the following code: Function CheckColor1(range) If range.Interior.Color = RGB(217, 217, 217) Then ...
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 ...
0
votes
0answers
7 views

Razor Black Widow - Manually Edit Macros

I love Razor's hardware, but their software is absolutely terrible. Is there any way of editing macros so that I don't have to go through Razors UI? I imagine there is some XML file sitting ...
-2
votes
1answer
36 views

How do I run a VBA function in Excel? [duplicate]

I want to run this function I opened the developer tab in excel, no clue what to do now. I tried creating a "macro button", and then paste the function code in the macro script, but if I press play I ...