Just learnt something new from user, which is we can run macro then the excel file can save to SharePoint document library .
here is the code :
Sub TestSave()
FolderPath = “http://sharepoint.abc.com/sites/abc/docmentLibrary/”
SavePath = FolderPath & "sinpeow.xls"
ActiveWorkbook.SaveAs Filename:=SavePath, FileFormat:=xlNormal
End Sub
2 comments:
SharePoint is basically a web based management system that enables employees to collect and configure resources through a common platform.
SharePoint Consulting
Today SharePoint Consulting were very popular and their advisors to provide their best service for your business organizations.
Post a Comment