Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
Articles & Videos
Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.
Need VBA to do the below calculations. The range however can be 100s of columns and 100s of row.
So, I need to be able to loop through.
(A$1*A3) (B$1*B3) (C$1*C3) etc.
I was wondering if its possible to do multiple count if statements in VBA?
I currently have data in four columns
Column A (Name) will only ever contain two users in this scenario …
Could anyone explain firstly why this code is causing excel to crash ? is it simple because the computer is so old.
Dim sws As Worksheet, dws As Worksheet
Dim lr As Long
I need to lookup the values of Range C2:C5, then return values of Range A8:D8, for each instance. I have hundreds of columns, and rows. The rows and columns will change from file to f…
Access 2013, desktop
A query called queryname returns the value of the field Cri6Comment among others.
When I run the query by itself - it returns the full length of Cri6Comment - so far so goo…
Hello there Experts Exchange users and helpers. Would appreciate any help for the following functions.
Have the left number set as a countdown on days that are passing by.
For example the day t…
I had this question after viewing disregard leading zero in query (https://www.experts-excha
Access 2010 vba
I have 2 tables:
We just finished restoring an Outlook 2010 PST into a fresh Ms Outlook 2010 install. Unfortunately it seems that the VBA scripts that has been developed didn't restored. We have always backed up the…
I copies this code from another thread by Bill Prew (https://www.experts-excha
I'm trying to automate a file download that saves with previous working day
Public Sub saveAttachtoDisk(itm As Outlook.MailItem)
Dim objAtt As Outlook.Attachment
Dim saveFolder As…
I am doing a filter to find all of the items with ‘Credit’ then I want to delete these items. The below works fine when there are items in there with ‘Credit in column I. However if there are no items…
Can any one tell me why this code is not working. I want it to search my spreadsheet and display the data from select rows if the correct number is entered into the search field. Basically a basic sea…
I used the following procedure in order to export and split data into csv files based on specific column reported in the procedure:
I would like to use the procedure a…
I want to add a couple more fields to my macro below. Currently the Macro tests if there is any matches in a search field to the [PLU] field and filters the found set accordingly. I want to add 4 m…
This might be a VERY broad question but will aid me in the right direction. After a customer orders there will be a picking list generated for the picker to collect the items on the list.
I am trying to create a macro that saves down a file to a folder with the corresponding month and year.
i.e. S:2016\10-Oct 2016
If the folder doesn't exist I then want the macro to create one. …
There is a ActiveProjects sheet with hundreds of projects.
I've attached Final Result and Source files (samples with small sample data).
I'm building the Excel VBA app that will do these steps:
I currently have a button that opens a form using an embedded macro.
I have two forms nearly identical one called frmStudent and frmStudentShort. The 'short' version is a continuou…
When I do this I should get AutoFilters on columns 1 and 3. But I get 2 and 4 (see image).
Tried to fudge it with Field:=0 I get an error.
According to here (http://datapigtechnologie
I'm trying to get a Sparkline like in the attached image.
The Sparklines options don't seem to have horizontal bars. It should be possible then with Conditional Formatting? If so, how?
Hi all. I have excel 2013, where I'm using PowerQuery to get data from a forum DB, and later count the number of words for each user and for each month, with pivot tables.
The problem is that I get…
I have a load of embedded charts in a PPT presentation
My code opens the embedded chart and pastes in some new data, then closes the embedded chart.
I have 100's of these charts. I am no…
I have the following config sheet.
I am looking for a procedure in order to fill values dynamically based on a reported values in a config sheet.
Here is a fields descriptio…
Wondering if you all could help me with this expression:
The following expression is in the control source of txtPercentPos:
but when I display the continuous form I get:…
The code described here does no longer work. Please see replacement Article: http://www.experts-exchang
This Article is a replacement of http:/A_1788-Getting-your-