Text extraction for translation

[poitbot]

Good afternoon all,

I'm attempting to create a macro that would extract all the text from an excel spreadsheet with multiple worksheets, remove all the duplicate words and place the file in a format that would allow it to be imported back on top of the current file with the newly translated words. The workbooks would be different every time...

Is this possible with a macro or would I have to upgrade to an external VB script?

Thanks,

Adam