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)

0
votes
0answers
26 views

MS Word Macro to change string to Numbers in long documents?

I am as beginner as it gets with VBA and macro. I am looking to record a macro for MS Word documents that converts string to number. For example the document will have like (one thousand and four) or ...
0
votes
0answers
34 views

Excel 2010 - Combine specific sheet in >200 separate files into single worksheet?

I have tried solutions in other posts like this and so far nothing has worked :/ I have >200 separate excel files, and essentially I would like a specific sheet from each of these files combined into ...
0
votes
0answers
12 views

How do I create a macro in Excel for Mac?

I have found this thread on this topic How to get the list of sheet names of ms-excel? But I have no idea how to create the macro people are talking about. I will be grateful for your help on how to ...
-1
votes
0answers
32 views

How to create an intelligent macro script to automate tasks?

I want to automate a particular set of repetitive processes using a macro software. The one am using is "jitbit macro recorder". What it does is simulate mouse clicks and keyboard strokes. The problem ...
0
votes
1answer
15 views

If using radio buttons, do I need to save the file as macro enabled?

I have this .docx document in which I inserted some radio buttons. And each time I save the document I get this message. And I choose 'Yes' every time because as far as I know I'm not using any ...
-1
votes
2answers
11 views

Map key combo as WinKey [duplicate]

I just bought a ThinkPad style desktop keyboard that has no Windows key. Is it possible to configure a specific key combo to behave like the Windows key?
0
votes
0answers
8 views

Office Templates (with macros) in CrossOver Office 2010

I have a very specific problem. I am a policy debater, and I'm trying to install a Word template called Verbatim http://paperlessdebate.com/verbatim/SitePages/Home.aspx on my Chromebook for ...
-1
votes
0answers
23 views

Excel macro or VBA script to create rows from columns

I have a monthly project time spreadsheet which lists each project as a separate row, and each day for the month across as a column, i.e.: I would like to create a macro or VBA script which will: ...
0
votes
3answers
43 views

How to optimize VBA macro

I need your help optimizing this macro in Excel. I'm using it to generate data for labels for chemotherapy drugs in our hospital. The macro works fine right now, but sometimes it takes a long time to ...
0
votes
0answers
9 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 ...
0
votes
0answers
3 views

Creating Macros that reference templates in email folders

I can create a macro to use a template saved on my local drive, but how do I create a macro to reference a template stored in an email folder? How can I access a template in my email on my iPhone?
1
vote
1answer
32 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 ...
-2
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
1answer
25 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
17 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
18 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
27 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
101 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
25 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
51 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
34 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
26 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
24 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
12 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
32 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
13 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
0answers
43 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 ...
2
votes
1answer
110 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
36 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
64 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
23 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
33 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 ...
0
votes
1answer
71 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
41 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
20 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
46 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
24 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
54 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
37 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
67 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
25 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
47 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
66 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
32 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
39 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
138 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 ...