workbook

Hello everyone, I'm trying to adjust Excel's "Find All" feature so that it searches the entire workbook by default, rather than only the current sheet. I’ve researched this and found that there are third-party tools and VBA macros that can accomplish this, but I’d prefer not to use them. One of...

Full disclaimer I have only been using VBA for very small projects and have never attempted working with multiple workbooks. I have a user form in 365 that enters data per the form's request. I am using 3 files, an entry file, a database file, and a read file. Between the database file and...

Hey All, Windows Office 365 (Excel Version 2306) I have taken over maintaining a global macro file that is stored in XLSTART so everyone in the office shares the same macros for every single excel sheet opened. I want to be able to detect when a new xlsx/xlsm file is opened and record the...

Apologies if this is completely basic, but I can't find anything in the forums that directly relates to what I'm trying to accomplish. I am not at all schooled in anything VBA, technical Excel, etc. I just Google to figure things out, and here I am! Here's my starting point: I have a workbook...

Let's say I have 2 workbooks and i have to create 1 wb1 = workbook with the macro wb2 = worbook with the info so I have an activeX button in wb1, when I click it it should copy the KeySheet from wb2, create a new workbook (wb3) and paste the sheet onto this new workbook Idk if i explained...

Hello All...please someone help a VBA code that can automate copy of sheet from open workbook and paste to other but closed workbook. Then overwrite if sheet name exist. Example as follows: Open File1 = main file, have the sheet name "report". Consist macro that copy the sheet name "report" to...

Hi people, The code I currently have is fully functionning, however I would like to add a feature that takes each worksheet that starts with MW and makes it into a workbook that is then saved on a folder that I've made ( the path is C:\Users\(MYNAME)\Desktop\VBAWorkbookTest). Ideally, the...

𝙷𝚎𝚕𝚕𝚘 𝚠𝚘𝚛𝚕𝚍 𝙵𝚘𝚛 𝚎𝚎𝚡𝚊𝚖𝚙𝚕𝚎, 𝚒𝚗 𝚊𝚌𝚌𝚎𝚜𝚜 𝚢𝚘𝚞 𝚌𝚊𝚗 𝚘𝚙𝚎𝚗 𝚓𝚞𝚜𝚝 𝚘𝚗𝚎 𝚏𝚒𝚕𝚎 𝚊𝚝 𝚊 𝚝𝚒𝚖𝚎. 𝙸 𝚊𝚖 𝚝𝚛𝚢𝚒𝚗𝚐 𝚝𝚘 𝚊𝚊𝚌𝚑𝚒𝚎𝚟𝚎 𝚝𝚑𝚊𝚝 𝚒𝚗 𝚎𝚡𝚌𝚎𝚕. 𝚜𝚘 𝚠𝚑𝚎𝚗 𝚒 𝚊𝚖 𝚘𝚙𝚎𝚗𝚒𝚗𝚐 𝚖𝚢 𝚏𝚒𝚕𝚎 𝚒 𝚌𝚊𝚗 𝚌𝚘𝚞𝚗𝚝 𝚝𝚑𝚎 𝚗𝚗𝚞𝚖𝚋𝚎𝚛 𝚘𝚏 𝚘𝚙𝚎𝚗𝚎𝚍 𝚠𝚘𝚛𝚔𝚋𝚘𝚘𝚔𝚜 𝚝𝚑𝚎𝚗 𝚌𝚕𝚘𝚜𝚎 𝚖𝚢 𝚏𝚒𝚕𝚎 𝚘𝚛 𝚘𝚝𝚑𝚎𝚛𝚠𝚒𝚜𝚎 𝚃𝚑𝚎 𝚘𝚗𝚕𝚢 𝚒𝚜𝚜𝚞𝚎 𝚒 𝚑𝚊𝚟𝚎 𝚗𝚘𝚠 𝚒𝚜 𝚑𝚘𝚠 𝚝𝚘 𝚍𝚎𝚝𝚎𝚌𝚝 that when I am trying to open...

Hi, I would like to disable the option to delete, move, copy or rename one specific worksheet in a workbook, regardless of the activated worksheet in the workbook. I cannot protect the workbook structure, because I want to still be able to delete other worksheets in this workbook without the use...

My code below: Sub arrange() 'all declarations for wkshts and wbs stated at top unless stated here Dim g1 As Range Dim g2 As Range Dim g3 As Range Dim g4 As Range Dim g5 As Range Dim g6 As Range Dim g7 As Range Dim g8 As Range Dim g9 As Range Dim g10 As Range Dim g11 As Range Dim g12 As Range...

Hi, This is my second code in VBA, which will hopefully work; so consider me a beginner. I have two workbooks that I want to compare and highlight differences. I've prepared a VBA code but if any rows are added or deleted it marks them too, which goes against what I want to do. Aim: Every time...

Hi, I have a VBA code (see below) for a macro button to add month sheets in a workbook. Now the month sheets are sorted from January to December, but I would like them to be sorted from December to January; while still keeping differently named sheets at the end of the worksheet tabs. After...

I'm new to VBA and I'm trying to move my first steps into it, I need help! Below you will find a code to import a range from a selected file to the active workbook. The macro is assigned to a button on the active workbook. What I miss, and I'm not able to write is that I would like to paste...

Hi guys, have serial numbers with data in row in two different sheets (from main sheet divided later to two different, according the data in row). can someone help with a code to generate serial number after checking what is the max in the whole workbook? i am currently using +1 on the last row...

Hello, I have a situation where I am trying to list all conditional formatting rules that are in an entire workbook. In this forum I was able to find a thread that is over 3400 days old. Thread is titled "List all conditional formatting rules in a worksheet". In that thread, this is the VBA...

Hi All, I want to copy my whole workbook (xlsm) with formulas and macros to a whole new excel file (xlsx) without any formula and macro. I've found the script below on internet and works fine but is for 1 certain sheet. How can i include multiple sheets and copy this to the new workbook? It is...

I have several workbook(.xlsx) that have only 1 sheet per workbook. I would like to loop through all the workbooks in the folder one by one and find certain cells with specific keywords and copy the cell adjacent to it. Next, copy all the cells and paste it in a master file into its respective...

Hello, I'm trying to Select a File with a static table with Allocation Data and then copy and paste the data in each workbook corresponding to the employee number after a vlookup of cell A2. The first block of If statements is a file selector which returns the file path. I believe I'm...

It fails with Error 1004. The original file name was "Data Entry.xlsm". After the failure, when you look at File Explorer, the file has been renamed and it's written date is appropriate. Is there something about a "Sync" going on here? Thanks for your help. Mac

So whenever I attempt to save a fresh excel file, it will have my default save as option as XLSX. But I frequently have to download XLS files and then edit them. Whenever I finish I go to save as, and it tries to save it as a text (tab delim) file every single time. I have checked and confirmed...