vba & excel 365

At Name creation, Excel defaults to Workbook; which was fine when intended with only one sheet. Now after finishing all the formulas, I have new need which requires Sheet duplicated to same workbook. What I need is help on, preferably non-programmatically, is all Names to remain same for...

Hello to all, I have 2 Excel Workbooks (DataBase.xlsx and Program.xlsm) DataBase.xlsx is a shared file located on a shared folder (Teams/Sharepoint). Program.xlsm is an Excel file located on user's PC. Any User can insert and retrieve Data from the DataBase.xlsx. I am using GetObject to open...

Kind regards I am carrying out a linear regression process, for which I have resorted to the use of a userform, where in each of the four textboxes I have to enter the input data corresponding to four functions fi(x) To check if the input functions are valid and do not present some kind of...

Trying to create a automation flow for a scheduled refresh where data is getting fetched from Sharepoint Lists and later unpivoted in Power Query (which is working fine). In order to refresh the excel file, shell script opens the excel file which stays open for some time during which data gets...

Hi Folks, I'm using Microsoft 365, so a current version of excel. I'm having issues with the following code to refresh all the queries I have in my workbook: Sub Refresh_All_Data_Connections() Call TurnOffStuff Dim objConnection As Object Dim bBackground As Boolean For Each...

Hello! I have successfully used a command button to add in a row to the first position in a table, but am looking to also keep the first column formatted as a date. The purpose would be to keep the most recent entry at the top always, to keep wrap text on and to keep the row auto-sizing to the...

I am trying to change the names of my pivot table columns that is created in a macro. The names of the columns from my data table will always change, but the locations will remain the same. ActiveSheet.PivotTables("PivotTable5").AddDataField ActiveSheet.PivotTables( _...

Good morning amazing excel people! I hope you’re all well and enjoying the sunny weather, if geography appropriate. I’m really not to sure on a what VBA code I should use or if what I would like to do is even possible. The question; I have a very simple billing table that records appropriate...

how do I loop a sub button click () so it will run data again using the same macros, but populate information in the next row down? The file that it runs is an SQL, but I need the data to go for example line C3 down the column to C4 (Module two) Sub Button2_Click() Call TXTdATA 'Macro1...

Hi Folks, This is my first go out extracting *.xml order data into an excel table. Aim: to select a folder in FileDialog, and select/read multiple xml files to extract the order data into an excel table. Basic sales order structure in one xml file: Order 1 -----Order 1 details (customer...

Hi, I have an old excel file (XLSB) that I wrote to help others understand how VLookups actually work, as I kept getting the same questions about 'Why is it not working this time when I have done everything the same', this will have been created in about 2013/2014. Within the file I have a...

Hi Folks, I am trying to build an excel model which will loop through all the workbooks in a folder and tell me which of them has password protected VBE modules. The reason for this requirement is that I'm trying to use another excel VBA model to find workbooks that are challenging our server...

Hello. I have built a code that will replace an image in 3 separate sheets in my workbook; however- sometimes the images are "portrait", sometimes, they are "landscape." I want to max out the size of the image when the pictures are replaced. (By the way - each sheet has the image placed at a...

Hi Folks, Have checked Google and come a blank on this one. Does anyone know if it's possible to use VBA---in a Private Sub Workbook_Open() macro---to check if the filepath that the file has been opened from matches a specified path, and if not, close the workbook? Kind regards, Doug.