sharepoint

Hello Everyone, I was hoping there might be someone within this forum that has come across this issue before. I would like to set up some code to review a sharepoint site for the most current file that has been uploaded on to the site. The URL for the site is...

I have a large-ish .xlsx file that I keep live on sharepoint for multiple users to view/edit and it suddenly is saying that it has 'Unsupported Features' and external links. I've searched the whole workbook for external links and I have not found references to an external workbook in any cell. I...

Hi all, I've been trying to figure this out for the longest time but havent managed any progress. I have an excel sheet (Excel A) that i update regularly (ie daily) that is put on my company's sharepoint/microsoft teams for others to refer to. However, i am working on another file (Excel B)...

The following code opens the 8am sharepoint report: Application.DisplayAlerts = False Application.AskToUpdateLinks = False txtDate = Format(Now, "m_d_yyyy") & "%208am" Workbooks.Open "https://sharepoint.abc.com/sites/Shared%20Documents/Open%20Cases%20by%20Bucket/Routing_Open_Report_" &...

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...

This may not be the perfect forum for this question, so ifyou have another suggestion of where to as, I am happy to explore… I created an excel spreadsheet (name: Excel1), thisspreadsheet uses macros and pulls data from a second excel spreadsheet (Name:Excel2). Excel1 tracks a service...

Hi everyone, Newbie question here so any help I get I'll be grateful! I tried using the following script to save a spreadsheet onto sharepoint which i've opened with vba on another spreadsheet. Path = "http://sharepoint.com/" filename1 = " Test File" dtt = Format(CStr(Now), "hhmm")...

Hi Mr. Excel, Thank you for reading my post! Long time lurker, first time poster. The code below is meant to save a file as two different naming conventions and save each to a different Sharepoint site. The issue that has arisen is that this workedeven last week, but now it is telling me...

I am writing a macro to open and update an Excel file in SharePoint online using Excel in Office 365. I can open the file but it open as read only. I found the solution to add ActiveWorbook.LockServerFile after opening the file but I get application-defined or object-defined error when I...

Hello I've hooked an excel file up to a SharePoint folder on my o365 machine no problem. I'm trying to hook up colleague up as well - she has excel 2013 however and has had to download the Power Query add-in. The add-in doesn't have 'From SharePoint Folder' available under 'From File'...

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 an excel template that I keep in sharepoint. When I get a new client, I use the template to create a new file. I was really hoping to link a few cells in the file to the metadata in sharepoint either upon cell value change or saving the document. I linked them through custom...

Hi all, I've searched the internet trying to find a way to delete a file from a sharepoint site. I am struggling to make what I've found work, and honestly it's probably because I don't quite understand the coding and have something slightly off. Essentially what I'm trying to do is "move" a...

I'm getting run-time error '1004': The file path you entere is too long. Enter a shorter file name or select a shorter file path, and then try saving the file again. When I debug I get taken to "ThisWorkbook.SaveAs StandardFile" However, I'm only getting this error when a particular user on...

Hello, I need some direction or a best option. I want to synchronize data between Excel and a SharePoint List (online). I am using Excel 2016. My Excel file is the master file and I need to update a SharePoint list with the excel file. I am currently copying snd pasting, but that is not...

I am trying to build a spreadsheet macro, which is based on the below mentioned steps. 1) Takes the list ID number of a SharePoint form from the user via input box. 2) Creates a folder name based on this ID number (originally captured by the input box) 3) Retrieves all the attachments stored...

I need to know if there's a more efficient way of uploading data to my list on Sharepoint. I have a worksheet with an average of 100 rows and 106 columns, making a total of approximately 9,900 cells. This is my current process to upload: I go to my list on Sharepoint, viewing it in edit mode...

Hi, This seems such a silly problem for me, so silly that I can't seem to solve it. The company I work for has just upgraded/ changed to Sharepoint on the cloud and we all have the Office 365 suite of programs/ apps on our computers. Previously when I wanted to open more than one workbook at a...

I've been all over the web trying to solve this one with no luck. I'm very new to Power Query, so please forgive any ignorance on my part. I'm the admin for a Sharepoint site with several libraries that contain hundreds of Excel files in each. All of the Excel files are the exact same...

I am now required to save all of my Excel files in SharePoint, but SharePoint does not seem to allow me to show more than one colour fill in each cell. If I show a gradient mixture of colours (say Amber/Red) in an Excel cell, when it is saved into SharePoint one of the colours disappears. Is...