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...
Hi all,
I hope some of you experts can help me with this. I am trying to put together some VBA code to automatically select a source workbook from a Teams (Sharepoint) folder based on a couple of variables (folder name and filename suffix) that are provided within the cells of my destination...
About 1 out of 5 times, Power Query in Excel will get hung up when pulling data from a .CSV or .TXT data file stored on our Sharepoint site. I have checked all the data source credentials in Excel and everything looks fine. In the lower right had corner of Excel, it will simply say "Connecting...
I have managed to extract data from excel to a specific word format and save it on my local disc with use of VBA. Now I need to set the code so that the file is saved to a specific Sharepoint folder.
The code I got now is;
SaveName = Environ("UserProfile") & "\Desktop\ " & _...
Hey all, I'm hoping you can help.
I've searched many versions of this, none of which I can get a resolution from with other peoples resolutions, so any help is massively appreciated. I'm completely stuck! :(
I've an excel workbook which completes a statement reconciliation, matching a supplier...
Hi All,
I have an Infopath form which when clicking submit, posts the data to the associated fields in a Sharepoint document library. The issue I have is this;
Field is 'Request Date'
When editing the Sharepoint list item that is created when submitting the Infopath form, this column/field is...
Hi all,
I have developed a tool which creates a new list in sharepoint when I run a macro. But its takes datatypes of column only as
1) Single line of text
2) Number
3) Date
But I have a column in excel which has a drop down options but after running he marco, when I check my sharepoint list...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.