PDA

View Full Version : Opening and Saving spreadsheet



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

SamT
10-06-2016, 06:01 PM
In a new Excel book, Record a Macro while opening and saving the shared book. Use the Excel File menu to open the shared book. Store the macro in Personal Macro Workbook.

Macros Stored in Personal are available in all Workbooks.