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

learn more… | top users | synonyms (1)

-1
votes
1answer
5k views

How to write Excel macro to copy selected row of data between two sheets?

I'm not really experienced in the whole VBA area, i get how macros work but this is just out of my reach. Basically as i stated in the title i need to write a macro that will copy the selected row or ...
0
votes
0answers
834 views

Hack for running multiple iMacros in random fashion

I have 20 iMacros (for browser) and they are specific to different URLs. I run these macros one after another, and then repeat or loop all of them 10 times. But within that loop, i need those 20 ...
0
votes
1answer
192 views

How to shift unique values down a column to the same value in another column?

My friend has two columns where one has unique values and another column has those same values but also duplicated like shown below Column 1 Column 2 ABC123 ABC123 CDE456 ABC123 EFG789 ...
1
vote
2answers
87 views

String Manupulation in VBA

I have single column that needs to be split to multiple, like Text-to-columns in excel. However there is a small challenge. Conventional delimiter will not work. Consider the string below Original: ...
0
votes
0answers
46 views

Excel workbook contains a userform which opens up black on 8.1 office 2010

The userform within the worksheet opens black on windows 8.1 office 2010, yet it opens fine on XP with office 2010. It's a excel 79 to 2003 xls file. We checked trust centre on 8.1 but no joy, ...
0
votes
0answers
20 views

Server Tasks Automation

I would like to run some tasks on my Windows 2008 R2 server and need some kind of automation. Right now I am running the tasks with my Macro Recorder - BUT - I need to be connected via RDP in order ...
0
votes
1answer
30 views

Store user's personal Excel column filters in a cookie-like file?

I'm developing a reporting app (how exciting!) that puts out HTML, PDF, and Excel reports. In the HTML version I let the user select which columns they care about, and filter out the others. This is ...
1
vote
1answer
685 views

Easily type Unicode characters using AutoHotKey?

For example, I want to be able to type → (right arrow) using AutoHotKey's text replacement feature, and this is what my script looks like: ::|rarr::{ASC 2192} So when I type |rarr in my text editor ...
0
votes
1answer
281 views

Create a shortcut for Notepad++ to reopen a closed tab?

To reopen a closed tab in Notepad++ you press ALT+F&1. I was wondering if there was a way to make a macro or program to do this so that I can press link it to the shortcut CTRL+SHIFT+T instead, ...
0
votes
0answers
112 views

How can a Macro sort dates from oldest to newest?

I'm doing account statements in a bank and I need to be able to make them fast, so I am using macros for making this process. However, there is a step that I always have to do that a macro won't let ...
0
votes
2answers
231 views

VBA Excel: How to assign .txt file content to a string type variable?

I made a little sub in excel that sends an email according to the parameters you enter: Sub Mail_LSP(mailsubject As String, consignee As String, coalcopy As String, mailbody As String) Dim mlook As ...
1
vote
1answer
1k views

Find and replace multiple words in a column in Excel 2007

Sub xLator2() Dim s1 As Worksheet, s2 As Worksheet Dim N As Long, i As Long Dim from(), too() Set s1 = Sheets("Sheet1") ' contains the data Set s2 = Sheets("Sheet2") ' contains the translation ...
0
votes
1answer
33 views

Format text list with corresponding key into spreadsheet

I have a text file with dates arranged as such. name1 2010-01-02 (i) 2010-05-07 (i) 2010-06-12 (i) name2 2010-01-02 (i) 2010-05-07 (i) 2010-06-12 (i) name3 2011-01-05 (i) 2011-05-05 (i) 2011-06-14 ...
0
votes
1answer
327 views

Hide columns based on content (sum of rows)

I'm trying to hide columns based on the sum of selected rows (i.e., cells) in those columns. For example - if the sum of E9:E12 is 0, then hide column E. Additionally, and probably a little harder - ...
0
votes
0answers
104 views

Can I write a Macro to export data from Web?

I need to write a macro that can import data from the web (salesforce.com). Is it possible to pull data from the web through a macro? The data I will pull from salesforce.com, is a monthly task. Can a ...
0
votes
0answers
66 views

Convert HTML to Word and embed file hyperlinks as attachments.

