vba & excel 2016

Is it possible to call Macro and then edit its variables ? Sub Save_All_Files() Call Account_Name_And_Year_1 Call Data_2021_1 Call Account_Name_And_Year_1 Call Data_2022_1 With Account_Name_And_Year_1 With wb With ws...

Hi Team, I am very new to VBA so please be gentle. I am trying to automate a lengthy process that I do everyday and I have recorded a macro to help me do the same. One part of the process involves filtering a set of names and replacing said names with one common term. the code - given below...

I want to use the same "Userform9" for both CommanButton's "SELECT" in each sheet Suppose, If I click on the "Select" Button at "Sheet1" then Userform9 will open. I can select any Option/Radio Button in Userform9 and save/close it. The issue is when I click on the "Select" Button at "Sheet2"...

Hello! I want others to save PDF file in the shared BOX file. Here is my code but it doesn't work. I tried a few possible coding but I'm stuck now. My user ID was Mochi. I use Excel 2016 I can use this and save PDF in the shared BOX folder. However others couldn't. Appreciate if anyone can help...

Hi all, I currently have an automatic code that can open up the MOST recent (date modified) file in a folder. It works great BUT my concern is: Lets say i set a timer of 10 mins to execute this macro, However the macro takes 15 mins to run and inside that space of 15 mins another 2 files are...

Hi everyone. So one of my coworkers asked me to update a macro that she uses for checking to see what assignments students turned in. Previously, she had a specific template that was never edited; however, she now wants to be able to still run the macro if a specific column is removed or one is...

I've seen some code, but nothing that matches exactly what I'm looking to accomplish. I posed the question about this using indirect but apparently its not feasible. I have a root folder called "Teachers" and under that folder, hundreds of subfolders for all the schools ( e.g. Teachers\School...

Hello, The code below was written to update formulas in F5:N and array formulas in H5:AA, and replace the formulas in F6:A6 and below with the output as values. I am using VBA code to avoid a slow workbook, forcing the formulas to run only after I have updated other data in the workbook. The...

I receive an excel report with a very interesting formating and in trying automate the clean up process of this table. I created the following code to remove the extra headers in the table, the code removes all but one header that starts with "*000*". Here is the code i have: Sub...

I have following vba code which throws error of object required error 424 please help me on this With Worksheets("OPTIONS").Activate.QueryTables.Add(Connection:= _ mystr, Destination:=ThisWorkbook.Worksheets("OPTIONS").Range("$A$1")) any help will be appriciated by word of thanks

Hi Friends, From past 2 days I been trying to extract multiple occurrences present in "cell text"(sheet1 ColumnA:A) and extract into sheet2 and sheet3. Cross match with IDs between sheet2 data with sheet3 and extract matched data into sheet4(Macro 3 final results). I have attached sample data...

Hi Friends, Looked on similar posts on this forum but did not find suitable solutions to my need. Here what I am looking to get this done by vba macro. I have list of data in Sheet1 and sheet2 with values to find in sheet1. VBA macro to find matched sheet2(ColumnA) data in sheet1 anywhere and...

Hi, I have a sheet that contains several ComboBoxes embedded directly into the sheet. I have them set up so that when I GotFocus the ComboBox dropdown opens (.DropDown method). However, what I would like to do is clear the ComboBoxes and close the ComboBox drop downs when I click on a button...

Hi, i think this is just a syntax issue but i cant seem to get it right. If anyone can help i would be very grateful. this script works at looping through all of the workbooks in a user defined folder and copying a specified range to a big list in the target worksheet of the workbook where the...

Hello all, i am struggling a bit in getting data within iframe. i tried a lot but no success. code - iframe id="reportsFrame" name="reportsFrame" src="/finengine/reportRunAction.do?rptroot=1110&reportID=EAME_DailyOpsReport_VAT&method=run" scrolling="auto" style="position: absolute; top...

Hello, I need to create a button that allows a manager to lock all data input, but will then allow other users to add to the sheet below what has already been locked. I know how to set up the button and password, but everything I do to protect the sheet ends up protecting everything --...

Hi Guys, So I am a complete novice in Excel VBA. I want to send email using Excel VBA. I have excel sheet in following format Column A - Name Column B - To Column C - Subject Column D - Path of attachment Now, each row of this excel should open a new email. I have modified a code to suit...

Ran into an unexpected issue with conditional Table row delete. I have two tables with each checking the other for contents (with ISNUMBER & MATCH formula). I'm trying to delete all table rows from Table MASTER where ID value doesn't exist in Table QUERY - easy enough. After launching the...

Need VBA code to copy and paste as values from a specific range A1:AE36 in a worksheet named "Matrix DSR" and workbook named ""Daily Sales Report Master Update File - CQ_v2" to a specific range A1:AE36 in a worksheet named "Matrix" and workbook named "BMH Daily Sales Report thru 08-21-19 run...

Hi together, I would like to jump (eventually with VBA) from a cell in a pivot table to find the cell with that value in the original table. I imagine that the current value has to be copied to the clipboard and that the value has to be searched (CTRL+F) in the source table. How does the...