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

2
votes
3answers
1k views

Bring back the object browser in Word 2013

In previous Word versions there was a very handy feature called "object browser" that allowed you to quickly navigate a document. Here is a very simple explanation of what it does: ...
0
votes
0answers
56 views

export windows file structure into .csv with date parameters

My real goal is to get a list of the files in my windows file structure into Access, but as there are over 500k files the various bits of VB code I've tried all take a very long time and is not ...
-1
votes
0answers
12 views

vba outlook access forwarded message

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
19 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 ...
3
votes
1answer
1k views

How to modify Out of Office (OOF) settings in Outlook 2010 via VBA

I work for an MSP and we have a single mailbox that we use to process incoming email requests into our ticketing system. I have created a VBA script that runs and processes new emails and such. We are ...
1
vote
0answers
18 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
16 views

VBA outlook custom action

I am trying to add a custom action to a rule that when a message is automatically forwarded that the attachment stays but the original body message is deleted. I need to write code for the 'clear ...
1
vote
1answer
64 views

Excel VBA - User Defined Function to turn string into formula

I'm looking for something similar to the solution posted here: Excel function that evaluates a string as if it were a formula? Problem is this does not seem to work with a function in there. This ...
-1
votes
2answers
44 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 ...
4
votes
9answers
38k views

Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...
0
votes
0answers
22 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 ...
3
votes
1answer
230 views

Why would an Excel 2010 spreadsheet with VBA lag when opened with other large excel spreadsheets already opened

I've got a relatively small (~100K) Excel 2010 spreadsheet that (via VBA) when opened, closes all worksheets except the start page, checks the user name and cross checks it with a SQL table, bringing ...
-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 ...
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
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 ...
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 ...
-4
votes
0answers
23 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
1answer
5k views

Excel vba code for adding a value to existing cell of sheet

i have this code to add value of a cell to existing value of other cell which is below Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not (Intersect(Target, Range("E3")) Is Nothing) ...
0
votes
0answers
10 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
9 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 ...
-2
votes
0answers
13 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 ...
3
votes
1answer
2k views

Macros in Excel 2010 hangs

I have a spreadsheet with several macros. Generally, when previously using Excel 2007, a user clicks a button and everything works as expected (calculations, some email sending & file I/O). ...
1
vote
2answers
72 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
34 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 ...
-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
43 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
17 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
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 ...
0
votes
1answer
6k views

Excel 2010 VBA - Trigger macro with ONE click on specific cell

Would you mind pointing a way to start a macro in Excel 2010 by clicking only once on a specified cell? I had seen a solution somewhere, but now I can't trace it back.
0
votes
1answer
62 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 ...
1
vote
4answers
137 views

Excel VBA - adding an element to the end of an array

Simpel Question I like to add a value to the end of an array and increase it automatically? I was not able to find such a simple example Public Function toArray(range As range) Dim arr() As Variant ...
-1
votes
0answers
24 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 ...
13
votes
1answer
42k views

In Excel 2013, where are Visual Basic, VBA, Macros, AddIn Tools?

In Excel 2013, where are options and tools such as Visual Basic (VBA), Macros and AddIn tools? Are they supported?
0
votes
1answer
3k views

Excel 2010: dynamic update of drop down list based upon datasource validation worksheet changes

I have one worksheet for setting up the data sources of multiple data validation lists. in other words, I'm using this worksheet to provide drop down lists to multiple other worksheets. I need to ...
-2
votes
1answer
49 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 ...
-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 ...
-1
votes
1answer
72 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 ...
0
votes
0answers
26 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 ...
5
votes
1answer
2k views

How to auto advance a PowerPoint slide after an exit animation is over?

PowerPoint entrance animation set up with "Start: With Previous" starts right when a new slide is advanced. However, if you set up an exit animation in the same way, it doesn't start with a slide ...
0
votes
0answers
21 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
1answer
6k views

Split Excel worksheet into multiple worksheets based on a column with VBA

Question is simple and may be repetitive. I have an Excel workbook which contains around 50 columns I have a criteria column for splitting this workbook into mulitple workbooks The approach is as ...
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
2answers
81 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
0answers
27 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 ...
1
vote
2answers
84 views

Excel 2010: Calculate full months between dates

I have dates in two columns and I would need to calculate amount of full months between two dates. I export the spreadsheet from SAP ERP in .xls format but opening with Excel 2010. DATEDIF function ...