Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the entire Office suite. If your question is specifically about programming Excel, Access, Word or Outlook, use the appropriate tag: excel-vba, access-vba, word-vba or ...
-1
votes
0answers
5 views
Display a non contiguous range in 3 userform listboxes
I have a range called "Departments" (A1:H10) and a userform with 3 listboxes
I need to display columns A, C and H in listboxes 1,2 and 3 respectively when the userform loads
Also I want when I ...
0
votes
0answers
3 views
Access 2003 - VBA - Joining on two types (string = date)
Background: Im busy with a research, in which I receive data stored in a oracle database. I myself use an Access database to store the data from the oracle database (and as well data from other ...
0
votes
0answers
9 views
How to add new object to existing Collection
I have two questions.
I would like to add an object in a new sub to an existing collection which is made in underlying sub. So in an other sub I would like to add objects to this collection.
I ...
1
vote
0answers
7 views
How can I create a macro that find, select and cut columns, and paste them in another worksheet?
Another day, another problem. I think it is easy to make this thing work, but I just don't know how to go further now.
The issue:
On work we get excel sheets from our customers. In this sheet, they ...
-3
votes
0answers
10 views
VBA code to read in the last line from multiple text files in a directory?
I have 155 text files in a directory; is there an Excel VBA solution to loop through the directory, open each file and write the last line only to a worksheet?
Thanks for reading.
0
votes
1answer
8 views
Equivalent cURL in VBA?
I have an API for my application which allows me to make cURL requests to it.
I need to implement this into VBA so my desktop database can fire CURL requests to my web app.
curl -i --user ...
0
votes
0answers
5 views
VBA to import comments into a PDF
I need to a way to import comments into a PDF document. At the moment I have the comments I need in an Excel spreadsheet so it would be great if I can pull them from there.
If there is another way ...
1
vote
3answers
22 views
VBA Excel Extract Values Between Quotes and Put Into Array
I am generating an array like so:
Dim arTest(1 To 6) As Variant
arTest(1) = "0"
arTest(2) = "1"
arTest(3) = "2"
arTest(4) = "3"
arTest(5) = "4"
arTest(6) = "5"
ActiveWorkbook.Names.Add ...
0
votes
3answers
26 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
9 views
Sort by Two Levels Using Counter to Determine Range
I am trying to sort a table in vba (in the middle of a larger macro) by two levels. I tried recording the macro doing exactly what I wanted but the range was specific to that series of data. The end ...
1
vote
0answers
7 views
Need to modify code such that it extracts data from range, then offsets and repeats the extraction until blank is found
I'm still learning the gory details of VBA so you'll have to excuse me if this is simple!
Basically the code below looks up a list of cell references in a separate worksheet, and brings the data ...
0
votes
0answers
4 views
everytime do autofilter with different value in vba command
In one workbook i have two sheet, the 1st sheet contain the raw data and 2nd sheet contain some value. i want that do autofilter by using vba command so that the highlighted cell in sheet2 will search ...
2
votes
1answer
15 views
excel 2010 vba mssql help : can not get table headers (alias)
Below is my code and it is working properly, but I have a small problem.
I have two different sheets: in the first sheet, there is a button to get the data. This is working, I can see the data in the ...
0
votes
1answer
16 views
Display a non contiguous range of cells to a list box
I'm trying to display a non contiguous range of cells in a table called "Departments" (A1:A10,C1:C10,E1:E10) to a multicolumn Listbox.
I found an example here, but it only displays the first row of ...
-1
votes
0answers
15 views
Find and Replace Function Macro Powerpoint VBA
Sub test()
Call ReplacePPT("[REPLACE]", "Anne")
End Sub
Sub ReplacePPT(strfindMe As String, strswapme As String)
Dim otemp As TextRange
Dim otext As TextRange
Dim inewstart As Integer
For Each ...
