How would I even start to write code that would open a file update links and calculate cells and then close the file?
I am looking to do this in turn for 10 files but all from one macro. What it is I had a 65mb Excel file (a business model) obviously this was causing problems in itself so I have split it down into a 20mb data file with 9 x 5mb smaller files which all link to the main one.
Thanks.
Jamie.
Thanks
Jamie
I am looking to do this in turn for 10 files but all from one macro. What it is I had a 65mb Excel file (a business model) obviously this was causing problems in itself so I have split it down into a 20mb data file with 9 x 5mb smaller files which all link to the main one.
Thanks.
Jamie.
Thanks
Jamie