message

I have a Powershell script that pulls all of the Outlook Email Rules in our Office 365 Domain. I would like to output it to JSON as CSV drops columns. I have the export working fine but cannot seem to get the data to load into Excel. I have followed several videos on how to go to Data --> Get...

If I want an error message such as "On error Goto Help" and then later "Help:" I would just do that. however, Excel is making me dim "help". How would I do that? As a string works but isn't right I don't think.

Hello everyone, I'm trying to convert all worksheets of the excel file into individual PDF and automatically attach to individual email (outlook) message each one of them. So far I was able to rename each worksheet (as per a certain cell) and save as individual PDF, but I still can't figure...

Hello, I need your help please, i am looking for a vba code to parse following aviation weather message and compare some contents instead of doing it manually: weather criteria 251544Z 2518/2624 23015KT 9999 SCT020 TN18/2608Z TX26/2617Z BECMG 2522/2524 29007KT BECMG 2606/2608 35005KT 7000...

Hello, I'm getting a self generated Microsoft Excel popup message: Is there any way to suppress this self generated Microsoft Excel pop-up message? Please let me know. Thank you! Pinaceous

I want a message to pop up if the value on any cell in of a range of cells is equal to 'False" at the moment I only can run it if one cell is equal to false. but I want to add the condition so it includes if any cell in a range (A:1 to A:10) is equal to 'false' Private Sub...

I have a macro to display a message box I need to show each message in a seperate cell , but all the message displays on one cell it would to show each message on a separate cell on sheet 'Macro" It would be appreciated if someone could amend my code Sub Variance_Message() Dim ws As...

Hi I want to fill blank cells with 0. The code below gave me error message complaining that rows.count overflow. I changed it to 1000 and it worked My question, why I got that error message, and how you would do it using your programming style? Thank you very much. Sub fillblankcells()...

Hi I've developed a worksheet with a rating scale. I've been attempting to code where if an exclamation mark occurs, a pop message appears. However, the pop up message only appears when I double click on the cell where the exclamation mark (!) occurs. My desired outcome is when the exclamation...

Dear Sir / Madam; I had my Laptop on service at STAPLES from Oct 2018 to Mar 2019 to “Update the Network Driver” Staples did an extremely bad job, andnow I cannot open any of my files (XL files or any of my User Forms). I asked Staples to install MS Office2010 (the ONLY CD I could find...

So I have a report that uses a Dax formula ( measure) to create a value field that returns the content of the cells. It works great on my computer .. On the other end users get the following message "The query did not run or the Data Model couldn't be accessed. Heres the error message we got...

Hi I want to improve the code below so if a user entered a wrong name, then vba will give error message. I tried with IfError() as below but got error message. Thank you so much. Sub mylookup() Dim xname As String Dim xnumber As Integer xname = InputBox("name") xnumber =...

My worksheet contains query which I can easily refresh by right-clicking and choosing refresh. However, I want to remove the values on the worksheet without removing the query. If I did that manually, a message pops up asking if I want to remove the query as well, so that if I choose no, the...

Is there a way to have a formula do: if any cell F3:F23 is less than -.25 or more than .1 "explain"? I have a conditional formula =AND($F11<>-1,OR($F11<-0.25,$F11>0.1)) that works great but I'd really like to have a formula that looks in the entire column, and if any cell is "out of tolerance"...

I have an Access 2010 program that works fine under Win 7 but gives an error message when running under Win 10. The problematic statement appears to be: DoCmd.SendObject acSendNoObject, , , Me.EmailAddress2, , , Me.EmailSubject, Me.EmailContent, False An message appears stating an error has...

Hi, I currently have this formula: =+IF(AVERAGEIFS('Rin Data Sell'!$E:$E,'Rin Data Sell'!$A:$A,$A112,'Rin Data Sell'!$H:$H,H$1)=0," ",AVERAGEIFS('Rin Data Sell'!$E:$E,'Rin Data Sell'!$A:$A,$A112,'Rin Data Sell'!$H:$H,H$1)) However it is populating an error message on cells that there is no...

Hi I am getting an error when I open a excel sheet. Excel found unreadable content in"my sheet name" Do you want to recover the contents of this workbook" and then I get the below pop up. The pop up message what I get is "Excel was able to open the file by repairing or removing the unreadable...

Hi The code below will unprotect workbook if the user typed the right password. But when I typed wrong password, excel sent me to VBA with run time error message asking to enter the right password. How can I improve that so Excel would give an error message but stay in excel. Thank you Sub...

I was wondering if there was anyway to carry variables across multiple sub routines. What I want to do is set a macro to a button, and I want to use an integer to make small changes to the main sub routine. I know I can accomplish this by making the button change a cell in excel, then making...

Hi I want to improve the code below. If user will enter a text instead of number the program will not stop because of "type miss match" message but maybe give a warning message to user or something. How can I do that? Thank you so much. Sub studentmarks() 'to find students grade Dim x As...