VBA stands for Visual Basic for Applications, a subset of Visual Basic used in all Microsoft Office Applications. Consider tagging your question with the application as well as [VBA]

learn more… | top users | synonyms

0
votes
0answers
3 views

How To Extract Pattern from a folder path (VBA Excel)

I'm pretty new to vba excel and trying to reorganise a very large file structure. Basically, all our equipment has a tag in the form of [A-Z][0-9]0-9][0-9][A-Z] e.g. J452G being a compressor. Every ...
0
votes
2answers
15 views

VBA code to select certain worksheets in Excel and save as new workbook?

Is it possible to use VBA in order to select certain worksheets in an Excel workbook and save as new workbook file?
-1
votes
0answers
13 views

vba outlook access forwarded message [duplicate]

I'm using outlook rules to automatically forward a message but I need to access the body of the original message and delete it. Basically anything from the 'parent' e-mail (other than the attachment) ...
-3
votes
1answer
21 views

Find and Replace in all excel files

I am no programmer. Is there a macro/vba/tool that allows me to find and replace in all opened excel files, at once? If not, an external tool that allow me to drag & drop files, because I have ...
1
vote
0answers
20 views

Verify word document by vbscripting

Do you think vba will help me learn how to verify a word document by vbscripting. Or I have to strictly learn vb scripting for word documents. My main problem is I want to start verifying from line 7 ...
1
vote
1answer
20 views

Outlook VBA macro to forward email attachment, but delete message body

I am trying to add a custom action to a rule in Outlook where a message is automatically forwarded and the attachment stays but the original body message is deleted. I need to write code for the ...
-1
votes
2answers
48 views

Use Excel VBA If value in column a is not in column b then add value to column c

Dim i As Variant 'For i = 1 To 5 For Each i In rngWatch Dim c As Variant c = rngWatch.Cells(i, 1).Value If i <> rngReconcile.Cells(i, 1).Value Then MsgBox i ...
0
votes
0answers
24 views

How to enable macros by hard coding using VBA

I have an attendance tool in MS Excel which is built by having macros. Now the task is to enable macros in customers system by hard coding in the same tool itself when they using this tool for the ...
0
votes
0answers
8 views

Project explorer pane: font size

can one set the font size of the project explorer pane in VBA somewhere? I tried Tools, options, editor format, but that only sets the font of the body of code. Thanks
-1
votes
1answer
24 views

Remove duplicate PERSONAL spreadsheet

I have apparently two PERSONAL workbooks on my computer. I understand that I need one to store custom macros that aren't part of add-ins or attached to specific workbooks. I only need one, but due ...
-4
votes
0answers
24 views

Excel copy paste if macro vba [on hold]

In excel, can you help me build a macro/vba for this task: Copy-paste $M$1:$N$1 to Column M:N, if Cell in column C="price". Thank you all!
0
votes
0answers
12 views

save a sheet in new closed workbook without links

I have this code which work pretty good but I have a problem that the new exel workbook have links from the old one. Sub archive() Dim FileExtStr As String Dim FileFormatNum As Long Dim xWs As ...
1
vote
0answers
10 views

Incomplete ListViews for CrossReference

I am using Word 2010 and have to often insert cross-references. Items to be cross-referenced are mostly table numbers and figure numbers, such as Talbe 1-2 or Figures 2-4. They always include chapter ...
0
votes
0answers
38 views

Excel VBA Script How to Open a File and Insert character into Cell

I'm hoping this is an easy one. I am importing a directory of CSV files with long numbers (16 digits plus 4 leading zeroes). I need Excel to preserve the number data instead of applying scientific ...
1
vote
0answers
23 views

Excel update pop up, what is the root cause

Recently when I open my XLSM files (Excel 2013, Macro enabled workbooks) I see this popup. Can anyone please tell me what is the cause for this pop up? I am not referring to any URLs using VBA in ...
0
votes
2answers
28 views

How to add commonly used (non-signature) phrase in emails?

I have a text line with a hyperlink that I would like to readily use in composing emails. It is not a signature, so it doesn’t fit there. How can I build a macro that would allow me to add this text ...
0
votes
1answer
23 views

