Link to home
Start Free TrialLog in
Avatar of millikens
millikens

asked on

Copy data between Excel Workbooks

Having recently updated and Excel Application, I would like to provide a procedure to allow users to select a previous version from which data in relevant spreadsheets is then copied to the same spreadsheets in the new verions.
ASKER CERTIFIED SOLUTION
Avatar of ECNSSMT
ECNSSMT

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of rockiroads
rockiroads
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Generally Office products have not been completely backwardly compatible on initial release
Avatar of ECNSSMT
ECNSSMT

I'm trying to figure out the last statement as for example the transition of MS Word 5.5 (DOS) till the latest XP version (and even Office 2007 beta)  and Excel (which is implicitly implied here); I haven't seen exclusions to cause a upwardly transition a problem.  

However, MS sometimes lapses and transition between the  previous version and back again can cause problems. I've had irksome times in Access due to THIS problem.

Regards,
Access has a different way of looking at the database and a lot of chnages has taken place... sometimes you will ahve to redo most macros as they do not adehere to the new security standards....

for apps the files format from dos to windows chnged.... and then again with office xp... and a major chnage will be again in office 2007
oh yeah, found that Macro to VBS issues out a long time ago; I remember how it was prior to 97.  Although that was the biggest bump in the road, they have had many other smaller bumps along the way, but it should not effect the the context of this question.  
I am testing 07 right how and in true MS fashion; they've rearranged just about everything.  The cosmetic changes makes me feel that they've hired a disgruntled fashion coordinator who every day probably is thinking to herself "the color scheme is all wrong", repeatedly,... in succession. (LOL)  I have yet to get to the point where I'm "checking out the engine"

Regards,