workbooks

Hi, I just started using the Power Query add-on for Excel. I have a workbook that is connected to 3 different excel workbooks. The 3 workbooks were extracted from the SharePoint site and put into a folder. I have the main workbook which appended those 3 workbooks into 1 sheet. My problem is that...

I have a number of linked workbooks that I need to share with one, or possibly two, other team members. We work in different locations. I have trialled sharing these workbooks with one colleague via OneDrive, which wasn’t without some problems but I wonder if there is a better/smarter solution...

The code below works with renaming workbooks, however it also moves them as well. Is there a way to modify the code to make a copy of the workbook instead of moving it? Thanks much in advance! Sub RenameTesting() Dim OldName1, NewName1 'Work books based on cell values below OldName1 =...

Greetings Excellers! I'm currently working on a workbook with lots of UDFs and other volatile functions. Trust me, I've done my research and the UDF/volatile function mode is the preferred method in this instance. (The key phrase is "in this instance.") I also have other workbooks where...

Good evening Ladies & Gentlemen I have been asked by a friend if I could help with an issue she faces on a weekly basis with excel workbooks Basically on the Monday morning of each week, she has to open a folder and view excel workbooks contained within that has around 80 - 150 workbooks at...

Hello!! New user and beginner to VBA. I'm trying to automate the comparison of 2 excel workbooks and have a message box in the masterfile pop out, telling me if theres a math between the total sum of items in "Books-Raw Listing" & "Raw Listing" workbooks. Here's the tricky part, the...

Hi all having an issue where i run the below code: Sub UpdateLinks() Dim Location As Variant Dim File_Name As String Application.ScreenUpdating = False Application.EnableEvents = False Call unprotect For i = 5 To WS_Admin.Range("C4").End(xlDown).Row File_Name =...

Hello, I have a workbook that opens a userform as (vbModeless) on open and hides the window. Private Sub Workbook_open() Windows("Test").Visible = False Welcome.Show (vbModeless) End Sub The problem i am encountering is that this works only when there are other workbooks opened. If i open it...

We use an online database system that we created for our company. I create Excel workbooks for entering data and generating certificates. The workbooks have several buttons on several worksheets that are used to navigate through the worksheets and for running various macros in the workbook. Once...

Hi everyone, Has anyone had any experience of running macros on a shared workbook? I know that array formulas cause shared issues if they are not locked down and protected before sharing it but what happens when I was to run a few macros? I have a workbook which will be used on a daily basis...

So I have multiple workbooks in SharePoint, the regions data, that I want to conglomerate in a HQ book. The regions workbooks are secured so that each region can only open their workbook but I have permissions to open all of them. The columns are all the same across each regions book. I want to...

I have created 5 workbooks or sheets which have VBA and macros in them. I have created a new workbook with a userform in it . I would like to copy those other workbooks and sheet into the new one with all formatting and coding. tyvm

Its pretty annoying having to manually save every related add-in referenced by a workbook. How can I automatically save them upon saving the workbook? So, in the workbook itself I have code in the "ThisWorkbook" module: Private Sub Workbook_AfterSave(ByVal Success As Boolean) If Success...

Hello, I need some advice regarding following: Once a month a workbook is created with reports. The structure of the monthly workbooks looks in 2019 like this: Statistics Modell 201906.xlsx Statistics Modell 201905.xlsx Statistics Modell 201904.xlsx Statistics Modell 201903.xlsx Statistics...

Is it possible to use the same macro keybind in different workbooks but have only the code tied to the current workbook run?

Hi all, I have some multiple workbooks that I have saved on a sharepoint site that have macros to open other workbooks on that site and pull data out of them This all works fine, except sometimes when I open the other workbooks from the sharepoint site. excel seems to open the workbook in...

I often have several workbooks open. When I run one of my macros, I output to the Statusbar using Application.StatusBar but that output to the statusbar in all of my workbooks. Is there a way to specif which statusbar you want to output to?

Hi Team, please help, My task is to open each workbooks from a range, copy workbooks range and paste in master file, But Challenge I am facing is that firstworkbooks data will be pasted correctly. but second workbooks Data should be pasted in specified range of Master workbook.and row should...

Some of my workbooks have a connection that pulls data from a website. I need to batch open those workbooks and update the connection. The problem is that the code is not working, I suppose that's because I was unable to be "BackgroundQuery: = False" before reflashall and not wait until update...

Hi all! I have a UDF that I utilise when I need to repetitively copy/paste multiple data ranges between two excel workbooks. Sub ACopyPasta(CopyBook As Workbook, CopySheet As String, CopyRange As String, PasteBook As Workbook, PasteSheet As String, PasteRange As String, Optional transpose As...