In Excel, how can I automatically change the data of a cell (VBA)?

I would like to automatically change the contents of cells when data is pasted into them. The data will be pasted into Column Q of a sheet on Excel. I need it to match it with data in Column A of ...
-2
votes
0answers
14 views

Outlook 2010/2013 prompt when sending e-mails, providing options to insert text

I am looking for a macro that works on both Outlook 2010 and Outlook 2013. It should prompt before sending any e-mail providing me 4 options, something akin to: "You are about to send an e-mail, mark ...
1
vote
0answers
38 views

Reset Numbered List with Text Style VBA macro MS Word

I'm trying to make a VBA macro to create a Word document from Excel... Currently I'm having issues with setting up the Lists properly. I want the list indexes linked to my 2 header types. Like so: ...
-1
votes
1answer
26 views

Macro - Moving User Specified Email to Folder

I have created small scripts before but never created an Outlook VBA before. I am hoping someone can guide me in the right direction or provide a couple lines of code to get me started. We receive ...
0
votes
0answers
19 views

Find and replace multiple values within selected cells using another workbook

I was wondering whether anyone could point out what's wrong with the VBA code below. It's based on the following: Find and replace multiple values within selected cells I want it to take the find ...
1
vote
2answers
73 views

Hiding all but the selected rows of data

I am unable to send any pictures, The data contains 98 column headings, with the first column being unique identifiers, and 1000 rows of items. I receive commentary on specific items throughout the ...
1
vote
0answers
16 views

Show Lync Status on Interactive Page

I have an idea for a concept and i'm not sure in what format it can/will be: Our organisation has many employees that sit across a very large office. We have a desk plan hard-copy that shows names ...
1
vote
1answer
40 views

Changing a String Value to Date format in VBA

I am working on a VBA scripting in Excel. The following is the code that i am working on. Option Explicit Sub MoveThingsAbout() Worksheets("Sheet3").Cells.Clear ...
-1
votes
0answers
33 views

Word VBA to show a list of tables or figures to insert a cross reference

I am using Word 2010 and have to often insert cross-references. Items to be cross-referenced are mostly table numbers and figure numbers, such as Talbe 1-2 or Figures 2-4. They always include chapter ...
1
vote
1answer
44 views

Word VBA of CrossReference

I am using Word 2010 and want to create a VBA script to insert a cross-reference. I often insert a cross-reference of table numbers and figure numbers. So, I want to firstly show a dialog to answer ...
-1
votes
0answers
26 views

vba method cells of object _global failed

I have this vba code. In the conditional statement, if the met condition is in env2, the code works fine. however if the condition met is in env1, the code fail with the error run-time error 1004. Why ...
0
votes
0answers
27 views

Excel 2013 - VBA has suddenly become disabled

I have an issue with Excel 2013 in that VBA seems to have suddenly become disabled. I am getting the following message "this workbook has lost its VBA project, ActiveX controls and any other ...
-1
votes
1answer
76 views

Excel 2010 VBA or formula to find value in dynamic column based off entry (vlookup like) but copy the value and paste the value into the cell

My question is rather complex so I will try to use examples and be clear as possible. In one table I have values that are populated based off formula: Name Timestamp Datedif1 123 1-Oct 1 ...
-3
votes
0answers
57 views

I want to compare two different columns and get a value from another workbook using VLOOKUP

I want a value from the workbook(2) by comparing two different columns from workbook(1) using VLOOKUP. I want a VLOOKUP coding like, if WorkBook(1)columns A matches with workbook(2) columns A then it ...
-2
votes
1answer
51 views

Excel, using cell text references as input for formula

First of all thanks for your help. I have a problem regarding the use of text into formulas. I am working on a huge dataset of stocks of several years. The stock are not correctly grouped. I used an ...
0
votes
0answers
22 views

How can I check that a filter applied to a listobject column with vba is legal?

Filtering a listobject(excel table) with a value that doesn't exit results all rows instead of none can I get no rows? can I get list of optional legal parameters? example listobject with col A ...
-1
votes
0answers
20 views

Code in MS Outlook 2007, for Calendar item settings

