VBA: interpeting English date format as string

I have a spreadsheet containing dates in English format: 12 Feb 2015 13 Oct 2016 etc. However, since my MS Excel is in French, it doesn't take them as dates but rather as strings. I need to do some parsing with those values, so I run my procedu...
more »

2017-04-24 12:04 (1) Answers

Vlookup table error

I am trying to loop the value for column E so that I can use it to VLookup on another worksheet and return the value to column F. It has been giving me the error of Application-defined or object-defined error on the line: result = Applica...
more »

2017-04-24 08:04 (1) Answers

MS Office - ActiveX Buttons switching places

There are several instances of this problem, but this one is predominant. This is in relation to updates (our most notable problem child being KB2726958). We have a Leave Spreadsheet that looks like this: Leave Spreadsheet example By pressing the...
more »

2017-04-24 00:04 (1) Answers

Excel VBA: FindNext in nested loops

I am trying to create a loop using the .Find function within another loop which is already using .Find. I want to search for strings that I have saved in an array. For example, these are the string values saved in the array strItem in Sheet1. "uni...
more »

2017-04-24 00:04 (1) Answers

VBA Excel Comparing Values in two different sheet

I am looking to compare the values in two columns that are located in different sheets. When a match is found I want to decrease the value in a third column that is in the same row as the matched values. I know how to hard code it below but I would r...
more »

2017-04-23 23:04 (1) Answers

Excel Email the range this button copies

I have a form that has 2 buttons (Update & Ad) (the code under here is from one of them). If you fill out the form and press one of them, a record in an other sheet gets made or updated. I would like to have a email function embedded in them so ...
more »

2017-04-23 21:04 (1) Answers

how to save a sheet in VBA

I'm building a form that when you fill it up, it should generate 2 files as output. In order to do that I have 2 sheets in the background that I fill up depending on what the user entered a button to save them (as csv). This is the code for saving ...
more »

2017-04-23 10:04 (1) Answers

AS400 and System I Navigator

I'm new into AS400 and I got a job where I'm using AS400 and Powerlink (XA) to access and manage big ERP data. And I found a way to access the data through Excel VBA and SQL using the System I Nagivator tables. My problem is that I can't find the c...
more »

2017-04-22 21:04 (1) Answers

Apply Formula To All Used Range

I am getting a Type mismatch error whenever I try to run this syntax. Essentially all I want to do is apply the formula to column A of the entire used range. What should I change so this executes as desired? Dim wSheet As Worksheet: Set wSh...
more »

2017-04-22 21:04 (1) Answers

Excel macro apply a formula but don't evaluate it

I want to use my macro to apply a simple formula to every row of my sheet at column R, evaluating the corresponging cell in column C The formula is simply: =YEAR(C2) when C2 will be updated into C3, C4... in the correct row. The line in the macro ...
more »

2017-04-22 18:04 (1) Answers

VBA Macro to delete rows to a default table size

I have a macro that will add lines as the second to bottom row of a table gets filled up but i want to add a second macro to resize the table to 12 rows and 11 columns when the table is over 12 rows and there is no data in the additional rows. Here...
more »

2017-04-22 02:04 (1) Answers