Hello everyone
I’m new in this forum and I have a “short” question. I’ve been searching for some time in the internet for a solution, but I haven’t found a good way to solve my problem yet. It may be, because I don’t really know the terms I should search with.
But, to my question:
Since version 2007, office saves files in a kind of zip-archive, which you can also extract by your own. If Excel opens a file, does the application extract this file to somewhere on the hard disk to use it (as long as the file is open in Excel) or does Excel it only load into the RAM?
The background to this question is, that if the structure in the zip-file is saved on the hard disk and Excel reads and writes its xml-files into this structure and when you save the workbook, this structure gets packed back into the xlsx-file, then you could add other files (like pdf’s or 3D-data, …) into this structure, which where embedded in the xlsx-file. In this case, I could access this files with Excel itself (access with VBA to the path).
The advantage of this idea would be, that you can “guarantee”, that the files you added are “always” with the xlsx file (because they are included) . If I want to share the Excel-file, I don’t have to copy the other files with the xlsx to share them (this is a disadvantage of a normal hyperlink ).
I hope that Excel works this way, and of course that someone would know something about that to help me
I really appreciate any help you can provide.
With kind regards, Ramon
PS: If you find any spelling mistakes or other grammar mistakes, which belong to my English skills, you can keep them
Bookmarks