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
2answers
55 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
43 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?
-3
votes
1answer
29 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
27 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
2answers
111 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
143 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
16 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
11 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
55 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
29 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
32 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
39 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 ...
1
vote
0answers
111 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
50 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
30 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
81 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
27 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
78 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
vote
1answer
64 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 ...
0
votes
0answers
42 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
155 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 ...
-2
votes
1answer
74 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
31 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 ...
0
votes
0answers
52 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
138 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
60 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
97 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
50 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
35 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
223 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
176 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
43 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
60 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
21 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
37 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
44 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
139 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
22 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
vote
1answer
1k views

Execute SQL Query with VBA and fill sheet with data

Very new to any form of code. Attempting to run a script in VBA that will pull data from an access database using SQL and put it into an excel spreadsheet. Code is similar to below. Runs clean but I ...
0
votes
1answer
15 views

Formula to incorporate Highlighted text & Loop function

I'm trying to analyze over a 1000 line items, with different information in all columns ,although certain columns might have duplicate information. I can do conditional formatting and highlight the ...
0
votes
1answer
60 views

User Input to Select and Fill In value for Cells

I have this excel table: A2 to A11 are class names Class_1, Class_2,..., Class_10. B1 to K1 are student name 1,2,3,...,10 For each student in his class, I will need to fill out his grade I would ...
0
votes
1answer
41 views

merge two exel sheets and update duplicate value

I have two exel sheets and I need to merge this sheets but in sheets 1 i Have 800 records in sheet 2 i have 20 records and some of value from sheets 2 are duplicated in sheet 1. I wan to update ...
0
votes
1answer
50 views

Spreadsheet data checking columns

I am trying to separate datas from columns(A,B&C) based on datas from an index table at columns (E&F) I need to list only those data from columns A/B/C when column B data has no corresponding ...
2
votes
1answer
98 views

Adding attachment option to scheduled email vba script

I am learning VBA, but for the time being I am not that good and I found this macro: Scheduled and recurring email in Outlook? It sends an email thanks to a scheduled appointment set in the ...
-1
votes
1answer
71 views

Automation Error Catastrophic Failure

I am trying to use excel VBA to copy some charts to Powerpoint slides using the below codes, but it shows error "Automation Error Catastrophic Failure". I can not figure out what is the problem. I am ...
1
vote
1answer
48 views

Excel automatically adding an extra row with formulas for the inputed number of years

I am looking to build a model. I would like to have an input page where you input the range of years you would like to cover. Depending on the inputted number of years, I want a table (on a different ...
0
votes
1answer
109 views

How to automatically replace Excel formula with value when date/time condition is met

I need to record results of a constantly changing cell based on external criteria. Cell B3's value is changing, and I need to record the value of B3 at specific points in time. Cell D2 contains the ...
0
votes
1answer
32 views

Excel: Referencing a named range inside a formula

I have two tables, the first table has 6 column and each column has a defined range name as follows: Col 1: Broker_Name Col 2: Broker_Market Col 3: Client_ID Col 4: Client_Location Col 5: ...
0
votes
2answers
232 views

How to add custom styles to navigation pane or change them with VBA

I have a Word2010 document that was created by a tool from Axure. Each heading is formated with a custom style ("AxureHeading1", "AxureHeading2", "AxureHeading3"). I was able to create a table of ...
0
votes
1answer
40 views

Excel - import data from cell automatically when a new tab is created

I am working on a spreadsheet summarizing data from standard templates inserted in a joint Excel file as separate tabs. Is it possible to automatically import data from a specified cell into a ...