PDA

View Full Version : Save to SharePoint Library w/meta



SilverSN95
06-07-2010, 06:53 AM
Hello,

This question might be more of a SharePoint one, but I'm hoping someone might know if this is possible:

I have a report template built in excel that I would like to be able to save to a SharePoint list that will group the reports based on meta data making it easy to find relevant reports.

Unfortunately I havn't been able to find a direct way to set the meta data in the save macro, so users would have to access SharePoint and enter it manually there which pretty much defeats the purpose.

Does anyone know if this can be done with vba?


Thanks.

One a side note, I've noticed that if the user manually saves the file, a prompt from SharePoint displays asking for the meta data to be entered. When using .SaveAs this never displays. Could there at least be a way to have this functionality with the macro?

adamsm
06-07-2010, 01:44 PM
Could you upload either a scrapped version of your current workbook for better understanding of your problem?