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 ...
0
votes
0answers
11 views
Technical limitations of a data-extracting VBA macro
Everyone !
it is my first post here and as a novice I hope my question will make sense.
I'm a french intern working for a large firm and was assigned to the making of an "automated report" (I know, ...
0
votes
0answers
15 views
Specific Range in VBA Excel
I have created a pivot table in excel with vba. Now I have to group some different rows.
For Example A1, A6, A19 ...
The information which rows should be grouped are on an own Worksheet where I read ...
0
votes
0answers
8 views
Excel VBA Setting Cell Colour based on range of individual cells
After much messing about and trying to sort this out I am at a loss. I have a C# interop that returns a CSV list of cell addresses. This part works without a problem. I have a method that sets the ...
0
votes
3answers
16 views
How do I get the index in a VBA For Each Loop (programming with Excel)?
I am working with EXCEL VBA to process some data and here is what I want to make:
In this sheet, I want to create a function "GetDebutDate" that can automatically calculate the first date that the ...
0
votes
0answers
7 views
VBA Post file and additional parameters
I use Excel-VBA to automate a login and some clicks in IE.
But when I come to a point where I hava to Upload a file through an field, I don't know how to do this.
I had a look at this site: ...
0
votes
3answers
16 views
VBA if statement to be shortened
how can i shorten my if statement? is there any other way to shorten it??
F = Strt
E = Strt + A1
I = Strt + A1 + A2
A = Strt + A2 + A1 + A3
b = Strt + A2 + A1 + A3 + A4
c = Strt + A1 + A2 + A3 + A4 + ...
0
votes
1answer
41 views
Convert YYYYMMDD to Excel dd/mm/yy
In this post Gert Grenander makes a suggestion to format the date field to 'yyyy-mm-dd hh:mm:ss'.
How would I convert from 'YYYYMMDD' to 'dd/mm/yy' in my SQL call using the same method?
0
votes
0answers
23 views
Need urgent help displaying records one at a time using animation
Hey programming gurus out there,
I'm currently working on a project to display records in an animation whereby records will move up. Right now I'm facing problem to allow the records to move up one ...
1
vote
0answers
15 views
How to get value of a Yes/No checkbox control when passed to another class?
I have a form TForm based on table T. There is a Yes/No field Choice in T. To add this field to TForm, I added a checkbox ChoiceCheck to the form. I am trying to get ChoiceCheck's value in another ...
-1
votes
0answers
26 views
Removing rows from a table in Excel VBA
I'm trying to something simple - delete a row from a table in excel using vba, and shift the contents up. The only reason I am reposting this is that it seems like all solutions already posted deal ...
1
vote
1answer
19 views
VBA USERFORM: PREVENT COMBOBOX ESCAPE ON KEYDOWN
Community,
There is a way to prevent an active combobox from losing its focus when hitting the down arrow (or up arrow) when at the end (or start) of a list. If there is a better way to do this ...
0
votes
0answers
23 views
Alternates between Error 1004 “method range of object failed” and Error 13 “Type mismatch”
I'm a VB newbie and was hoping someone could help me. I spent an hour reading related questions in the forum, but still have not been able to solve my issue.
I have a list of MRI facilities on one ...
0
votes
0answers
19 views
Macro runs perfectly in excel but error message when called in powershell
I have written a macro that calls three other macros inside of it in order to use a public variable in the 3 macros . The macro runs perfectly from excel but when I try and call the macro in power ...
1
vote
4answers
31 views
Excel VBA on Range Error - Quick Fix?
The below code gives an error but when I change the range to .Range(A2:A9999) it works...
But it's ugly. Is there way to grab all the data in column(A) from A2 and down? and copy that into B2?
...
1
vote
1answer
19 views
VBA - Method 'delete' of worksheet failing
I made a VBA program and now that everything is done I need to clean my workbook completely to run the program several times. For this I am using this code:
Sub deleteWorksheets()
Dim ws As Worksheet
...
