I made a PQ append query, send reults to Data Model and then uploaded the pivot table to the excel sheet. Now I'm trying to apply filter based on the cell value
I am getting a Runtime error 1004 and when I debug it, it takes me to this sub, this sub works fine in another sheet, I don't know whats wrong, can anyone help?
I am trying to automate file upload on chrome, getting error here :method run object iwshshell3 failed" please help: Dim Customer_rates As String Dim WshShell
I'm trying to add a toolbar control on a sheet. I get this error. It does add the toolbar, but that error is not skippable with On Error Resume Next, so it stop
I achieved resolving Names with this code from an example: Function MailSuchen(strSuchen As String) Dim objEmpfaenger As Outlook.Recipient Dim objExchBe
I have several signatures in html format. I need to choose one of the signatures according to the domain included in To: and CC: label. The code below merges t
I am using this code: Function wrksht() as Variant wrksht = Application.Caller.Parent.Name End function I am continuously being thrown run time error '424' ob
Is it really not possible to declare a 0-length array in VBA? If I try this: Dim lStringArr(-1) As String I get a compile error saying range has no values. I
I would like to restrict emails which have recipients outside our organization using my domain. Is there a way to restrict emails using NOT LIKE condition? I am
I have a little problem with VBScript. There is how it should work. It is a simply code that should go through all emails in particular folder, get particular e
Is there a way to create a search folder in Outlook, that returns only conversations where not all emails in the thread/conversation have been flagged as comple
I go into a shared inbox and forward an email as myself, to my boss, using HTML formatting. I wrote VBA code that works on every step except changing the From l
User has a column with names (or name, surname) to send email. When there are several with the same name and surname the macro is selecting the first matching.
I need dynamically set via VBA NumberFormat to imported txt file values, as just below : Imported values number type is "General" so I want to
I have a sheet called "Scores" where I have Column D and J with values from 1-9 in both columns. In this same sheet I have a Column A with the corresponding nam
I'm using Outlook 365 - Microsoft Exchange(owa). I have written a script that looks for emails in my Outlook Inbox with any subject line containing "PHI Attriti
I refer to a code from :https://www.datanumen.com/blogs/quickly-find-delete-paragraphs-containing-specific-texts-word-document/ However, I can only delete the h
I have a macro in Excel to delete mails older than 30 days from folders and subfolders in a shared mailbox. I have a sub for looping through each subfolder and
Still in need of help :) I'm trying to adapt the following chunk of code to VBA for Mac (as the final implementation has to be on Mac): Dim ws as Object Dim res
Can anyone explain what is happening here? I have some values in column A that I want to use with the match function. But there are some numeric values that don