Is there anybody who knows some code, or place where to look, for editing an Outlook calendar item with VBA. Here's why; In my calendar I usually have 2 types of meeting. One is by default, business ...
0
votes
0answers
28 views

Area Under Curves in Excel

Are there add-ins for Excel that allow the user to get the percentage of values that lie less than or equal to some value x? Basically I'm looking for an add-in that takes the continuous valued chart ...
0
votes
0answers
30 views

Consolidating data from multiple sheets into a single sheet based on specific criteria

I have over 300 excel sheets all having stock data over a year. This data is date wise. However I want to group this data based on stock name, i.e., if I have stock A in all my sheets, then all data ...
0
votes
0answers
77 views

vba excel macro runtime error 1004

Dim lastC As Long lastC = wb2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'highlighted in debug SourceRange.Copy wb2.Worksheets(2).Cells(1, lastC + 1).PasteSpecial Paste:=xlPasteValues, ...
0
votes
1answer
36 views

Word VBA parse text and turn it into a table

Input: ##TABLE_START## ##ROWS=3 ##COLS=2 ##Value ##Decode ##0 ##Clock running ##1 ##Clock not running ##TABLE_END## ##TABLE_START## ##ROWS=4 ##COLS=2 ##Value ##Decode ##0 ##Off ##1 ##On ##Z ##High Z ...
0
votes
1answer
66 views

modify Excel macro to reference list of text rather than hard code

I’m trying to get some help with the last step of an Excel Macro I’ve been working on. I’ve set up a Macro that will take data from sheets from two different workbooks, and paste them into a third ...
0
votes
1answer
30 views

Powerpoint VBA References

I am writing a VBA code on Powerpoint, where I need to call and excel file for input. Programme is functioning fine, runs without error, and generates output, except for the part where Excel file is ...
1
vote
2answers
30 views

Code iterating slowly

I have a simple macro that gets creates 16 different versions of a template, updating by getting values from another open workbook. It is taking over a minute to iterate only 16 times and was ...
0
votes
1answer
66 views

VBA: How to replace entire Excel cell value basing on its content?

I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell. For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...
-1
votes
1answer
83 views

Break the forgotten encrypted password of excel workbook

i have an Excel 2010 workbook, on which i applied an Encrypted (128 bits AES) password, which i can't remember now, is there any way to remove/reset or retrieve that password or any method to retrieve ...
0
votes
0answers
24 views

Excel VBA macro - i need to insert column and add a default value to all the cells in that column

I have created a macro but i could not insert columns in it and i could not add values to that coulmn. I want to insert a column and the default value to that entire column should be CH. column ...
0
votes
1answer
50 views

Make formula impossible to find / read

I have developed a spreadsheet for performing various calculations which our employees will complete and then distribute to clients / competitors. To protect the "intellectual property" of the ...
0
votes
1answer
16 views

Formula to determine available options based on prerequisites

Example: A spreadsheet for a single studient has four columns: Course|Completed?|Prerequisites|Available The "Course" column lists the names of courses. The "Completed?" column indicates a "yes" if ...
0
votes
2answers
35 views

Specific Row Values in Excel

How can one ask Excel to record the value of all cells in a given column such that the row number is of the form row = 2^i for i in 1 to 100? Would this necessarily use VBA?
0
votes
1answer
26 views

Copy a specific cell on all sheets to master sheet

I have a master sheet with the format as below: Master sheet Column A Column B Column C No Description Price And multiple sheets with the format below: Sheet ...
0
votes
3answers
84 views

EXCEL - How to have a formula output and user input on the same cell?

I would like help from someone as I believe this problem requires VB. I basically have a CELL(A4) where people will be entering values to find out the corresponding calculations displayed below. ...
2
votes
1answer
19 views

Convert tracked changes to highlighted

I am looking for an automated way to convert tracked changes in Microsoft Word 2010 to highlighted text. So, in essence what I'd like to do is: Highlight all text fragments with tracked changes ...
-1
votes
0answers
8 views

Run-time error '13' : Type Mismatch [migrated]

While writing a Macro for Concrete Column, I have encountered a "Run-time error '13' : Type Mismatch" Error Here is the code. Option Explicit Sub Pu() Dim D, b, fck, fy, Es As Double Dim xi As ...