VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
8 views
Comment vba code from another VBA CODE
I would like to comment the lines who contains Msg Box from another code VBA. I'm trying this with the Library VBA EXTENSIBILITY but i doesn't found the solution.
Any help is welcome.
0
votes
1answer
6 views
Activate a Macro each time I use a Validation List in Excel
I have a Validation List that selects different countries. Each country has different sellers and I have to make a Validation list for them too. The problem is that I have to run a macro manually ...
0
votes
0answers
8 views
edit the program to sumif with visible cells in MS excel
i got some countifv thats counts visible and sumifsv which sum visible cells only ... i want sumif only visible using vba
Default Using SUMIFS on visible lines only
I have a large table, lots of ...
0
votes
1answer
18 views
Excel VBA - Work with Subgroup of Array
I have a 1-dimensional array with 1000 entries. I would like to loop through parts of this array and apply calculate an average on that subgroup. What I have done so far looks like this:
Temp ...
0
votes
0answers
11 views
.send is randomly not working
I am crawling some informations out of the web with this function but sometimes it says "access denied". But WHY? I dont get it :(
Function getPage(URLStr As String) As MSHTML.HTMLDocument
Dim ...
0
votes
1answer
13 views
Calling a WCF function (with parameters by reference) from VBA code in Excel
I have developed a WCF service which is successfully working. Then I have some VBA code in Excel that I wrote following this guide - http://damianblog.com/2009/07/05/excel-wcf/
It is working, I have ...
0
votes
1answer
21 views
extract multiple xml nodes into array without looping
I have a xml doc that looks like this:
<rng1>
<col1>
<row1>A</row1>
<row2>B</row2>
<row3>C</row3>
<row4>D</row4>
...
2
votes
1answer
15 views
Unable to get the Sumif property of the worksheetfunction Class
Can anyone explain what I could do to fix this?
Here's the current code:
SumFinalUnusedSPQCement = WorksheetFunction.Sum(Application.WorksheetFunction.SumIf(Range("V4:V" & lastRow + 3), ...
1
vote
2answers
46 views
Excel - VBA : loop as long as content of a cell equals specific value
I am trying to modify my code to allow more factors to be taken into account when running a loop. Here is what I have so far, it's a loop running for i = 2 to 605 (because between 2 and 605, my G ...
0
votes
1answer
18 views
Is there a way to call nonstandard shapes in VBA; using application.caller does not work
I want to assign a macro to shapes in my workbook where the macro assigns a relative hyperlink to the shape that called it. I tried using application.caller to get the name of the shape to assign the ...
0
votes
0answers
31 views
vba excel - Copying multiple cells including formatting/shapes/merged formatting
I can't seem to find anything on this in the forums or using google, so I'm not too sure if this is doable at all or if I'm just not looking in the right area:
I have 2 equal sets of areas (ie. 10x5 ...
2
votes
0answers
19 views
Excel ActiveX Listbox not enabled on file open
I am trying to figure out a bizarre situation.
I have a workbook with many sheets. On one sheet, I have one ActiveX listbox (CTOverview.Listbox1). On a second sheet, I have a total of three ...
1
vote
1answer
29 views
Group, count, and copy by multiple field values in excel programatically
Hi I have a spreadsheet that I need to count and group based on multiple values. Using the example below I need it to count a row only if Shipper - Shipper city, Recipient, and Recipient city are all ...
0
votes
0answers
11 views
Reserved file ignores macro supplied password
I have a macro that opens and updates links from protected files. Problem is one of the files still asks for the password to open instead of using the password in the macro that's opening it. Even ...
0
votes
1answer
63 views
Nested If / Then VB Statements in MS Excel
I have worked with several individuals over a whole week who have some VB experience, but we can not get all of these If / Then statements to work correctly. All work with the exception of the ...
