in reply to Preserving metadata when processing Excel file
Why don't you simply separate the two items? Data (your values) in one Workbook and the formulae/charts in another.
Using this approach you can happily (?) use Spreadsheet::ParseExcel to read the spreadsheet and Spreadsheet::WriteExcel to spit it back out with the new numbers... the linked spreadsheet isn't getting modified and as long as you can ensure that the filename is preserved (i.e. you don't clobber the file as someone opens the other workbook - Excel might not like that) everything should be ok.
Alternatively, store your values in a CSV format file(s) and write an Auto_Open macro in your main spreadsheet to import the values into 'named ranges' in your spreadsheet - this saves worrying about "Update Links" messages. Then you have to worry about how 'fresh' the data is.
Your approach will depend on how often the data is modified, I guess...
HTH - Mark
|
|---|