Importing a CSV File

Hi,

I am trying to create a Save/Load functionality for a range on a worksheet I'm developing. The user would click save, and this would export the range to a CSV file and save it. Then later they could click load and it would import that CSV file into the same range. I have the export ("save") part figured out, but I'm struggling with the import (load) code. I've included a simple sample worksheet to work with.

Any help would be much appreciated!Saving File Example.xlsm

I've changed your default path. You can try this code:

Please Login or Register  to view this content.

Thanks for your reply ThePower777 - That code does work, but there is a little hiccup for me - I should have included a better example sheet.

This updated one shows my problem, there is a formula cell in the middle of the range that does not need to be copied (it aggregates the cells above it), so that when the data is imported your way - plus one row at a time, it overwrites that cell, and isn't in the correct location. See attached file. Saving File Example.xlsm

In this case if you have predefined rows as formula you can use:

Please Login or Register  to view this content.

Thanks! That works!