VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
4
votes
0answers
333 views
Late Binding Events
I can subscribe to Outlook events using the following in a Class Module where myOlApp uses early binding
'**Class Module - clsOutlookHandler **
Public WithEvents myOlApp As Outlook.Application
...
3
votes
0answers
112 views
New workbook created unintentionally
I'm trying to copy a worksheet ("ReceivingRecords") from the workbook ("InventoryControlSystemV1.1") and paste it in a new workbook ("RecordBook"). I have created a temporary workbook named "Temp.xls" ...
3
votes
0answers
205 views
Excel Error 406 when using both VBA and ActiveX addins.
My Excel addin (XLL AddIn, call it MyAddIn) is built with C#, ExcelDNA, NetOffice, VS2010. Client has another addin (let's call it B), I guess it is written in VBA.
Client says B works fine without ...
3
votes
0answers
564 views
Excel VSTO fails to load if there's VBA macros
I have an excel XLS developed with Visual Studio Tools For Office (VSTO) 2005. Most of the code is in C# VSTO, but there is also a VBA macro to implement a worksheet function. I'm not trying to have ...
2
votes
0answers
59 views
Excel macro not working after upgrading to Office 2013
My company uses excel to produce network configs that go out to all of our stores. the configs are pretty much same with the exception of a few variables that get inputted into a variable sheet in ...
2
votes
0answers
45 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 ...
2
votes
0answers
34 views
Replace() not working on image dimensions string from Shell
I'm trying to get the height of a bitmap by using the Shell object in VBA. Here is the relevant portion of code (bmp is a member of a custom class, and .Width is a property defined as an Integer.)
...
2
votes
0answers
45 views
VBA On.Time() Background Check in Combination with regular Usage
I am currently experiencing an Issue with the On.Time() Command.
The Ontime offsetvalue is set to 00:00:10 checking if Files are open. (Sort of a realtime checker).
Sub MacroAutoRun1()
Dim ...
2
votes
0answers
232 views
Duplicate values in pivot table filter list
I have a rather large filter table derived from a table containing thousands of entries. This uses calculated values for fault diagnosis and for assessing the system availability.
I am trying to ...
2
votes
0answers
181 views
Upload Excel xlsm file to php script using VBA
I would like to upload an Excel xlsm file to a php script from VBA. I found the following code:
Dim WinHttpReq As Object
Set WinHttpReq = CreateObject("WinHttp.WinHttpRequest.5.1")
Dim strURL As ...
2
votes
0answers
143 views
Excel 2013 Pivot table won't change current page until navigated to manually
We have a little piece of VBA code that worked perfectly for ages. It was essentially:
Me.PivotTables("APivot").PivotFields("AField").CurrentPage = "Some text"
This worked until Excel 2013, where ...
2
votes
0answers
463 views
Excel worksheet - if the column contains X then copy the row and all rows with the same word in column A to sheet 2
The current code copies content from sheet 1 to sheet 2 if X and from sheet 1 to sheet 3 if Y. I need it changed so that if a row in column B = X it copies every row that has the same word in Column ...
2
votes
0answers
135 views
How to find target value of two cells with two conditions with Excel
I'm trying to calculate a complete mineral formula from a partial chemical analysis in Excel with a macro. The measured amount of Silica influences the amount of Beryllium with the function:
...
2
votes
0answers
183 views
Look for a method of WorksheetFunction which returns an Integer
I consider TypeName function returns the exact type of a data in VBA. Now I am looking for a WorksheetFunction which can return an Integer, instead of Double.
A lot of WorksheetFunction returns ...
2
votes
0answers
260 views
How to release an vb.net class libary object from Excel VBA
as the performance of Excel VBA was to poor for my calculations, I migrated my code to a VB.net class libary which I add as a reference in Excel. I am using VBA for all my read and write function, but ...
