External data file

[roscoe]

I have a workbook that uses info on multiple sheets that the macros require. I'm now sharing that workbook with others, and they will have need to put their own unique info in some of those cells. However, the workbook is in constant update mode as I fix bugs and add features. When I distribute a new version, any changes that they have made to the previous version are lost and have to be recreated.

My thought is to create a separate user file that they keep on their computer wherre they store user unique data, and my workbook will somehow pull the data from that file. That way any unique changes they make are preserved. All the data are included in dynamic ranges.

How would the smart folks on this board recommend I do this? My biggest concern for robustness is if the user file were deleted. I was thinking an "if file exists, overwrite this data with their data" type of routine. Just not sure of the best way to do this other than a brute force cell by cell, column by column.

Ideas?

 

[roscoe]

Disregard...found a fast method I can use already.