Hi Guys and Gals
I'm looking at a way of automating a manual process we're currently doing. The process is:
1) Upload excel file from network drive to sharepoint (In the web access)
2) Set the properties (Title and Document Type)
3) Click ok.....
Sounds slick but our web access is terribly slow.
What I think I want is some VBA code to:
1) Copy the excel file from a network drive to sharepoint
2) Set the properties of that file in sharepoint
3) 'Check in' the file so its visible to others.
Is this possible?