The paste:=xlvaluesandnumberformats will cause a problem with late binding or
early binding--'cause (like you said), it doesn't exist in xl2k.

I don't think that there's a way to steal from one version to the previous.
(maybe just upgrading those stragglers!??)



Michelle To wrote:

Hi Dave,

What you have mentioned does make sense, and I have done that before.
However, for example, I have used a Paste Special command for only
pasting values and number formats in XP. (PasteSpecial
Paste:=xlValuesAndNumberFormats) But the problem is, this command does
not exist at all in 2000, as a result it throws an error. So I have put
in (PasteSpecial Paste:=xlValues , PasteSpecial Paste:=xlFormats) as two
separate commands in the code. By doing so, now I have to go in and
re-format everything. Because this is a long set of code, I was just
wondering whether there was an easy way out of just importing a
reference library or somehow be able to use more than one excel
reference library.

If you have any suggestions for this, I would much appreciate it.

Thanks,

Michelle

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

--

Dave Peterson