Forward outlook emails that are in shared inbox

I know there's many similar threads related to 'SendOnBehalfOf', but I can't seem to find an answer to my problem. I need to be able to forward emails, via macro, from a shared inbox (a workflow if you will). Let's call this Inbox "BS Work", with su...
more »

2017-08-17 22:08 (0) Answers

Code optimisation: Arrays vs collections

In terms of memory consumption/ execution time, what's a more expensive way of adding items to a group Redim Preserve myArray(1 To Ubound(myArray) + 1) myArray(Ubound(myArray)) = myVal Or myCollection.Add myVal Does the fastest one depend on my...
more »

2017-08-17 18:08 (1) Answers

Excel Macro for invoices

So there is this vendor that sends me spreadsheets every week for their invoices. In the name colum if it equals "BCR Plaza" i would want excel to automatically add another row below that, copy some of the data from the previous row and divide the to...
more »

2017-08-17 15:08 (1) Answers

Return array of objects from function - VBA

I need to "return" an Array of Objects from a function that I created using VBA. When I try to set the function as the array it gives me an error message, saying Object is required. I am not very used to VBA, and I can't fix this. Here is the ...
more »

2017-08-17 14:08 (1) Answers

Run-Time Error 13

Not having a great day on the programming front. I cannot see why VBA cannot do the following sum. Can you please assist. I have 2 fields in a userform both with a date. All I want is to subtract them to work out the days in between I have tried 2...
more »

2017-08-17 14:08 (2) Answers

Scan All Incoming Emails Outlook

I have the following code to do something on every email I receive via Outlook in the inbox with a specfic subject. It works but if multiple emails arrive at the same time (ie when Outlook re-queries the server my email address is based off of) it wi...
more »

2017-08-17 14:08 (1) Answers

Excel Form Combobox value to cell

I have an Excel VBA Form and ComboBox that has the 12 months of the year. What I want it to do is when I select a month, it should also write that month value in a specific cell in the workbook as that cell value is linked throughout the workbook. M...
more »

2017-08-17 13:08 (1) Answers

Logical statement with 2 textboxes

I've got a problem with my code when I am doing a logical statement with 2 textboxes. I just want to check before I close my userform if Textbox4's value is smaller then the absolute of textbox6's value. If Me.TextBox4.Value <= Abs(Me.TextBox6....
more »

2017-08-17 12:08 (3) Answers

VBA Compiles in Word 2016 but not Word 2010

One of the new features that MS have introduced to MS Word since Word 2010 is LayoutColumns FootnoteOptions. So the following line of code compiles in Word 2016: ActiveDocument.Range.FootnoteOptions.LayoutColumns but not in Word 2010 (I've not tes...
more »

2017-08-17 02:08 (3) Answers

Excel VBA- Runtime Error 1004 opening a workbook

Pretty new to vba, but I wrote a code that unmerges rows within a column, copies thus cells then pastes within a different macro workbook. The code ran well when I first ran it. However I attempted to use it today and I was shocked I had an error. Th...
more »

2017-08-16 21:08 (1) Answers

VBA html tag text query without inner tag

There's such html: <h1 class="title">NOW ZINC PICOLINATE 50MG 60caps CYNK PIKOLINIAN <small>(6826446676)</small> </h1> I want to get only this: "NOW ZINC PICOLINATE 50MG 60caps CYNK PIKOLINIAN" When I use: HTMLDoc.getEl...
more »

2017-08-16 18:08 (1) Answers

VBA-Macro efficiency with Bloomberg Data History

I'm very new to VBA. I wrote this code and it works, but it takes ages to run through and I get the feeling that its getting slower and slower the longer it has been running. Is there a way I can make things like this more efficient? Would be awesom...
more »

2017-08-16 11:08 (4) Answers

Find Variable Value + Symbol Combination

I have the following problem. I am reading unsorted text from a pdf into excel, filling my worksheet with rather random entries. No I am searching for elements which works quite well for most parts, I am just running into major problems finding a v...
more »

2017-08-16 10:08 (1) Answers

Listing e-mail in array by Outlook folders

I'm trying to prepare a VBA macro in order to gather daily a list of e-mails from each folder I have under my Inbox included e.g. folder from which the e-mails comes from, create time, subject etc. No matter is the e-mail already read or not. Could...
more »

2017-08-16 09:08 (0) Answers

Excel VBA for loop condition

I would like to ask about the for loop in VBA, I have the script below to remind ("remind" is a sub function) me if current date is CheckDate1,2,3,4,5,6... I would like to ask if I need to add more date, can I use a for loop to contain all the Check...
more »

2017-08-16 03:08 (1) Answers