Hi Sunny,

The first few rows of module 11 are garbled as quoted below, could you please show me the right script for my reading. Thanks.

Sub ?()
Attribute ?.VB_Description = "? : 2011/1/4  ? : Naomi Lee"
Attribute ?.VB_ProcData.VB_Invoke_Func = "U
14"

'Copy and save previous data

Regards,

Julian

Hi Julian

My codes are in Module 1 and Module 7 (I should have put them together).

The others are not my codes and it came with the file.

Sunny

Sorry,  some codes are denoted in Jap/Korean Language.

David

Can it be opened to me?

OK , no problems let me tidy up a bit the VB code, then share it with you after the Chiense New Year Holidays.

Again thanks Sunny  the great contributions you put forward so far ..

Glad to be able to help and Happy Chinese New Year.

Sunny

Julian

Per request I attached the other Codes  hope this can be useful.

David

Thanks for your sharing in advance, David. By the way, Sunny has also helped me working out a VBA script to play a Window Media Player's playlist in Excel. Should you have interest in it please check here .

Hi David,

As I have no intention to break your VBA password, you may forget my request anymore. Happy lunar new year.

Julian