Copying data without linking sheets

[chiswickbridge]

I have a xls file, about 5Mb, in the following folder.


D:\portpaper\main\data\ship.xls


ship.xls has only one sheet called "rawdata".


I have a second file in another sub-folder of "main".


D:\portpaper\main\aus\crew.xls


crew.xls has only one sheet called "list".


Without linking the worksheets, I need a macro to import data from "rawdata" to "list"


The actual process starts as follows.


ship.xls is updated and saved with a password called 'password" and closed, say once a day.
Crew.xls is manually opened and then as required I will activate the macro, which will automatically open ship.xls, using "password" as the password, copy select data as required and close ship.xls.


I need only data from A10 to H99 from "rawdata" to be copy pasted only values to "list".


I can tweak to choose different cells as required at a later time.


Looks complicated....?


I have had linked workbooks and it has given me headaches with broken links.


Is there a better way to to import or copy paste data or my process looks irrational...

 

[welshgasman]

Carry out your process and record a macro before doing it.
That would give you the bulk of the code and then you can tweak it as you see fit.