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...
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...
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...
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:
'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...
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.
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.
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...
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...
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...
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...
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.
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...
I have searched online for this issue but couldn't find a proper solution.
I have a userform that open (while the workbook itself remains hidden) using the following code:
ThisWorkbook.Windows(1).Visible = False
If Workbooks.Count = 1 Then
Application.Visible = False...