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
4k views

How do I install Visual Basic for Applications 2013 in Office 365?

I've recently taken out a subscription to Office 365 and have downloaded the desktop office programs. However, I'm trying to install an EPM excel addin and it's complaining that it needs "Microsoft ...
0
votes
0answers
40 views

VBA Editor on F8 shows outlook insted of Step Into

Excel VBA Editor on F8 shows Outlook insted of Step Into. I don`t use it and it wants me to add my e-mail configuration every time. In other applications F8 works properly. What am I doing wrong? ...
0
votes
2answers
1k views

How to read data from Excel Sheet using Excel VBA 2010

While in one Excel sheet I would like to read data from another Excel sheet and write it to a text file. Example of the first sheet: Sheet_Name File_Name Start_Line End_Line Sheet1 ...
-1
votes
1answer
27 views

Need Macro to perform formula based on cell not number

I am working on a budget workbook and in column I (I5-I1135) I have numbers that I need to upon prompt (such as CTRL C) have the numbers divide by 10 then multiply by 12.. Example: cell I5 has ...
0
votes
0answers
39 views

Excel Macro looping

I used this macro and it worked fine, but I needed a little bit more. I had to change LookAt:=xlWhole to LookAt:=xlPart and add the color formatting. Now, when I select a column, the Macro appears ...
2
votes
1answer
124 views

excel vba: to export multiple excel sheet into its designated jpg file

I am working on an excel vba command to export multiple excel sheet to its designated jpg file. I have 16 worksheet in one excel workbook and it would be best to export each sheet into jpg format. ...
0
votes
1answer
251 views

Excel formulas for budgeting sheet (or VBA code)

I'm (an amateur) and I'm creating a sheet to help me with Budgeting. I've got bills that I can enter, but that come at a variety of different intervals. I'd love it if I could enter the total from ...
0
votes
0answers
62 views

How to keep track of manual entries each day?

I am trying to keep track of manual entries but do not know the correct method of doing this. Should it be done using vba or by using formulas? I have spreadsheet you can view so you can see what I am ...
0
votes
1answer
260 views

Excel VBA: Rnd() method isn't random enough

I'm using Excel and VBA to simulate a large number of dice rolls. The problem I'm having is after a certain period of time, the rolls start repeating, and I start getting results that are anything ...
1
vote
0answers
109 views

Add-in vs sharing macro file in Excel VBA [closed]

I am writing a Macro that I want my team members to have access to on their machines so we can use it to upload some monthly data stored on some space accessible on the Network. This is my first macro ...
0
votes
1answer
103 views

Excel: VBA integral code

Just wanted to know whether there exists a well-known technique to calculate an integral in Excel. I've already read about implementing Trapezoid rule but before implementing this technique I wanted ...
0
votes
0answers
142 views

PowerPoint avoid animation completion on click & advance slide or start new one

Scenario I have PowerPoint 2010 On the "Transitions" tab the "Advance Slide On Mouse Click" check box is checked. I have a long, slow, timed, non-repeating animation working in the background of the ...
0
votes
0answers
173 views

How do I change dates in a pivot table using VBA?

How do I automate the checking/unchecking of dates in a pivot table? I have a pivot table from which I need to extract data based on a date range (last seven days, previous seven days). The ...
0
votes
2answers
184 views

How would I write a macro in Outlook 2010 to set all folder properties to “see all items”?

How would I write a macro to set all folder properties to "see all items"? I have hundreds of folders and subfolders and need to set the folders to see all items and I can't figure out how to write a ...
0
votes
1answer
2k 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 ...
0
votes
1answer
253 views

Offset the tickmarks of a secondary axis

I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that ...
1
vote
0answers
104 views

Incrementing ticket numbers each time I print

I have an excel sheet to print a set of 4 tickets per page which we use for stock takes. I found code that prints one number per page. Being a Visual Basic for Applications novice, I was unable to ...
0
votes
1answer
222 views

How to launch a dialog box with fill-in-fields in a Powerpoint 2010/2013 document?

I would like to set a PPT presentation which launches a dialog box at the opening of the document where I could directly fill in some fields with information (such as the name of my client, the name ...
0
votes
0answers
39 views

Change Default Email Delay - Adding Marcro to the Correct Toolbar in a NEW Message

Please refer to this article: Outlook: Change default email delay for "Do not deliver before" feature But, how do I add this macro to the toolbar for a new email message?? I can add it to ...
1
vote
2answers
626 views

Automatically save attachments from mail on a network drive

Every morning I receive an automatically generated e-mail from a server, it includes a spreadsheet attachment. I made a rule in outlook that captures these emails. Now, I would like to make a macro ...
0
votes
0answers
135 views

Excel VBA: Is it quicker to refresh all PivotTable caches than all PivotTables?

I'm new to all this VBA/macro stuff, and while I was looking for code to refresh all pivot tables in my workbook, I came across some information about PivotTable caches. I have ~14 PivotTables in ...
0
votes
0answers
43 views

Excel: Automatic data transfer when excel workbook updated

I'm wanting excel 2007 to automatically identify and transfer the new rows of data from one teams spreadsheet to our own. Is this possible within excel? I envisage a macro would be able to compare ...
0
votes
1answer
84 views

Excel 2010 - Show cell contents - wrong number appearance

I was trying to create a simple function in Excel VBA editor. When I click on a cell within the certain range, I want to copy its value into another cell I have set. Private Sub ...
0
votes
1answer
147 views

How to select all ActiveX objects in an area using a mouse in Excel?

Because of this problem with ActiveX objects changing size, I am not grouping my ActiveX objects in my Excel worksheet. Grouping them causes my solution hack to not work which is quite annoying. ...
-1
votes
1answer
122 views

Excel 2010 VBA on-start macro execution - Error

I have been trying to create a macro to be executed every time I open the document. I tried to use the Open event, but it does not seem to be working. The code is below: Private Sub Workbook_Open() ...
0
votes
1answer
306 views

Excel 2010 VBA - Make variable hold value after file is closed

Just like the title suggests, I am looking for a way to make a variable hold its value even after the Excel 2010 file containing the VBA code is closed, and retrieve it with its last value, the next ...
2
votes
1answer
540 views

VBA to move specific data from one column to another

I've tried requesting help with this before but have received no helpful responses. I need a Macro/VBA that moves any word in red from column A into column C as a list. However if the same word is ...
0
votes
1answer
112 views

Insert blank row on two conditions

I have a spreadsheet with a large number of rows. There are two rows grouped together (for each customer). In column A, the first row has an account number. The second row should be blank. The ...
2
votes
2answers
2k views

How can I compare two columns in Excel to highlight words that don't match?

(I'm using Microsoft excel 2010) OK, lets say I have a list of phrases in both column A and column B (see screen shot below) What I would like to happen whether it be with a macro, VBA or formula ...
0
votes
0answers
97 views

Microsoft Office 2010 - Programs crash at direct opening

I have been having this problem the past few days. I am working on a project I plan on getting working through VBA in Excel 2010, and that has resulted in an Excel file containing numerous Macros. ...
-2
votes
1answer
203 views

How to create a VBA form to match excel value to the name of the worksheet in the same workbook?

I am working on a self created VBA form. It has submit button and takes in entries such as destination, timing and budget. I have a excel worksheet named "bali". it consists of the destination's ...
1
vote
1answer
732 views

Importing Text in Excel 2010 - Overwrite previous imports

I created a macro, using the recorder, to add a specific .txt file in my Excel file, using a specific shortcut key, in a specific area of the open excel file. However, I've got this problem: when I ...
0
votes
0answers
45 views

objDataset(0) generates error in Microsoft Access 2010

This Microsoft Access Module has worked every week since 2007 without error but now in Office 2010 the line Set objResult = objDataset(0) generates the error Invalid Index 0 The code: Function ...
0
votes
1answer
2k 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
8k views

VBA code to hide or unhide rows based on a cell value

Heres my code, but its not really doing anything, I dont see anything wrong with it: Private Sub PG1(ByVal Target As Range) If .Range("E50").Value = "Passed" Then ...
0
votes
0answers
153 views

How to extract date-time from a string and format it to YYYY-MM-DD 00:00:00 & add back to the string in a excel column?

How to extract date-time from a string and format it to YYYY-MM-DD 00:00:00 & add back to the string in a excel column? The column can vary.So,it should allow to work on any column selection. ...
0
votes
1answer
308 views

How do I set the Name Box using an excel VBA macro?

I'm building a model that takes the results from the first sheet and inputs them into the next sheet. Effectively creating an application that runs in series. I have defined the values in the first ...
0
votes
2answers
135 views

Excel VBA Right Function Error

I'm trying to automatically update the date range on the top of my report in Excel based on the date range from data I download from a text database. In the below listed macro I get a Run-time error ...
0
votes
0answers
118 views

Split file macro, copy to template?

So I have obtained this code from Can I split a spreadsheet into multiple files based on a column in Excel 2007?, credit entirely to Mtone where I've ammended some basic formatting to that i've ...
4
votes
2answers
297 views

Counting pages within Word [.doc] documents

I'm trying to find a way of listing the number of pages within multiple word documents, all saved within the same folder. Is this possible using VBA? I am using: Windows 7 and Microsoft Office 2007 ...
0
votes
1answer
29 views

Custom Formatting dimensions of a box in Excel

I am currently creating a spreadsheet in Excel and setting a standard for everything I am copying in. Some of the text I am entering is different to the format I want it in. The format I want is for ...
1
vote
2answers
277 views

Excel formula/VBA to detect a property of a group of rows

I have a large dataset in an Excel sheet where: column A: quote number column B: opportunity number column C: sales order number. One quote number will have multiple opportunity numbers. A sales ...
0
votes
0answers
74 views

IF word in A1 matches word in Col C AND word in B1 matches word in Col E AND

Cell A1 contains a paragraph made of Hebrew words (They are Bible verses in Hebrew, so sometimes more than 254 characters long in each cell). Cell B1 contains a paragraph of English words (They are ...
1
vote
1answer
371 views

Recovering VBA modules from corrupt Excel workbook

I have a workbook that suddenly got corrupted. I am trying to recover the VBA code from it. I can open the workbook in Protected View by opening a blank Excel instance and then using Excel to open ...
0
votes
0answers
98 views

How to import html/javscript into excel worksheet?

I am tasked with providing a report with data visualizations via an excel file. I would like to make use of web visualization information (especially Google Spreadsheets charts, but maybe others) for ...
0
votes
0answers
23 views

Can you reliably apply 3-way-merges to Office Documents?

I'm looking for a fully reliable, automatically invocable way to merge document changes. Since Microsoft put yet another version of its Office suite on the market this year, there might be a chance ...
0
votes
1answer
119 views

Excel. Share table header and column properties through document's sheets

I am composing Excel document with my task-tables. It contains tasks, divided over several scopes. Tasks from every scope should be displayed in separate sheet. In every sheet, associated with a ...
0
votes
1answer
111 views

Move rows to new sheets in excel

I'm having a problem. At my work we often get spreadsheets with locations. We need to spread out each of the locations to a different worksheet. Because then we list nearby businesses to advertise to. ...
1
vote
1answer
46 views

Error when adding Developer inserts (IE: Command Button)

Running Visio 2010. I go to the Developer tab. When I try to insert any of the ActiveX controls (IE: Command Button), I get an error (even after uninstalling and re-installing Visio): An error ...
-2
votes
0answers
82 views

Get series values on condiation, excel [closed]

I have following data in my XLS - 8:35:01 NZLOAD app read: 2000005 01:03.0 8:35:03 Pending app INSERT 0 00:00.8 8:35:14 T4 app INSERT 1944132 00:09.6 8:35:47 NZLOAD app read: 2000005 ...