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

Read More

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.

Read More