I have a very large excel spreadsheet (12mb) which I want to include in another excel spreadsheet (3mb). Is this anyway using a macro that I can compress the first set of data to say 1mb or less to then include in my excel spreadsheet? I have tried to create a text file which does reduce the size to 5mb. The 12mb file contains vehicle information with a "|" between each variable.
Any help would be appreciated.
Cheers
Michelle