2003 - Copy sheet from closed 2007 file

[Cresta]

Hello

I am using Excel 2003 and would like to copy a sheet from a closed 2007 file
to a new (closed) 2003 file.
I can do it if its all 2003, but not both versions. Does anyone know if it
is possible.

Thanks

 

[Dave Peterson]

It would depend on if how that 2007 file was saved--was it saved as a normal
xl2007 file or a xl97-xl2003 file?

Do you have the compatibility pack installed so you can open xl2007 files in
xl2003?
http://www.microsoft.com/downloads/...70-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en

(remember that xl2003 only has 64k rows and 256 columns!)

But in either case, I think you're going to have to open the xl2007 file and
save the new xl2003 file.

 

[Cresta]

It is saved as a 2007.xlsb to keep the filesize down and the speed up.

 

[Cresta]

Adding the compatability pack made no difference.

I am getting a #REF! when looking at the 2007.xlsb, but it works OK looking
at then 2003.xls

Both files are identical to the user.

 

[Dave Peterson]

Are you opening the xl2007 file or are you using a formula with a link to the
xl2007 file?

I've never used the compatibility pack, but it wouldn't surprise me if the
compatibility pack works when you open the file--not when you link to a file
saved in an xl2007 fileformat.

 

[Cresta]

My boss has asked if this 'plan' is going to work, I think I can safely say
no, and that we need to look at a more simpler route by doing it from the
2007 end and saveas 2003.

Thanks for your help.

 

[Dave Peterson]

I'm not sure what the plan is--you didn't answer my questions.

But if you and your boss are satisfied, good luck.

 

[Cresta]

Sorry Dave.

We have a core set of xl2003 files which feed off a couple of hundred xl2007
files. Until we have migrated these core files across to xl2007 (big job), we
need a workaround to keep the workflow as foolproof as possible.

This is our workflow plan:
From an open xl2003 file, create a new xl2003 file. Copy a named sheet from
a closed xl2007 and pastespecial its values to a sheet of the same name in
the new xl2003. We would loop through the hundreds of xl2007 files quickly if
it could be done.
However we have dropped this plan, and the responsibility is going to be
with the xl2007 file owner to to the copy from their file saving as xl2003
version. Keeps it simple but open to problems like "I forgot". (I'll probably
end up coding a procedure to do it for them)

Fortunately this is only while we migrate the core files to xl2007 which
should only be a few months away.

Thanks again.

 

[Dave Peterson]

Good luck.

Training issues are always difficult to implement.

Sorry Dave.

We have a core set of xl2003 files which feed off a couple of hundred xl2007
files. Until we have migrated these core files across to xl2007 (big job), we
need a workaround to keep the workflow as foolproof as possible.

This is our workflow plan:
From an open xl2003 file, create a new xl2003 file. Copy a named sheet from
a closed xl2007 and pastespecial its values to a sheet of the same name in
the new xl2003. We would loop through the hundreds of xl2007 files quickly if
it could be done.
However we have dropped this plan, and the responsibility is going to be
with the xl2007 file owner to to the copy from their file saving as xl2003
version. Keeps it simple but open to problems like "I forgot". (I'll probably
end up coding a procedure to do it for them)

Fortunately this is only while we migrate the core files to xl2007 which
should only be a few months away.

Thanks again.