VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
10 views
macro which sum values based on conditions
I have two sheets in my workbook. First sheet contains the following columns
1. Client Name
2. Date (eg: 05/01/2013, displayed as May – 13)
3. Total
Second sheet contains the data which I will ...
0
votes
2answers
24 views
search strings in cell
I have multiple values in cell A1 which are separated by a ';'. Some of the same values may be in cell B1. I need to search the values in cell A1 using those in cell B1. All the values that are not ...
0
votes
0answers
7 views
remove last values in column if they are identical
As I am not familiar with Excel VBA, this might be a standard question though I did not find a similar question.
I have a large number of columns K which are either empty or they end at the same row ...
1
vote
1answer
15 views
When running a macro on multiple workbooks in a folder, the effect is only applied to the workbook containing the macro
I'm trying to run a macro that corrects a linked cell designation with checkboxes within a set of workbooks.
There are many (around 100) workbooks that need adjusting in one file.
As such I am ...
2
votes
1answer
8 views
Excel VBA Range(Cell).Value=sum 1004:Application-Defined Or Object-Defined
Function ChangeColVal(ByVal Rng As Range, ByVal ValueToChange As Integer)
Dim Cell1, Cell2 As String
Dim PosOfColon, TotalCell, Sum As Integer
PosOfColon = InStr(1, Rng.Address, ":")
...
0
votes
1answer
25 views
Intigrating ASP.NET Page With MS Excel as DB
I want to create a ASP.NET application which will fetch and store data from excel. For eg. curently i have automated excel reports using VBA and Macros, and user have to oem all the excels to get the ...
1
vote
1answer
19 views
Copy Multiple Column data between workbooks using Column headers as Selection criteria
Lets say i have to workbooks wb1,wb2. I Am trying to copy data from wb2 to wb1 using the column headers.
In wb2 col A contains id this has to be copied to column A, and so on for different columns.Now ...
2
votes
1answer
25 views
Need assistance with excel macro- vba
have a set of SUMIF formulas that I need to adjust frequently & the only thing I need to adjust is the 3rd part of it. The 3rd part, or sum range, columns need to be shifted over to the right by 1 ...
0
votes
1answer
22 views
Running macro (to assign linked cells to all checkboxes on given sheets) on all files in a folder
I am trying to reassign all the linked cells for checkboxes on three given worksheets in a large collection of workbooks.
The macro I have works successfully on any book I have open:
Sub ...
1
vote
1answer
8 views
Excel 2nd window ignores mouse click on activeX image control
I have a large worksheet where I need to have two windows open to see distant parts. Split screen is not sufficient.
The worksheet contains hundreds of images (activeX controls), each of which runs ...
-1
votes
0answers
20 views
Create a VBA Macro which will extract specific tables and html tags from website
I would like to know if somebody can help me how can a macros be writen, that macros will do the following action: Creat a new sheet with a specific name, in which sheet it will import a specific data ...
0
votes
1answer
24 views
Compare Values in VBA
i need some help with the following problem:
I need to compare the values in 2 Excel columns and if in case of a match copy this value in a third column.
Example:
Column A - 500 values
Column B - ...
1
vote
0answers
25 views
Excel macro to create new sheet every n-rows
I'm attempting to write a macro to take an excel file of several thousand rows and split the inital sheet's rows up into sheets of 250 rows per-sheet, not including the original header row, which ...
0
votes
1answer
21 views
Copy Entire Worksheet to Another Worksheet
I have an excel workbook that currently has a macro built into it that when pressing the macro's button, the current workbook is saved to a directory that the macro creates and the template is then ...
0
votes
0answers
33 views
VBA return Array from a function producing error on function call - only user defined types
OK, I'm well and truly stumped now, so hope someone out there can help.
I have a function which collects data from various record sets, collates the data into a custom data type, then stores ...
