exce-vba

Dear All, I am new to this forum.. I need a help I am suffering with sending email from excel automatically ..Please see attached screen shot for your reference : I am looking for a VBA Code to send emails automatically.. Sample file Link : Sample -11Jan24.xlsm Waiting for valuable...

Hello, I need some help! No arquivo anexo, quando a pessoa clicar no botão “SALVAR NOVAS INFORMAÇÕES”, preciso que você tire um PRINT do formulário e cole na planilha “IMPRIMIR” na coluna A:H.

I have a column as ZIP code based out of USA that can have maximum length as 5. If I give 11, then it can take 000 as predecessors and become 00011. I tried formatting cells option but that has options to make it 0011 or 000-11 or 000000011. I am not getting options to make 00011. Any leads on...

Hi, I have a macro created by one of my former colleagues. It a bit complex macro with multiple steps which includes application of mutiple formula. He is no longer working for us, and we have decided to move to power automate with Office scripts. I have been decoding each step and converting...

Hello House,I need your help for the BVA code for the paye for the form.I am still learning BVA Excel Code.Thanks ABCDEFGHIJKLMNOPQR2BasicHousingTransportLUNCHTotal IncomePensionNHFGross IncomeCRAChargeable Income1ST2ND3RD4TH5TH6THTax PayableMonthly...

Hi team I have a table on Sheet 1 and some values on sheet 2 column E Is there a way i can filter the table in sheet one to display content only if Column A in the table matcehs the values from Sheet 2 column E . I hope this want too confusing :) Thanks in advance

Such as asdfghjk =>asd-fg-hijk (alphanumeric) 1234567 => 12-345-67 (numeric)

Hi, I'm trying to select all the unwanted shapes in the range and I'm almost there but get stuck on one issue. Example below, I'm trying to select all shapes that are aren't named Rectangle 1 and Rectangle 5 in range A1:O30 and it should select 3 shapes which are Rectangle 12 and Rectangle x 2...

I have a spreadsheet that I had developed that allows me to input a client's name and the meeting date I had with them. Once I add those two inputs to the spreadsheet and hit an update calendar button the Macro I had developed will generate a specified number of outlook calendar appointments...

Good day all, I'm attempting to build a dashboard of Incident Ticketing data for our IT office. Every morning I extract a new Incident report from ServiceNow and import that worksheet into the dashboard excel file. I then try to update each row by matching ticket numbers between the new...

I have VBA code, it works when the filter date requirement is complete but if it's not complete, it will copy the header instead. Please check my code below: Sub Macro7() ' ' Macro7 Macro ' Dim LastRow As Long On Error Resume Next Range("c6").Select...

hi I need to search sender e-mail address excluding microsoft and no-reply@notify.aol.com for a date. This code work for microsoft only. Filter = "@SQL= (NOT urn:schemas:httpmail:fromemail like '%microsoft%'" & _ " And urn:schemas:httpmail:datereceived = " & daterec& "))" But when...

Hi All , I would like to request an advice how to send multiple group email based on a cell content. Currently i have a table that contain , name , country , email , cc , subject. The current existing macro that i have is able to send an email individually within the table. I am testing out and...

Hello, i am a shift supervisor i have 16 worker with different skills every worker has a pre defined day-off like the pic every one of them work 2 weeks as day-shift and 2 weeks as night-shift and has to change his shift from night to day directly after his day-off every 2 weeks i have to...

Public Sub Move_Files_To_Matching_Folder() Dim sourceFolder As String, destMainFolder As String, destSubfolder As String Dim FSO As Object Dim FSfile As Object Dim FSsourceFolder As Object sourceFolder = Environ$("USERPROFILE") & "\Downloads\" destMainFolder =...

Hi! I am new in VBA. I copied this code from other source. This code populates only one (1) result which is in column C13, my lookup value are in Sheet1 B13:B31. I want to display the result also in other column which is in H13. My Table array are in Sheet4 column A:E. My codes are below...

Hi there! Beforehand, if you need any extra information, as I may have missed something you need then feel free to ask me any questions. Many thanks! I am in dire need of your help to speed up two macro's. The names in the macro are Dutch, though that shouldn't matter. The macro was written by...

Hello I'm trying to figure out a way to open the workbooks using the array values stored. The only bug I encounter is at "Workbooks.Open(StoreList(0))" where I encounter "run-time error 0 subscript out of range" but the address is correct so I don't know why it can't find it? Sub uniquestores()...

Hello Experts, kindly help to use a vba code for the below. Use inputbox to select from column A first 14 rows and color, next amount of rows follow the image above. Do the same on other sheets. The result below

Hi guys i need some help on VBA. I have range of numbers in Sheet 1 from cells A6:O29. Next i have specific numbers selected in Sheet 3 in Column "B" I want to loop throw each value in Sheet 3 Column "B" and find that specific value in Sheet 1 range "A6:O29" Next it should paste Entire Row...