Visual Basic for Applications; a subset of Visual Basic used in all Microsoft Office applications. Consider using this tag together with the tag for the specific application in question.

learn more… | top users | synonyms

0
votes
0answers
161 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
75 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
107 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
55 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
37 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
316 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
287 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
55 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
64 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
38 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
52 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
174 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
24 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
2k 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
68 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
50 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
51 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
142 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
93 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
53 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
167 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
423 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
46 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 ...
2
votes
2answers
32 views

I would like to copy data from 1 row to another in Excel

I am trying to solve the following issue in excel: I am working in two sheets, Sheet 1 and Sheet 2. There is a column of data in sheet 1 (say from A5 to A20). I need every row from that column to be ...
0
votes
1answer
76 views

Using VBA to calculate unique random numbers in “i” number of rows

I am currently working on a pet project of mine. I am currently making a combat calculator for a gaming group I DM. Essentially, I have a table with the monsters and their stats, and a cell with the ...
1
vote
4answers
2k 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 ...
0
votes
0answers
71 views

Set default outlook send address based on TO field

Is there a way to have outlook pick the right email address based on the TO or CC fields? For example, if I am sending an email to domain1.com, use account1@domain2.com, else ... I am open to ...
0
votes
0answers
16 views

Adding numbers based on their relative position in a worksheet

I have nearly 10,000 numbers arranged on an excel worksheet to form the map of USA. Now I want to separately add the numbers based on below mentioned four criteria: 1.0 Corner cells i.e cells flanked ...
0
votes
1answer
62 views

Timestamp in Excel…not working?

I know this question has been asked numerous times, and I have truly searched and attempted to work it out with the given solutions to no avail. Maybe I'm doing something wrong, but I don't know much ...
0
votes
0answers
76 views

comparing two columns for matches then return values meeting certain conditions

I have the following: column D ( 300 values representing the average of three cells, A1:A300 & B1:B300 & C1:C300) column H ( 50 values ) column E & column F & Column G; they are to ...
0
votes
1answer
1k views

How to bypass the VBA project password from Excel

I need help with password retrieval or bypassing the password on a project that was done at work. The author has used MS Excel to do the project, and it's in the client's server. The server that we ...
0
votes
1answer
485 views

Excel Pivot Table - How to preserve Filter and Sorting when Data get refreshed

I have a pivot table (Excel 2010). Every Time when I update the data and make a refresh, the sorting and filters of the Pivot Table get lost repsectively I need to explicitely to modify the filter ...
-2
votes
1answer
50 views

VBA dates filter [closed]

easiest way to explain this is to use a example. I have two dates(f.e.) "2014-08-08T8:11:31" and "2014-08-11T13:53:29". I need to gave them proper form(date),exclude weekend(Saturday, Sunday ) and ...
0
votes
3answers
1k views

Run excel macros (vba) from vbscript file

I have a vbs file that pulls information from my database and exports the data to an Excel file (C:\file.csv). Once this is done, I run a series of macros (vba) to format this data. These macros are ...
0
votes
1answer
30 views

extracting labels of data in a pivot table

When I move the mouse pointer over data in a pivot table it displays what are the row and column labels (names of pivot items). How can I extract them so I can later use them in a code (when I want ...
1
vote
2answers
202 views

Changing DateTime format in multiple CSV files

I've got multiple csv files with this structure: text, text, 01/27/2001 01:00:00 PM I need to update ALL csv files with this datetime format: text, text, 27-Jan-2001 13:00:00 Is there a known ...
0
votes
1answer
72 views

Excel - How can I collapse data, eliminating blank rows?

I have a 3 column, 20 row table. (A1:C20) The 3 columns are each 1 digit of a 3 digit number. Some of the rows have 3 digits, some are blank. I need a way to return all the non-blank rows of 3 ...
2
votes
1answer
113 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 ...
0
votes
0answers
39 views

Keep header text in Excel, but change font

I've seen several examples for changing the header font in Excel; however none of them just change the font. They seem to always incorporate static text or a cell reference. How do I change just the ...
0
votes
2answers
1k views

How can I trigger an Excel macro by hovering a mouse over a cell?

I have not been able to figure out how to run an Excel macro by moving my mouse over one or more cells in my spreadsheet.
0
votes
1answer
49 views

How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2 And i have macro called "AAA" in instance 1 and "ASD" in instance 2 i want to call "ASD" in instance 2 ...
5
votes
2answers
187 views

How do I add VBA in MS Office?

I've seen posts showing answers which use VBA (Visual Basic for Applications) code/macros, however, I've also noted additional comments afterwards about how to use the VBA (how to implement it). I'm ...
0
votes
3answers
599 views

Excel formula to compare single value in one cell with multiple values in other cell

I have a value in Column A, which I want to compare with multiple values in column B, and depending on that value, put the answer in column C. For example, using the table below, it searching in ...
0
votes
1answer
48 views

Excel macro to save workbook on another session of excel

Im trying to make a macro in one session of excel that saves a particular workbook in another session of excel. Lets say i have Workbook1 and Workbook2 and i have opened them in different excel ...
0
votes
1answer
169 views

Excel: Find a specific cell and paste the value from a control cell into it

I have two columns one containing the room number, e.g. B-CL102, the other containing a varying integer. I want to enter a different, manually determined, integer in a third column. Whether by macro ...
1
vote
1answer
95 views

VBA + Polymorphism: Override worksheet functions from 3rd party

my company makes extensive use of a data provider using a (closed source) VBA plugin. In principal, every query follows follows a certain structure: Fill one cell with a formula, where arguments to ...
0
votes
1answer
86 views

Excel VBA Insert Character Between Number and Letter

I would like some VBA code that would allow me to detect if a string contains any instances of a number followed by a letter and then insert a new character between them. For example: User enters the ...