Hello all,
I have a variation of a question that's been asked multiple times on this most excellent board, however, I've not been able to find an example pertaining to my situation. Maybe one of you can provide some insight.
I have several workbooks located across various SharePoint sites. I'd like to create a macro in each of these workbooks that copies (values only) all the sheets in the workbook, except 3 ('Summary, 'Template, 'List), to a central location, a workbook called RollUp. This Rollup workbook will also likely be on SharePoint but could possibly be located on a desktop.
Does the fact that these are located on SharePoint create issues with the copy syntax? I'd also appreciate some guidance on the macro itself as I'm not quite sure what it would look like.
Thanks much!
I have a variation of a question that's been asked multiple times on this most excellent board, however, I've not been able to find an example pertaining to my situation. Maybe one of you can provide some insight.
I have several workbooks located across various SharePoint sites. I'd like to create a macro in each of these workbooks that copies (values only) all the sheets in the workbook, except 3 ('Summary, 'Template, 'List), to a central location, a workbook called RollUp. This Rollup workbook will also likely be on SharePoint but could possibly be located on a desktop.
Does the fact that these are located on SharePoint create issues with the copy syntax? I'd also appreciate some guidance on the macro itself as I'm not quite sure what it would look like.
Thanks much!
