Publish Data To Sharepoint Calendar
Nov 16, 2007
I use an excel report that connects to an external sql datasource and using macros imports and arranges the data showing dates, job number, description and author of various jobs coming up at work.
I want to publish this spreadsheet's contents onto a calendar in excel or (preferably) onto a sharepoint calendar.
Does anyone know how to:
1) Publish the spreadsheets contents into a calendar in excel?
2) Publish the spreadsheets contents onto a calendar in sharepoint?
View 3 Replies
ADVERTISEMENT
Apr 16, 2014
I created a macro on an excel file on my local PC that opens another excel file on my local PC and copies some data from file 2 and pastes that data in file 1. In file 1 have a Path and File Name that the Macro uses to get Open File 2 from. This works Great on my local PC!! However, I need to move this to a SharePoint. When I did I tried to change the Path and File name to the ones from the URL generated by SharePoint Send Link. No Luck, then tried to change the 20% replace for spaces. Still no luck. Do I need to use some other method of opening a file that is on SharePoint vs Local PC?
Currently have I have:
Sheets("Labels").Select
Path = Range("b2").Value
BenFile = Range("b3").Value
InterOpFile = Range("b4").Value
NMOCFile = Range("b5").Value
SECFile = Range("b6").Value
VistaAFile = Range("b7").Value
and Later in the Code:
Workbooks.Open Filename:=Path & BenFile
View 1 Replies
View Related
May 30, 2007
I have an Excel workbook that has a data connection to a Sharepoint List. I have 4 columns showing the quaterly status of a project. I want to apply conditional formatting based on the value in the column. I have 5 possible choices so I have to use VBA code to accomplish this because of the limit of 3 option in Excel. I am using this
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
Set rng = Intersect(Target, Range("X:AA"))
If rng Is Nothing Then
Exit Sub
Else
Dim cl As Range
For Each cl In rng
Select Case cl.Text
Case "1"
cl.Interior.ColorIndex = 4
Case "2"
cl.Interior.ColorIndex = 6
Case "3"
cl.Interior.ColorIndex = 3
Case "4"...............................
View 3 Replies
View Related
Aug 8, 2012
I inherited a spreadsheet to manage that is linked to a SharePoint table.
It is trying to populate a date that a certain "Tier" is selected (1, 2, 3, or 4).
It works great if I manually type in the tiers, but does not run on existing data (about 400 records) or lines that are updated and new via the SharePoint list.
How can I have this run on all of the existing lines and anything added or changed in the future from the list?
VB:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("AD2:AD10000")) Is Nothing Then
Application.EnableEvents = False
[Code] ....
View 9 Replies
View Related
Aug 13, 2008
I developed a small program using Microsoft Office Excel 2007 and VBA. The program contains some user interface items such as command buttons and userforms for user input.
During the distribution of the program I realised that most users do not have Excel 2007 yet. When I try to convert the file into Excel 97/2003 it is not possible because I used features not available in this version.
I was wondering if there is any way of publishing the Excel file in the web. In this way Excel 2007 would exist in the server and the users could use the file directly from the server without needing Excel 2007 installed in their computers.
I tried to save the file as "Web page" or "Single File Web Page" but the "buttons" stopped working, I guess the VBA code is not saved..
View 4 Replies
View Related
Nov 7, 2007
We are a construction company.
We travel and do work local.
Some employees that have access to the internet at home.
Some have access when they stay at hotels.
What I would like to do is give them a work schedule on our website.
I would really like to do this using VBA.
Is it possible to save the worksheet and send it to our website?
I would love to attach a Macro to a button so the person, after updating the schedule, just punches that button and the updated sheet goes on our website.
View 9 Replies
View Related
Aug 17, 2013
I have a list of club members in Excel.
Is there some method in Word that allows a directory in Word to update from the Excel List?
E.g. If new members are added to Excel, When I open Word, the new members are shown automatically?
View 1 Replies
View Related
Feb 3, 2010
I have this spreadsheet that I use regularly and that others also view (not edit) and to facilitate viewing, I would like it to go on the net.
Ideally, simple editing would be done from within the browser.
View 5 Replies
View Related
Feb 18, 2011
Im trying to use excel as part of an real time display system, what im looking to do is after xx time period import some data (which is fine, I have that bit sorted), then save to as html- (hopefully using excel 07 abilty to repubish data to update the same file with more info).
I have added some Javascript to the html file to auto scroll, and then will be adding a refresh script which should hopefully update the display with any new info genrated from excel...
so far I have found the following code, but could do with a hand to tie it all up!
Code:
Public Sub Watchon()
State = "Mointoring Folder..."
Timerun = Now() + TimeValue("00:10:00")
Application.OnTime Timerun, "DetectNewFiles"
Userform1.Nextupdate.Caption = ">Next Update will be @: (" & Timerun & ")"
With ActiveWorkbook.PublishObjects.Add(xlSourceSheet, _
[code]....
Then within DetectNewFiles Sub, I need to update the html data, I guess I can't reuse the above bit, as it would just overwirte the whole file (and so remove javascripts too).
Code:
Sub DetectNewFiles
'Some code to import text files to excel
With ActiveWorkbook.PublishObjects("Book1_24990")
.Publish (False)
.AutoRepublish = True
End With
Some code to reset next time update of DetectNewFiles
View 1 Replies
View Related
Feb 26, 2009
I am trying to write a macro that publishes the print area as a non-interactive web-page to a file that sits in the same location as the spreadsheet from which the macro is being run.
I am using the the following macro:
View 14 Replies
View Related
Jan 8, 2010
I have a program where I can update the calibration due date of an item. I have attached a cut down version of my program showing the relevant areas. There is usually password protection on the worksheet so it can only be edited via the form (the vba coding removes the password protection before editing, then re-enables the password protection after editing). The "Update Calibration" button is usually on a "Menu" sheet.
Once the form is opened a serial number is typed in the textbox. The calendar button is then clicked, which brings up another form with the calendar on. The due date is selected on the calendar. When "OK" is clicked, the date label caption is then changed to the selected calendar date. When "Submit" is clicked, the spreadsheet will search for the Serial Number, once found, the label caption (being the date selected) will be entered into the cell to the right of the serial.
If the day selected on the calendar is greater than 12 the date is entered correctly onto the sheet. example: calendar date selected = 15/01/2010. shown on sheet as 15/01/2010. However, if the day selected on the calendar is 12 or less, the date is for some reason entered incorrectly onto the sheet. example: calendar date selected = 08/12/2010. shown on sheet as 12/08/2010???? What is going on here? how come the day and month are swapped around if the day is less than 12????
View 4 Replies
View Related
Dec 24, 2009
Using Excel 2007 Calendar Control:
I want to select a date of choice from a calendar in a field within an Excel spreadsheet.
I do not know how to do userforms and so that is why I wonder if I can add this in just a spreadsheet.
This is how far I have gotten so far: After doing the following, I have a static calendar setting in my spreadsheet like a text box showing the current date.
Developer
Insert
More Controls
Calendar Control 12.0
View 9 Replies
View Related
Mar 7, 2009
I am using a great pop up calendar without ActiveX made by a guy called Phil Johnson. When you click a specified cell the calendar appears. The only problem is that the calendar doesn't default to today's date when it opens.
I have the original file Calendar source code if anyone needs it.
View 4 Replies
View Related
Oct 13, 2009
From a SharePoint list I need two important columns in Excel (there are more columns in the list..). These colums contain a number and a single line of text belonging to that number. Many users have their Excel sheets with this information. Unfortunately the users maintain these lists manual. I know I can export a list to Excel, but I want to integrate the data in existing list. Users are forced to build their excel sheets in the way a SharePoint list is build, so the data can be integrated. When a new item is added/deleted/changed in the list, the excel will automatically update. Is there a way to realise this? For example with an extra monitoring column which says which line is updated, deleted etc.
View 10 Replies
View Related
May 25, 2011
I have a doc on sharepoint called adamc.xlsx
When I open the doc I would like the workbook open event to check the document out for editing on the workbook close event i would like it to be checked back in...
Been playing around with Workbooks.CancheckOut but I've completely lost the plot.....
View 9 Replies
View Related
Dec 3, 2012
1) I have a excel on a sharepoint, i want to link it to the other sharepoint. Can this possible.
2) I want to open a excel which is in sharepoint, and export it to network place created in my computer. then save
View 2 Replies
View Related
Nov 5, 2008
I have a Userform that has a TextBox named TextBox5 when double click, it opens a calendar form. When the calendar closes it places its value into TextBox5.
View 9 Replies
View Related
Aug 29, 2006
I have data pertaining to our fleet of trucks in 8 (1 for each plant)worksheets, sorted by truck number. I would like to enter a date (usually a monday) next to a truck number and then have the corresponding date plus 4 colored and/or have the truck # inserted on a calendar I have formatted in another worksheet with 31 columns and 12 rows.
View 2 Replies
View Related
Aug 18, 2011
I would like to find out the excel VBA code to copy files to a sharepoint directory ?
View 5 Replies
View Related
Dec 5, 2012
I need to upload the excel file (Book1.xlsx) which is placed in my desktop to the sharepoint 2010.
View 1 Replies
View Related
Jan 13, 2009
I want to find the average value for each Jan 1st, 2nd, 3rd ..., for a data set of five years. How do I do this quickly? I can filter, but would have to do that 365 times and involves a lot of pasting. I tried a pivot table, but basically came down to the same problem, although I don't understand pivot tables that well.
View 9 Replies
View Related
Apr 18, 2014
I want to search for a file in Sharepoint using Excel 2007 VBA.
Path to the Sharepoint location where the files are at is [URL] ....
File name is customer_list_xxxxxx.xlsx The x's are a date which changes every day or week. So a new file will be uploaded to the sharepoint path.
Example customer_list_041414.xls
I've tried so many different code options for this, but no luck.
View 1 Replies
View Related
Jun 24, 2014
We have mapped a network drive to a SharePoint Directory, while we are able to copy a file (using Macros) to this location, this file does not appear in SharePoint to the other users, the reason being that it is not checked in. How to Check using Excel Macros.
[URL] .....
View 1 Replies
View Related
Jun 1, 2014
At work we use a connection to a SharePoint List within Excel to refresh the data in the files.
When excel is refreshed I get this error (this happens for all users in the team and multiple workbooks)
Image 1.png
The weird thing is I can export the SharePoint list to an excel file and it is fine but as soon as i go to refresh it (Data>Refresh All) it produces the above error.
View 1 Replies
View Related
Jul 1, 2013
I've just exported a list from SharePoint to Excel, which gave me as a result a owssvr table, so far so good cause every time the list in SP is updated I can do a refresh and get the latest values; however once I opened the table I realized that the columns where not correctly order they were all mixed and the information does not look as it is required so I need to rearrange them. I do not need to delete a column I just need to be able to move them between themselves so that they will follow certain order: Product ID, Name, Amount of pieces, Place where they are stored, etc. this is very important because later on I use "vlookups" to do a series of reports.
I've tried cut- paste to move the columns to the correct position, unfortunately once I close the excel file and try to open it again, I got a message saying that the content is not readable and when Excel repairs it, my owssvr table loses the link to SP so I cannot update refresh the table anymore.
I cannot edit the list in SP as this site does not belong to me and I only got access to export the data and be able to refresh the table, all I want is to be able to move them within my ovssvr table so that locally I can work with them better.
Here is a pic of what I am talking about: cmms.JPG
So for example in the pic I put, I need that instead of Comments in Column E, Product ID can be in Column E, then Name in column F and so on..
View 1 Replies
View Related
Mar 9, 2011
how to traverse all files in SharePoint folders using Excel VBA and have not come across an answer I could use because, by configuration design, I cannot map a SharePoint URL to a drive letter.
Here it is:
Sub SPDir()
Dim wb As Workbook
Dim dummyFile As String
'
' The file specified by dummyFile must reside in SharePoint in order to use SharedWorkspace
' The way the code is set up, the path and filename in dummyFile should NOT substitute %20 instead of spaces
' There is logic later to ignore dummyFile on output
' Substitute your own dummy file name below
[code].....
View 9 Replies
View Related
Jan 4, 2012
I'm using VBA to query file information (path, name, size, dates, etc.) on files on a SharePoint site and returns them to Excel. I'm curious if also returning the document's permissions is possible. If not for the document, can one programmatically get the folder's permissions?
View 6 Replies
View Related
Jun 14, 2013
How to import data from an access database, specific tables, to excel using vba; the trick being the database is stored on SharePoint Server 2010.
View 2 Replies
View Related
Jun 17, 2014
I have recorded the below code that functions fine from my computer. My issue is that I need to export/import this macro to other workstations who may have the save to location mapped to a different drive letter. Is there a way to replace the drive letter with the URL (SharePoint)?
ChDir "E:3. CRQsRemedy Dumps"
ActiveWorkbook.SaveAs Filename:="E:3. CRQsRemedy DumpsToday_CRQ_8Dump.xls" _
, FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Save To Directory: \server_1Dir_1Dir_2FolderToday_CRQ_8Dump.xls
Permissions are in place.
View 1 Replies
View Related
Jun 24, 2014
We have mapped a network drive to a SharePoint Directory, while we are able to copy a file (using Macros) to this location, this file does not appear in SharePoint to the other users, the reason being that it is not checked in.
How to Check using Excel Macros.
View 2 Replies
View Related
