sharepoint

Hello, I have a file that has "missing Libraries" and gives the error "can't find project or library" on the most simple functions only when opened by other users. I have created an excel that runs several relatively simple Macros: Copypaste, print pdf and send emails. When I run it in my...

Hello all! Is it possible to have a workbook auto-protect the sheets, even as a live (auto-save) file on Sharepoint? Before uploading this shared workbook to Sharepoint, we had macros set to automatically re-protect all sheets in the workbook. I'm having trouble working out if this function is...

I have an Excel workbook that pulls data from several SharePoint lists on a Microsoft 365 tenant for ABC Company via Power Query. I have the exact same SharePoint lists exist at XYZ Company's tenant. I would like to have a button that programmatically switches the Power Query source from one...

How do I remove all these links to external templates? I've cleared names, broken links, gone through all my conditional formatting, and I cannot find the source of these templates to clear. They are associated with 365 login from my former employer and I no longer have access. Thanks

Hello, I have a sheet in a file which I would like to update automatically with changes. the problem is the file name changes everyday in the format of "AAAA01232022" to "AAAA01242022" so the change is in "mmddyyyy" format and progressing by one each day. Occasionally there are days the file...

Hi All Really hope that someone can help with this. I've spent most of the day trying... and failing. I have a few hundred PDF documents in a Shareholder folder and I'm looking to open them via an Excel hyperlink. The code below works when the files are saved on my local drive, but fails...

Firstly, am not sure if this is the 'correct' place to post this as it's not about Excel per se, but with the large number of users, I'm hoping that it's a 'set-up' that others may have come across. Apologies if it's not the correct place: Admin - please delete if necessary. We are seeing a...

Hi All, I'm hoping for some help please? Ive been trying to create a button in excel that saves the file for the current workbook with the name as cell value and a path (Sharepoint). below is what i have so far, but doesn't work. HELP PLEASE Private Sub CommandButton1_Click() Dim path As...

Referring to this article: https://support.microsoft.com/en-us/office/change-where-you-work-on-files-that-you-check-out-from-a-sharepoint-library-b838b4cb-e575-4d35-bad5-b3e333c714b8?ns=excel&version=90&syslcid=1033&uilcid=1033&appver=zxl900&helpid=191803&ui=en-us&rs=en-us&ad=us It tells me the...

Hi, Struggling with VBA .SaveAs from Desktop (365) to Sharepoint. It's failing intermittently with an "Error 1004 Document not saved." I've check the paths and they exist and receive the files when it works. I've found other documentation on this subject concerning Onedrive and Sharepoint but...

When I use ThisWorkbook.path I get back a URL (https://...) instead of a file path (C:\...). How do I use VBA to get the local file path? For context, the workbook I'm using is saved in my OneDrive folder.

Hi, I am looking to add a list of users from excel onto a SharePoint site and grant them permissions in a specific group. My excel consists of the following information: GroupName UserAccountEmail It will just be users uploaded to one specific SharePoint site. Any assistance is...

Hello everyone! I'm trying to import all folders subfolders from SharePoint to Excel. Can some one help me with this program error . Thank you in advance

Hello All, currently I am working on getting a database setup with macros in VBA. I am facing the issue that when I upload my .xlsm to our teams sharepoint online. The built in macro button for opening a userform only works for me (who created it). If some of my teammembers try to press on the...

HI, so my issue is as follows. I have a master workbook in which I would like to track changes that were implemented in other workbooks in dofferent locations. The workbooks are all including the master saved in different locations on sharepoint. Now what I would like to track are changes in...

Dear Experts, I have SharePoint excel used by huge group, The excel is password protected as it has 1. Hidden columns 2. Hidden Formulas 3. Protect the headers as they are linked to SQL 4. Should be protected against people over writing data on the hidden columns So I have locked the cells...

I have an excel file that I use to update daily schedules. The code is fairly simple yet has intermittent faults due to an unknown reason. The code below opens a file( on teams), updates links and then closes the file, the fault is, sometimes the file will open and close but not update the...

hello to all. I am trying to create a script that extracts chart elements (in jpg) from excel to sharepoint. I'm currently using this script but without results: function main(workbook: ExcelScript.Workbook): ReportImages {...

I am new to the forum but I am having a challenge with finding a solution for my situation. I have an Excel (Office 365) file that is hosted in SharePoint. It is currently formatted with Drop down lists based off of a named range. The drop down list is applied to cells E9:AI889 on the...

I have 2 .xlsm files on Sharepoint. The first (Load Sheet) opens the second (Dist Background), pastes information, save and close. When running the macro, I get the error: 1004 Method 'LockServerFile' of object '_Workbook' failed and the 'Dist Background' is open. I assume it opens but the...