How to develop an OPEN / SAVE function for user entries, or how to SYNC

Hello everybody and thanks for reading,

I created a little excel program where users can fill their data in a few sheets and have the results in the
last one. The program needs now to be able to save the user entries and to load them.
My idea was to group all the entered data on a single sheet (let's name it Entries) through simple links
(=Sheet1!A1 for example). This sheet would the be exported. I have then several questions.

1. What would be the best export format?
Raw text files or csv would do the job, but maybe saving as XML or as an excel worksheet would bring some
valuable functionalities.

2. Fixed saving path or user entry?
Allowing the user to save their project where they want would definitly be the most elegant solution. But
saving and opening everything from a fixed location is, for the sake of simplicity, also a good option for me.

3. Save macro
The internet is full of examples for saving whole or parts of Excel files. The most common methods are using

Please Login or Register  to view this content.

Does that look good to you guys or would you recommend something else?

4. Open Macro
I could not find exactly what I was looking for. Good examples are here or
here, but they are only about to copy data from the saved sheet in the the active workbook.

If I do that, I would erase all my links that I created in my Entries sheet. Is there a way to syncrhonise the data? With temp sheets maybe? And would it be possible to avoid, in my VBA import macro, to manually enter all the fields destination? That's where syncronisation would be terrific! :-)

Well, I hope I have not been too long. Thanks for your input!

I can maybe summarize the most important question.

Saving a sheet is fairly easy through VBA commands as:

Please Login or Register  to view this content.

But how can I effectively open the saved file and copy all the data into my program?

The examples on the net always have the same problem. That is: if I just copy the data from the saved workbook, all my "links" will be erased. Is there a way to synchronize the data?

Or is the only solution entering manually all the cell values in VBA and doing hundreds of range copies?