I have some HTML files that I'm opening with Word and saving as docx files. I have some macros I run to break the links on the graphics so that they get embedded in the doc file, but I haven't figured ...
0
votes
0answers
64 views

Script/Macro to print 1st page of 1000 pdf to same printer

I have a folder with 100+ PDF documents each of varying number of pages. I need to print the first page of each document to a printer which adds a VAT code to the document (kind of like an ...
1
vote
4answers
83 views

Looking for an application which types the string or text I give to it [closed]

The usage scenario is typing the product keys into the mutliple textboxes. The app is supposed to press all the keys for me when I press some keys like, ctrl+Q. I don’t think such an application ...
0
votes
1answer
797 views

Create an Excel Macro to categorize data based on values (by writing data to a cell based on the value in another cell.)

I'm completely at a loss for complex excel tasks, but I'm facing the following situation. I've got a large list of inventory items with various lengths, but I need to convert the exact lengths (as a ...
0
votes
0answers
142 views

VBA Excel: Macro working well, add-in does half of the job

I created a macro that: 1.takes the value in cell "D11" then 2.trims the value acording to some criteria, then 3.opens another workbook ans searches the trimmed value then 4.copies some info to ...
0
votes
0answers
123 views

Automation of solver in Excel by VBA macro code

I'm solving a 3rd degree polynomial equation, e.g., -0.003x3 +0.195x2 -1.087x -180 = 0 in Excel. I can do this by SOLVER of Excel and can find the value of x. The problem is the constant term ...
0
votes
1answer
42 views

Notepad++: Insert comment-sections of same length via Macro/Shortcut?

I'm often using comments (using =====) to divide sections within my files in the same way which look always the same, e.g.: #===========================================# #============== IMPORT STUFF ...
0
votes
1answer
180 views

Months and Date keep being switched around when running VBA

I have a column on my sheet, Column F which is full of dates. Now I need these dates to be in this format "dd,mm,yyyy" but sometimes they are in text form, us/armenian format in the original data. Why ...
0
votes
2answers
777 views

Excel concatenation of one column based on values in another

Similar to this: Excel - pivot values in one cell (as comma-separated value) Except it can be a VBA solution, and I do not have duplicates in Column A. Instead, there are blank rows below each value: ...
0
votes
1answer
360 views

Sort with a Macro

I have a spreadsheet with 8 columns of data. (Row 1 contains my headers). I am trying to record a macro that I do not have to edit afterwards. I press record macro, I highlight my data, I go to the ...
1
vote
1answer
3k views

How do I copy hyperlink only (and not text) to another cell? [duplicate]

I have a spreadsheet where column A displays names. There are a few hundred names and each has a different hyperlink (which links to that person's web page). I want to transfer those hyperlinks across ...
0
votes
0answers
24 views

Open image on specific monitor (trigger with Windows Speech Recognition)

I am using a speech recognition macro to open an Image with Irfanview on my Windows 7 system. What I want to do moreover, is to force any new window emerging due to the macro to open in a specific ...
0
votes
1answer
109 views

How can I sort data that is organized in 4-row chunks?

I have an Excel document with six columns and 57,000 total rows. Each record comprises four rows, that is, each set of four rows goes together. How can I sort this data by one field while keeping the ...
1
vote
1answer
2k 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 ...
1
vote
0answers
78 views

MS Word 2010 macro to renumber pages within the footer of all sections.

My problems is that I also have a divider page which originally I provided -1 in the page field to get the appropriate count. Could you please advise how I can manipulate the macro to take this back ...
1
vote
2answers
89 views

Copy selected items in Excel filter

I have been strugling for past several day trying to resolve this issue. Here is what I have and what's needed: I've got about 20 Excel sheets that contain massive data (around 50K rows/sheet) that ...
0
votes
1answer
494 views

VBA EXCEL: find method not working when looping through each cell in selection

I'm trying create a macro that, after a range selection, will tell me how many 20ft or 40ft containers where found in the sample. The macro basically looks for the string "1x20" or "1x40" and when ...
-1
votes
1answer
98 views

How to split up above single cell Address value into multiple cell value through macro

How to split up the below single cell value into multiple cell value through macro ? So, this... A1 = MISS FirstName LastName***95*SPECIAL ROAD**LONDON SW92**SW929AB ...should split as below, B1 ...
0
votes
2answers
280 views

Split single column data into multiple columns based on leap year in Excel 2013

I have about 100 files of MS Excel which consist of weather data. I need the data on yearly basis but the file has a single column with data of about 140 years and manually copy-paste is very time ...
3
votes
2answers
131 views

How to get rid of macro leftovers in Excel?

Old macro workbook from Microsoft samples gallery left items on the ADD-INS ribbon tab, highlighted by yellow: These cannot be deleted or at least I don't know where to find them – see Customize ...
0
votes
1answer
52 views

PPT Macro go to last instance of certain slide layout

I have a macro (below) for a button that I need to use. What I want to do is change the value of lngCurr to the layout 'section header' and make it so when the macro runs, it takes the user back to ...
0
votes
2answers
195 views

VBA Excel 2011 for Mac: Create custom category for user defined function error

I created several functions i.e.: "cal_adval". I would like to add it to a new function category named "Custom Clearance" I read the documentation, and wrote this macro: Sub add_category() ...
1
vote
1answer
838 views

Set the primary maximum and minimum Y-values equal to the corresponding secondary Y-values on a graph in Excel?

Is there a way to set the scale on a chart so that the primary maximum and minimum Y-values equal the same values on the secondary Y axis as well? Basically I have a number of different stocks I'm ...
0
votes
1answer
265 views

PPT 2013 add macro to image?

I have a back button which is an image with an action linked to it. That works fine, but there is a background video which, when I go back to a slide won't play by default, which doesn't look good. ...
0
votes
0answers
38 views

LIBREOFFICE: Macro to convert LTR to RTL selectively. (BiDi issue)

I use Scrivener to write my essay that consists of BiDi text formatting. The sources I quote are in Arabic whereas the commentary is in English. I then export my file from Scrivener to ODT format. ...
0
votes
0answers
52 views

Windows filename formatter BAT script?

At work we upload files for publishing to the web. The filenames people use are atrocious. Is there something easy out there like a .BAT file that they can drag the file on to to have it clean up the ...
1
vote
0answers
44 views

How can I make emacs ignore bell when recording macros?

Currently, emacs will halt the recording of a macro when the bell rings. This is extremely useful for things like halting when C-s fails to get a new match. However, when I'm recording a macro, and ...
0
votes
1answer
173 views

VBA Code De-bugging in 2010 excel

Looking for some help in debugging some old VBA/Macro code to work in the newer version of MS Excel 2010. The macro in question is the "Material Rollup" function. The purpose of the macro is after ...
0
votes
3answers
78 views

Reformat data through macro excel 2010?

I am trying to create a macro that allows me to change the data I received from a client into data I can import into a system. The data I receive is in the format: How Can I do this through VBA ...
0
votes
1answer
87 views

Clever way to connect multiple images to on-click macro - VAB Excel

I have asked this question before, but admittedly in a terrible way, so I am asking this again. So here I am once more. I am making a program in VBA Excel - or better, combining a certain worksheet ...
-2
votes
1answer
306 views

Macros to parse excel data [closed]

When I am copying the data from putty after queries like ( Select * from tis_zfb where rownum<2; ) the data is getting shrinked, the null values are getting replaced by the values from there right. ...
1
vote
0answers
32 views

Outlook Macro not firing

My macro was working fine the other day, but as of today, it does not. I have not changed the program, nor the code, nor updated via Windows Update. I use Kaspersky. When the user clicks send, it ...
0
votes
1answer
194 views

How to use Advanced Editing in Notepad++ or similar

I would like to be able to edit sections of text in the following way. I might have a section as seen below. Example. Instance=wall { VisGroups=(32) MeshFile=wall.gmt CollTarget=False ...
1
vote
0answers
72 views

AHK Gui button working as a toggle?

I have been searching for a while now on how to make a GUI button work as a toggle for a simple loop. I'm stumped and need help. Here's my code. #NoEnv #SingleInstance force ...
0
votes
1answer
82 views

Automatic backups (history) in LibreOffice (OpenOffice)

LibreOffice can create a backup copy when you enable it in settings (Options > Load/Save > General), but it saves only the previous state (one only). It has also an versioning feature (File -> ...