VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
11 views
Excel list, 2000 rows to 250 page templates
Unfortunately i am not a master of excel. I have 2000 rows of information that i must fill out manually. Then i use vlookup to sort them into sheets with a template that can be printed out. My problem ...
0
votes
0answers
8 views
Copy a column of formulas to a closed workbook in Excel
I have a lot of data into Excel files.
There are about 174 files. Each is named Book2.xslx through Book174.xlsx
I have a master document where I have a column of formulas that I would like to paste ...
0
votes
1answer
26 views
Generating list of dates
Let's say I have a start date in Cell A1 and an end date in Cell A2. How would I go about generating a list of dates that start at A1 and then skips 2 weeks (not 14 days, but 2 actual weeks). However, ...
1
vote
0answers
27 views
Excel for Mac 2011 - Run-time error '-2147483640 (80000008)'
I'm new here so appreciate all the help you can give me and apologies if my question doesn't conform to an adequate standard.
I have been experiencing some unusual behavior while using MS Excel for ...
0
votes
1answer
25 views
How to do SUMIFS text match with multiple criteria from another column?
I wish to categorize my transactions in a way where I can alter the categories on the fly. I think it's easier explained by showing what I have.
I have the following tables
Transactions
A: Date
C: ...
0
votes
1answer
27 views
Is there any way to select a cell by clicking the object above it?
I have a protected sheet with many objects over it. Is there any way I can select a cell by clicking the object directly above it? In other words, a way to click "through" the object onto the cell ...
0
votes
1answer
31 views
Writing a vbscript to read data in a table and output total hours
I am working with a table like below, where there are projects that are broken down into tasks, and one task may appear more than once. I am aiming to get the sum of all hours of the same task, so for ...
-2
votes
0answers
35 views
How I can check if a folder exist, create a new one and subfolder if not, and after copy a folder template to this new sub directory created [closed]
Is it possible to do something to make these steps?
It can be a bat file, Java or even Excel.
User enters NIF (Number Financial) customer and the program will check if the file that is in the path: ...
0
votes
1answer
30 views
compare huge text files using vba
I gotta serious problem here.. any kind of help is much appreciated!!
I have two huge text files (130 MB)each with thousands of records in each. I need to compare the two files using vba or by any ...
0
votes
1answer
39 views
Extract All Excel Function Types From A String using Regex in VB
How can i extract excel functions (only their names) from a string in visual basic?
For example i have: Sin(B6)*Sum(A2:A4) So i want to find a way to have "Sin" and "Sum" from this.
Note: I already ...
0
votes
1answer
34 views
How to select the characters part of string in Visual basic
I have some string variables with combinations od numberas and character. like this:
A12452
BCD23
ESK56003
i want to get the characters from those strings. using vbscript. so i should get these ...
0
votes
1answer
21 views
VBA Excel SQL querry with date parameters linked to cell values
I'm trying to pull data into excel from a SQL database with date parameters. The following VB querry works. Instead of manually changing the date values in the TS of the VB querry, I want to have ...
0
votes
2answers
19 views
How to remove all the date formating in excel VBA?
I have the following code. However, what I found in the cell is that the output (i.e. SEP08) is converted to Sep-08 in the cell. How may i just display SEP08 as it is in the excel spreadsheet without ...
0
votes
1answer
20 views
multiple use of substitute function but it should combine the results in one column and cell
please check the picture link to understand the query **
I want to combine the multiple raw into one text string , I can use substitute function to change one word in a text string but how can i use ...
0
votes
2answers
24 views
Copying cell data from one worksheet to another
I have attempted to create an Excel VBA function that will copy the data in cells from worksheet 1 and paste them into worksheet 2. Ideally, I'm checking cells AF6, AF7... all the way to whatever the ...
