?
Solved

Copy data between Excel Workbooks

Posted on 2006-07-03
10
Medium Priority
?
331 Views
Last Modified: 2006-11-18
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.
0
Comment
Question by:millikens
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 14

Accepted Solution

by:
ECNSSMT earned 336 total points
ID: 17031026
its not an issue.  you can save the entire excel workbook  as the latest version.  otherwise doublely, its just a plain copy and paste.

regards  
0
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 332 total points
ID: 17031098
Like ECNSSMT, u can just open as its backwards compatable then save to different version types

If u have a new version of excel, and someone has a older version or they dont have Excel installed, and they wish to see it, u can always get them to download the Excel viewer http://www.microsoft.com/downloads/details.aspx?FamilyID=c8378bf4-996c-4569-b547-75edbd03aaf0&displaylang=EN
0
 
LVL 24

Assisted Solution

by:SunBow
SunBow earned 332 total points
ID: 17031109
You might just give them a new directory name for their new saves, to distinguish from the old files that were saved. THis leaves room for contingency such as passing copies through email to 3rd parties. At the time, you can of course suggest that you'll help them through any other compatibility issues as they arise (and likely they will).
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 24

Expert Comment

by:SunBow
ID: 17031122
Generally Office products have not been completely backwardly compatible on initial release
0
 
LVL 14

Expert Comment

by:ECNSSMT
ID: 17031315
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,
0
 
LVL 2

Expert Comment

by:Eksteen
ID: 17036639
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
0
 
LVL 14

Expert Comment

by:ECNSSMT
ID: 17037048
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,
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
This month, Experts Exchange’s free Course of the Month is focused on CompTIA IT Fundamentals.
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question