share point

Hi, I have used VBA to generate a pdf of an Excel worksheet. The pdf is saved at a Share Point site. Share Point settings require document properties to be able to group the files. For saving an Excel file the Share Point, the file properties are set with...

Dear Mr. Excel, First of all, thank you kindly for the wealth of information stored in this forum - it has helped me tremendously in my recent projects! I am trying to extract cell values from Excel to complete a Word template. I have completed Mail Merge tags on Word and it works...

So I have used this code before to look at files when they were last saved locally, however when I attempt to use the same methodology when looking at a sharepoint website, I get an error at Filename = Dir(DefPath & "*" & Format(CurDate, "Mmmm") & "*.xls*, vbNormal) and yes, the file is on the...

Hi, I would like to ask if it is possible to transfer the data inputted on a User Form to a worksheet of an Excel file located in a SharePoint? The coding that will be used is VBA. Your prompt response is much appreciated. Thanks!

I have multiple monthly reports on a SharePoint website with sales data on the "Summary" Tab. I am using a Data Validation drop down list to ID the months I would like to pull in. <tbody> November 2013 December 2013 January 2014 Sales XX XX XX Inventory YY YY YY </tbody> As...

I have weekly historical sales information on a SharePoint website. ie: Results 2014.04.04.xlsm Results 2014.04.11.xlsm Results 2014.04.18.xlsm I am creating a summary workbook where I would like to access sales data from each on the sheet stored on SharePoint. Additionally, I would like to...

Hi Team, I am trying to figure out a way to connect an Excel sheet to SharePoint list. Right now, I have a table in a Access file that is connected to a SharePoint list. And another table in the same Access file that is connected with Excel. But there is no connection between the Excel and the...

I am using a SharePoint site to house a document that has links using Smart View. Every time I open a document from the SharePoint site, the Smart View link automatically adds a web link back to the place the file is housed in the SharePoint site in front of the Smart View link. Does anyone know...

Hi, I have a rather complicated question. I have about 15 reports(Excel) on a share point that get run every month. All of these reports have extremely complicated macros, PI data links and calculations. I have one workbook(Excel) that opens all of them up, one by one and recalculates them and...

Hi, I have a pivot table that references a SharePoint list. In the sharepoint list, there are checkboxes which export to Excel as TRUE or FALSE depending on whether they are checked or not. For a given pivot table column, I am trying to calculate the % of the data total that are displayed as...