vba

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...

Hoping someone can help. I have a worksheet that i need to remove or add a cell range(s) (red border area) from the 1st row down the column to a specific point (Stop Line) which can change dynamically. The more ID's added or removed in the rows will push the Stop Line down or up. Also, the more...

I have 5 main sheets and want to freeze pane lines starting from sheet 6, row 7, column 2. What do I have to do? Thank you.

I have 3 tables: Table1- for First data (dynamic data, get from other sheet) Table2- Reference to get "score" Table3- Final result "score" We need to read first var in Table2, compare with first var in Table1, then do some compare like folowwing (I have them inside sheet attach) Step 1...

Hello excel experts, I need your help with the following: I have a range named "Database" with about 5000 entries and growing, on the same worksheet I have a small calendar that populates tasks according to the current month and date from the database, this calendar places items for each date...