notification

  1. G

    VBA Email notification

    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.
  2. M

    Index Match Error

    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)...
  3. Z

    VBA Create Table Column of SQL Server for Binary-type Data

    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...
  4. R

    Please Help :)

    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...
  5. B

    Expire date notification multiple columns with blanks.

    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...
  6. J

    Need a Notification/Alarm when a file is left open for too long

    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...
  7. R

    Emails from Excel (via VBA)

    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...
  8. F

    Personal Macro disable notification

    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
  9. M

    Message Box Notification when cells in Column have a specific value

    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...
  10. T

    VBA code to send email notification.

    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...
  11. T

    Disabling macros in Excel 2016

    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...
  12. J

    VBA - Email notification when job added to list.

    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...
  13. A

    How to know if "disable all macros with notification" is ticked?

    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...
  14. A

    No Notification if you want to save before closing an excel file

    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?
  15. P

    Devide cell values based on new line

    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...
  16. D

    Macro For Reminder Notification in Outlook From Excel Data

    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...
  17. Jonmo1

    Disable email notifications for new Post Thanks/Quotes/Likes feature

    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.
  18. N

    Barcode Notification System

    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...
  19. B

    Help Required - Upcoming Courier notifications

    Hi all, I was wondering if anyone on the forum can help me with a pet project? Im looking to create a spreadsheet with courier delivery times, and have a pop up notification when a courier is due. I can visualise how it will look, with 2 columns of delivery time, and courier name/delivery...
  20. M

    Please wait, your macro is running.

    Hi, After reading a lot on Internet, I'm asking for help. I've a macro which takes around 3-4 mins to complete. I want to show user a notification while that macro is running that "macro is running" and automatically disappear the notification once macro is completed. I've already checked...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top