sharepoint

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

I'm an owner for a SharePoint site and associated to several other SharePoint's. I'm using PowerBi Desktop and want to Publish my findings. When I attempt to publish to that SharePoint's workspace it will not appear. I am utilizing Data directly from a list in that SharePoint. Any thoughts?

Hi All, Is there a way to directly connect PowerPivot to a SharePoint list? I've searched for a while now and can't seem to find a way. I have exported the SharePoint list to an excel file and I have connected the PowerPivot to that file, but it means refreshing that excel file and then the...

Hi, My company recently switched from Google Docs to SharePoint. Everyone on the team is working from home (of course) and accesses the same Excel spreadsheets. One thing we need to be able to do is selectively format text in a cell as bold, italic, a different color, and so on. Example: A cell...

Hi I had an excel file where one of the macros saved the file as a new workbook to the users last open folder. I now want to save the new file in to a SharePoint library folder but as the user has to choose a content properties, its coming up with a debug error. The content is a droplist of...

Hello, I have pulled in data from SharePoint to make my PowerPivot. When I send the reports to others and they go to Data-Refresh, they get the following error message: Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException I found this Work-around : go to Get Data/ Data Source...

I have a workbook that is accessed by my users in Teams, this workbook is saved on a Sharepoint drive and accessible all the time. I want to be able to pull the data from a row when user requests it and paste it into another workbook... to put in into perspective when the price request becomes...

I'm trying to save a workbook on sharepoint as a PDF (which I have working using this path \\xxxx.sharepoint.com\sites\xxxx\Shared Documents\) but when someone has the PDF open on either a network share or sharepoint I get the "document not saved" error. My question is, do I just have to wait...

I am looking for a script to post/update/delete items into a sharepoint calendar. I found a working script to make new lists on sharepoint but my knowledge of vba is not big enough to work on a solution to let it work on a calender list. Public Sub PushSPList() Dim lname As String, guid As...

Hi All Any help appreciated I am currently using this formula, to have the filename in a cell, works fine. However, when I upload into SharePoint, it doesn't work and returns a #Value! error =TRIM(LEFT(SUBSTITUTE(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),".xl",REPT("...

Hello, I have a macro that needs to create a folder on SharePoint, then generate and save multiple files under that folder. I've done a lot of work to get the code right for creating the folder, but with no success. I've read that you need to drop the http: from the front of the folder...

I am exporting 2 lists from SharePoint, then running formulas involving fields from both sheets to create reporting, etc. I'm then refreshing the tables in excel to update the data, so the connection needs to stay intact. I'm also using PowerPivot to create a data model to work from with many...

Our IT department recently updated our intranet/sharepoint and some of my files stored there for my department are now behaving differently. A sheet I was unhiding ("Guide") based on user name is now the sheet it always opens to even though it's not the last thing that happens in the macro (a...

Hi, Firstly, I apologise if this has been answered multiple times but my google searches, although provided ideas, have produced as many questions as answers. In the Excel file where the code resides, I have an excel table that has a list of absolute file paths (SharePoint). They are in...

Hi All, Every month I have this task of collecting data from about 200 reports, into a main central consolidation file. The Report is an Excel file stored on SharePoint. All the Data i need is on a hidden tab in one Range. Process:- 1. I go to the SharePoint site where the files are stored and...