Open Excel Update File

At times you may wish to open a workbook, add a couple of items from the workbook you are working in to a list and close the workbook. This type of update might be done on a specific set of cells and the results are added to the bottom of a list in a destination workbook.

Let's say we have data in Cells B10:B11 and we want to update our master workbook.

In cell B9 I have a path:

B9 = D:\Example1.xlsx

Tags Excel, VBA, Array, Move, New, workbook, Update

How to Share Un share an Excel Workbook

Recently I was assisting someone on a forum and the workbook they had supplied had been saved as a shared workbook. I have not used shared workbooks and was at a bit of a loss regarding how I might un share the document. I needed to un share it in order to make changes to the structure of the workbook – add lines/columns. These are the steps to share or un share a workbook.

Tags share, Excel, workbook, Unshare