I use vba to create monthly accounts files and save these to dirctory on the PC or server. I have now been asked to save the files to sharepoint instead. I have accessed the document properties within excel and am organising a link to our sharepoint site. We normally organise files by year, period, then by project name/number. However I need some general advice on how to translate our current file structure method of organising files into a sharepoint environment and how to use vba to save a file to sharepoint. Thanks. Alex