Copying Data between Workbooks

[Steve]

As new versions of a spreadsheet system are released, I
would like to add a button that will allow a user to
select the previous version ( file locations and name ) of
the program and then have excel import the relevant data
from that workbook to the new workbook.

Any help would be appreciated.

Thanks

 

[Peo Sjoblom]

You are a bit frugal with your info, why not just use

filename=Application.getopenfilename("Excel Files (*.xls), *.xls")

you could also use an inputbox where you would put the path name etc

However if you know where the old workbook is why not just hard code the
macro to open the old file?


--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom