msg

Hi, I have the code below that outputs the email count per day for a generic team inbox, in this example the inbox is named genericqueries. I am looking for a way to also count the emails in sub folders within this inbox. Also, this email address contains roughly 8000 emails and it takes an...

I have the following macro to determine if there are variances in col C I would like the code amended so that when message comes up "No variances "found" , macro to end, otherwise continue with macro Date_Message Date_Input Your assistance in this regard is most appreciated Sub...

Hi, I need help with the macro be used under outlook - and to get output in excel. This macro was working fine for almost a year, but starting from few days - I cannot run it - as I got a message: User defined type not defined. Do you know what can be the issue? Maybe someone modified it...

Hello, I am using the below code to close the database after 10 minutes of idle time. The issue I am having is that once the database closes after 10 minutes, I see a few pop up messages for my un-filled required fields and then I see an error message stating "Run-time error '-2147352567...

Dear community, I want to create a Macro to check everyday if a new new file has been added to a specific folder and notify me per email. I have seen some codes to check if a certain file given a specific name exists but none of them really answers my question. I came up with the following...

<colgroup><col></colgroup><tbody> There are files (pdf or msg) at folder "C:\Users": AAA-1 (pdf) AAA-2 (pdf) AAA-3 (msg) BBB-1 (pdf) BBB-2 (pdf) How to set the formula in excel to hyperlink to folder "C:\Users" showing files with word "AAA" only? </tbody> i.e. files AAA-1, AAA-2...

I'm having a problem with using a loop to assign cell values to an array variable. The values are only running for the first i and the msg box is only saying the first two instead of the four that it should find. Any help would be greatly appreciated. Type Plants Name As String...

Hello all, I have a problem with my VBA, maybe you can help me. Everything is working fine, but even if XXX!D13 =0, i still recieve an empty message with "ok" button. How can i change the vba, so that in case XXX!D13 is zero, not to have any message. This is my VBA: Dim msg AsString If...

I need to have a msg box pop up on my macro that asks "How Many Rows Would You Like To Insert?" Right now I only have this much: Sub InsertBlankRows() Application.ScreenUpdating = False numRows = InputBox("How many Rows") 'Inserting a Row at at Row 5 Range("A5").EntireRow.Insert...

I have a userform created and i am looking to make a textbox a required field if a checkbox is selected. if the textbox is not seslect before sunmitting then a msg box will apear. how can this be done?

Hi, I have inherited a nice excel sheet that captures any issues identified on our production site and assigns an owner who need to action the issue. The code is supposed to email the owner everytime the sheet is closed down. However this email function isnt working. i have absolutely no idea on...

Hello! I have a Table just like the one above. I want to count the number of cells in the column Leg since the last entry, given a certain classification on the column Type. For example, for the type KFT only, how many blank entries are there in the column Legendary since the last entry for Leg...

Hello Excel Community, I am stuck on the next part of a large code that splits my worksheet into various new sheets based on different variables. The next part of my code needs to do the following; Recognise duplicate Name in "A", i.e; Fred & Fred. Then, create a new worksheet based on a...

Hi, I'm fairly new to vba and have been trying to create a sub that when the workbook is saved it checks two different ranges. If either one is empty and the other has a value in it cancel save and display a msg. if both are empty or both have values continue with save. The workbook has a master...

to all, rather than writing a "complicated" formula in a cell, I am writing a function. I am trying to understand wha tis the best way of checking if a value as been specified for an input. I set up my test with IsMissing() but the input must be a Varian. I am working with Double In my test I...

I have written code to check if there is a value not equal to zero in Col D in the same row as where text "variance" appears in Col A I want the code to check if there is a variance (Value not equal to zero) in Col D on all sheets, except the last sheet The code runs, but does not display a...

Hello, The code below works but only after the warning pops up. I get a critical warning pop up that says "No Such Template". Can anyone see why the warning pops up first then actually does what the macro is supposed to do? <code> Sub OL() Dim objOL As Outlook.Application, msg As MailItem...

I have a text string stored in a cell that I need to show in a message box Text is in cell 'e34' on sheet 'Tables' I have also named cell 'e34' as 'TxT13' If i refer to the cell as 'e34' this code works Sub WITO() If Sheets("Tables").Range("Prmt13") = "True" Then msg =...

Hi everybody! After a while I'm still not into VBA, please, I need to check some range, if it's sum is greater then zero then run code normal, if it's equal zero then skip bunch of code to Exit Sub. Sub Macro1_OCISTI_PODATKE_SA_IZVJESTAJA() ' ' Macro1_OCISTI_PODATKE_SA_IZVJESTAJA Macro ' ' Dim...

Hello All Im trying to use VBA to give me a Message box. Theres data that self populates in Column A to F. then the user has to put data into Column G through K before closing the sheet. A lot of times the user will leave out the data in Column K before closing it and column K is important for...