VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
-2
votes
0answers
30 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
25 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
35 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
31 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
20 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
1answer
15 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
23 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 ...
0
votes
0answers
19 views
Restrict the data in powerpivot for excel 2010 based on the user who is using excel file
I wanted to create a powerpivot report. In which i wanted to show only the data the user authorized to view based on his windows credentials.
For example consider the following table
ID Code ...
1
vote
1answer
27 views
Copy and Paste Issue
This code works two or three times, and then I get a "PasteSpecial method of Range class failed" error. I know I get that error when nothing is copied, but considering it's copied right above, I don't ...
-6
votes
0answers
32 views
Rationalization Model in Excel [closed]
Hey guys I have to make a Retailer Rationalization model where the algorithm will be something like this
A Form which will have certain parameters like Volume/Spokes etc. Data will be entered into ...
8
votes
1answer
49 views
Why doesn't Option Explicit catch ReDim <undeclared>?
Does anyone know why this doesn't throw a Variable not defined error when I compile it?
'Class1.cls'
Option Explicit
Public Sub foo()
ReDim fubar(1 To 2, 1 To 1)
End Sub
Am I misunderstanding ...
1
vote
2answers
59 views
For Each loop not going through all the data
I have a simple macro that goes through a series of sheets, gathering names based on a data inputted, then puts it all in a nicely formatted Word document. I have most of it figured out, but one bug ...
0
votes
0answers
44 views
VBA How can I make a code to create tables from a set of data
I have a worksheet which comes in every week with the same format that I need to summarise information for, for a number of Business units. The format is as follows:
The worksheet is populated from ...
0
votes
3answers
38 views
How to make match() work with date in excel vba?
I'm having problem making the match() work in excel VBA. The code is:
x = Application.Match("Sep 2008", Range("F1:F1"), 0)
The value in cell F1 is 9/1/2008.
Even if I changed Sep 2008 to 9/1/2008, ...
