chiswickbridge
Board Regular
- Joined
- Feb 2, 2013
- Messages
- 127
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...
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...