Copy One Sheet From One Closed Workbook To Another Closed WB

I have a system that recieves updates on a regular basis however every time an update is released a fresh install is required due to a setup sheet - however i have worked out if i copy the setup sheet and paste it into the new version everything works fine the issue i have is copying said setup sheet

i wish to automate the process by using vba to copy the sheets the vba code will be in a totaly seperate workbook - ideally with the other 2 workbooks closed

i tried using

Please Login or Register  to view this content.

but for some reason it wont work

can somebody please advise me

teshi...

i have 20 standalone PCs that all need to run the same version of a excel workbook - there is one sheet that contains setup info e.g. their printers, file save location, and email address for their PC - it is very time consuming to carry out an update on these 20 machines as i asked earlier for the Internet connection test code i will be using VBA to download the updated version of the sheet from the NET

the issue then arrises with data on the setup sheet - i wish to copy this sheet from the previous version to the new version. thus maintaining all of the information that is hidden from the users view - i also wish to do all of the copying and updating from a seperate workbook.

e.g.

WB1 is the older version containing the setup sheet
WB2 is the newer version - not containing the setup sheet
WB3 will be my updater that will do the downloading and updating of WB2

thanks for your help roy