VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
3answers
14 views
Renaming Sheets in Macro without renaming first four sheets
I know how to make marcos but during school he never taught me everything to do with them, mainly with the Dim.
My questions is how to I make a marco that will rename all my sheets expect for the ...
0
votes
0answers
12 views
Getting binary data of image in Excel and connecting to a PHP API?
Is it possible to get Excel connect to a Web-based PHP API? We've got an Excel program where users are using it to fill out data and we can work out how to get a browse dialog up so users can select ...
0
votes
2answers
28 views
Change Date format in Excel VBA
I have the Date in the log file. The Date in the log file looks something like this :
Mon May 14 21:31:00 EDT 2012
I would like to convert this into the format "dd-MM-yyyy hh:mm:ss"
Dim ...
1
vote
1answer
16 views
Excel VBA to connect to MySQL on linux server
I am trying to connect to MySQL database using VBA from my local machine. The database is in the linux server(XXXX.xxx.edu). I have the SSH client in my machine through which I connect to the ...
0
votes
1answer
32 views
Creating a Loop in VBA Macro for Excel?
I was lucky enough to get a response from someone on a previous question I have asked. See here.
Only thing I am struggling with is creating a loop that will end the macro upon reaching a blank cell ...
1
vote
1answer
28 views
How do I create an Excel sheet that shows selected rows in another sheet?
I have an Excel workbook with a sheet looking something like this:
Apple | 15 | Bob
Banana | 20 | Tim
Apple | 19 | Mary
Banana | 25 | Kate
I want to ...
-1
votes
0answers
28 views
Few queries on advanced capabilities of Excel +VBA
I have recently started using Excel and am using VBA quite extensively. I am interested to know whether Excel + VBA has the capability to do the task that I have listed down below. If it does any of ...
0
votes
2answers
33 views
Nested IF statement returns #VALUE
I have a pre-recorded macro that needs to be modified. It uses an IF statement to check if the value is N/A and changes it to 0, unless it begins with CN, then it sets the cell to the CN* value. I ...
2
votes
3answers
48 views
Strange behavior of range when used as key in dictionary
I have the following code:
Dim dicMyHash As Dictionary
Dim rngMyRange As Range
' A1 is empty - although the outcome is the same in any case
Set rngMyRange = Range("A1")
Set dicMyHash = New ...
0
votes
2answers
39 views
Excel- finding min value of multiple items
Column A represents serial numbers of different parts, but these parts come from different suppliers so they have different prices. Column B holds the price for each part.
I need a macro that will ...
0
votes
0answers
19 views
Macro to Cut and Paste Rows based on Selected Drop Down input from one worksheet to another
Read through related type posts...and I'm just an idiot I guess. VBA not a first/second/third langauge for me. Have Worksheet DASHBOARD with Staff Assignments on it. Row 1 is headers, and data ...
1
vote
0answers
31 views
Code Coverage of VBA Code
is there a tools or an approach to perform a statistical analysis (Code Coverage) of VBA code?
I like to answers questions like: How many per cent of the code covered by a test macro.
Thanks for ...
0
votes
1answer
20 views
Excel vba search in column, select whole column
I am new in here. can anyone help me please?
Here is my sheet: In column A&B I have Apple, in column C&D I have Samsung, in column E&F HTC.
I would like to search the columns which ...
0
votes
1answer
21 views
Creating registers from excel members database, if member is classed as 'current'
I'm new here so I apologise if this question has been answered before, but I did have a good search before I posted. This is half a database design question, and half an excel function / macro ...
1
vote
1answer
23 views
Excel VBA only show labels for each series' max value
I am trying to create a macro which loops through series in a chart and only shows the maximum / minimum label dependent on what the max / min value is.
Some of the series will only have negative ...
