vba

So, I have 156 account numbers with 17 digits. The only numbers that matter on the account number are the last four digits. I need to take the balance of each number and sum them together based on the last four digits or a range of the last four digits. For instance, say I have 12 0000 0000 000...

Hello helpful peeps! I have a massive macro that is run every month on files that are received from an outside source. It worked last month, but this month I received an error. The file received has not changed, nor has the code. I don't get it. Any help is appreciated! The line where the...

Hello, Each week, my whole company attends a meeting. Before each meeting, an email is sent out with a Microsoft Forms link which the whole company must complete to state they've acknowledged and understand the briefing. This is because some employees who work nights can't attend a daytime...

https://drive.google.com/file/d/15bM1T31K9eEbvtOL64D2i63pQ_60Zjtf/view?usp=drive_link I have an excel that calculates business position for 481 branch locations. There are certain number of branches under each Regional Office (RO/RO Name). User can select the branch by entering the DP Code of...

Good morning community, I am retrieving seven values from a saved Invoice to a different Workbook. I have seven rows, from an invoice, to retrieve the values to columns Q to W in a different workbook. My paths start on row three as follows (not the complete path but the important elements are...

Hello, so I want the following thing to add to this (I am very new to VBA and learning this since last friday): - Send Mail from a specific Mail adress (emailItem.To does not work here) - Have a Signature automatically drafted e.g. when I click the Checkmark the Mail Editor opens but my...

Hi, I'm hoping someone can help me. I apologise in advance as it might take me a bit to explain what I need. I'm trying to dynamically/automatically add new rows underneath the existing row that contains a FILTER formula that is working across multiple sheets. I will try my best to explain...

I have a table with 3 columns, whose fields I show below: ABCDE123Customer_IDProcess_NumberFolder_Name41234P0000000011234 - 155678P0000000025678 - 267D4:D5D4=[@[Customer_ID]]&" - "&[@[Process_Number]] The [Process_Number] Column, has the Format...

Please help to modify this code to include the following command, if column H:H in ws.Neonpay is equal to "B" print to PDF a list of the lines in column A:A in wsNeonpay that correspond to the cells in column H:H that are equal to "B" for each of the merchants in the merchant list and if column...

Please help to modify this code to include the following command, if column H:H in ws.Neonpay is equal to "B" print to PDF a list of the lines in column A:A in wsNeonpay that correspond to the cells in column H:H that are equal to "B" for each of the merchants in the merchant list and if column...

I"m running a MacBook Air M1 OS 14.1. I'm running MS VBA 7.1 I'm using Excel for Mac Ver. 16.7 Office Home & Business. The issue I have is when I run a macro when the sheet is protected it will crash. When the sheet does not protect it the macro works fine. I protect the worksheet and I don't...

Hello all, Been an avid follower the recent months looking to create a tracking sheet that delineates to the right after each ending week passes. The tracker has been made and now wanting to introduce a module with the intent to automate the the storing of tracked data. The code I'm looking...

Dear all, I have the below code which uses Dictonary object [CreateObject("Scripting.Dictionary")] to get the unique string name and number of occurrence of the specific string. [ Sub CountUniqueStrings() Dim lastRow As Long Dim dict As Object Dim cell As Range Dim...

Hi, I have a pivot table that was generated by using a power query data model. I have a filter on the pivot table called "EmpName" and I would like to iterate through all the EmpNames in the filter, copy the resulting pivot table data to a new workbook and save it as an entirely new workbook...

I have a Table, with 144 columns, consisting of strings that I convert to Formulas in another Table. Work around for Volatile function Indirect when I add and remove Sheets, but need the Formula NOT to go #REF.... SO - I have an 1 dim array and would need each data to be written/saved in a new...

Hi Experts I was writing following VBA code to add a new record. But it's constantly giving 'Type Mismatch' Error with variable x4 The new record has to be "A 1111" (A + space + 4 digits next to last used) I must be missing some trick. Also, I'm thinking of VBA to ask how many records to add...

Hi. I am trying to do a Code in excel VBA to refresh SAS tables instead of pivot tables. I have some tables that contain data and are connected to Statistical Analysis System (SAS) and I need to refresh them. I am using this code to refresh everything once but sometimes it doesn’t work: Sub...

Hey all, It's not exactly related to VBA and excel, but I hope this has enough relation to it. I wrote a .bat file. The purpose of this .bat is to watch a folder for new files, and if so, call a VBA command. :loop dir /b "%folder%" > nul 2>&1 if errorLevel 1 ( timeout /t 30...

I am working on a VBA file that has a button, which should upload some data from an Excel file to a Sharepoint file. The problem is when the Sharepoint file is open it takes 2/3 times to run it to upload the information. But I want the data to be uploaded whether Sharepoint is open or not. This...

Hello, I am very new to VBA and trying to find out how to make this work. So basically I have a Checkmark from D2 to unlimited. When Checkmark is clicked > Display Message I have the following code written so far but I don't know how to display my message without having to run the...