notification

Hello everyone, I'm hoping someone can help me with a bit of dilemma. I have a long list of cases that I am working on. I have to be reminded on which ones to chase everyday. I have used conditional formatting where certain cases are coloured which kind of helps, but as the list gets longer...

I'm trying to write a VBA CODE example mentioned below. Help on the below-mentioned example A B C D SL NO PRODUCT MANUFACTURING DATE EXPIRY DATE 1 ABC 01-01-2021 01-01-2022 2 XYZ 29-03-2021 29-03-2022 3 CDA 04-05-2019 04-05-2020 4 TWC 23-03-2021 23-03-2021 I want my output as...

Is it possible to have an email notification when one of my files is open by another user? I have used MsgBox and With Outmail code before but it was when someone ran my macro. I wasn't sure if it can be done with my file is opened. Thank you in advance.

Hi I have a table <colgroup><col><col></colgroup><tbody> Country Client Notification Date BRAZIL 31-May-19 CHILE 20-Aug-19 INDONESIA ISRAEL MALAYSIA 02-Sep-19 NEW ZEALAND PANAMA PERU PHILIPPINES SAUDI ARABIA SOUTH AFRICA TURKEY UAE (DUBAI)...

Hi All, Below is the code I use, currently facing the problem to declare the datatype of 'Data' as Binary-type for file upload. Sub ImportToDatabase() 'Import Data to SQL Server Dim conn As New ADODB.Connection Dim adoCmd As Object Dim iRowNo As Integer Dim Notification...

Hey All I need an excel formula does the following calculation: Notification Date Exit Date Cost July18 Aug18 Sept18 Oct18 Nov18 Dec18 Jan19 Feb19 Mar19 Apr19 01st Sept 18 31st March 100k 14.3k $14.k $14.k $14.k $14.k $14.k $14.k I need...

Hey All hope all is well, I'm hoping to get a little help with a notification when a date is near expire date. I have several columns of when employees training certificates expire, I would like excel to tell me in A:7 that the dates expire soon. some of the columns have blanks, I have this...

Hi There, I have a problem that I'm sure many folks have encountered. Our office utilizes a shared drive to access documents. It has its pros and cons, but we've recently run into a problem. There is a coworker who keeps forgetting to close an important excel document that is often used by...

Hi Need your assistance on this I have the following table and I am trying to - automatically send an email via Excel based on the Status (Column 5) to the Travel Asst. (Column 22, as 1st notification point) and Travel Manager (Column 23, as escalation) - in the escalation, copy the Travel...

Hi there, I have a personal macros in Excel which I use and I always get the below message when trying to open other workbooks if I have one open already. Is there a way to not have the notification pop-up? Thank you

I was wondering if anyone can help me with my message box notification. What I want the macro to do is to check the values in column H and if it has a value that is <= 60, then to have a message box pop up with a specific message. Then I want it to do the same thing for <= 30 with a different...

Hello all. I am working on a workbook where I have inventoried items at my work place. This workbook contains quite a few pages and also over a 100 items per page. The idea with this was to have someone update the inventory and then when they save the file, it sends an email to the person...

In previous versions of Excel, if I hold down the shift key whilst opening an excel workbook, macros are disabled. Alternatively, if the macro security setting is set to "Disable all macros without notification", macros will also be disabled. However, in the Excel 2106 64 bit version, I have...

Morning All, Within my department we use an excel based job register for employees to add engineering issues as they occur. Currently someone within my department has to sporadically check the register to see if any new jobs have been added and then assign them to an engineer and give it a...

Excel friends, I found the thread below to know if "Trust Access Visual Basic Project" is ticked. It works perfectly, but in addition to it, I also need to know if "disable all macros with notification" is ticked. The ideal will be to identify which one of the four is ticked. Is there any way...

Hi, Can someone help me, it is very odd just recently I stopped receiving notification if I want to save an excel file before closing when I tried to close an excel file. Usually I receive those so I will know if i saved the work I've done or not. Can someone help me how to bring it back?

I have a table with 2 columns. I would like to divide all the values in column B into new row based on the char(10) end of line. Sample table - before: <tbody> Product code Description 110/1 - manual operation - high voltage - yellow color - email notification 110/2 - automatic operation...

Need help for the below I am having the data in the excel with the columns as below 1. Event Name 2. Frequency of notification ( Daily or for specific days) 3. Dates from 1 to 31 ( in which date notification required I will fill that cell with "Y") 4. Time to be notified As per this data...

I can't find how to disable the notifications for the new Thanks / Quotes / Likes feature. Particularly the email notifications. I can live with the notification area in the web browser. But I don't want the emails.

Hi all, I work for a small manufacturing company, and I have been tasked with setting up a barcode system. I am not trying to setup an inventory management system, I do not need to keep track of any quantities (or at least as of right now). I could see the system wanting to be expanded into...