VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
4
votes
0answers
43 views
SAP: SAPGUI Parse GuiUserArea
Problem!
Currently at the place that I work We are trying to perform some kind of repetitive task via automatically with the usage of SAPGui, Excel & VBA. Usually, the most of the reports that ...
4
votes
0answers
360 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
...
4
votes
0answers
214 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
135 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
344 views
How to adjust for differences between 32 and 64 bit Excel VBA date handling?
Problem:
64 bit Excel VBA has a nasty habit of converting array dates to numbers when that array is assigned to a range. 32 bit VBA, on the other hand, preserves the date format.
Example:
Here's a ...
3
votes
0answers
594 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
51 views
How do I run an Excel macro for when a cell is changed but the data has not been entered yet?
Here's the problem: I have a laser scanner that reads barcodes and regurgitates a value upon a successful reading. When this happens, the serial number (a ~20-digit number) is pasted into the active ...
2
votes
0answers
71 views
Excel for Mac 2011 - Run-time error '-2147483640 (80000008)'
I'm new here so appreciate all the help you can give me and apologies if my question doesn't conform to an adequate standard.
I have been experiencing some unusual behavior while using MS Excel for ...
2
votes
0answers
157 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
87 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
46 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
68 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
326 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
250 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
217 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 ...
