christian87
10-06-2016, 03:48 PM
Hi Guys,
From a spreadsheet I would like to open another spreadsheet which I have done successfully.
Now what I would the macro to do is to open the spreadsheet which is a shared spreadsheet.
Save AS to another location say my desktop as an unshared worksheet.
So end result I have still have the untouched shared version in my C drive and an unshared version on my desktop.
Any help is greatly appreciated.
I have gotten this far.
Sub Opensheet()
Workbooks.Open Filename:="C:\test.xlsm"
End Sub
From a spreadsheet I would like to open another spreadsheet which I have done successfully.
Now what I would the macro to do is to open the spreadsheet which is a shared spreadsheet.
Save AS to another location say my desktop as an unshared worksheet.
So end result I have still have the untouched shared version in my C drive and an unshared version on my desktop.
Any help is greatly appreciated.
I have gotten this far.
Sub Opensheet()
Workbooks.Open Filename:="C:\test.xlsm"
End Sub