<div>
I have a grid of data values, 10 rows by 10 cols, I would like to store this in the registry as comma deliminated to a data key, so later on I can retrieve the sequence for a particular date, therefore my users only need to load a central sheet and the data is fed from there local registry.
</div>


<div>
You that may work, I prefer registry because its there!.<br />
<br />
How would I write a range to a file and retrieve it?<br />
<br />
Thx
</div>


<div>
Ok, thankyou for that, after I set set rng manged to get it to work, it writes the data to a file as if its printed which is ok, but when I recover the data and place into a cell I get an copy of such, problem with that is I need it to mirror whats been taken,<br />
<br />
So if I save range A10:G50 for example this is comma deliminated to a file, when I import the data goes back into A10:G50.<br />
<br />
Thank you
</div>


<div>
Do you want to store actual range objects?<br />
<br />
If you do then I don't think it's going to be possible unless you actually copied/stored them in another worksheet.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have tried several methods but failed...<br />
<br />
I need help to write a range, say A1:D20 to the registry using a key defined by the date for example DC2016.09.18 {data}<br />
<br />
Therefore everyday the same range is stored to a new key, and I will also need to recover this information.<br />
<br />
Thanx
</div>
</div>


Hi,

I have tried several methods but failed...

I need help to write a range, say A1:D20 to the registry using a key defined by the date for example DC2016.09.18 {data}

Therefore everyday the same range is stored to a new key, and I will also need to recover this information.

Thanx

Writing a range of data to the registry, contained within 1 registrey entry

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.