Quote:
Originally Posted by gmayor
Paul's macro does much the same but uses a different method to extract the data from the cells.
|
More than that, though, your code resaves the file with a new name, meaning the user is left with duplicates and the new versions have different date/time stamps plus internal metadata changes (e.g. CreateDate, Author). My code changes nothing but the file name.