beginner
06-13-2006, 12:30 AM
hello....
got a big query and need someone here to give a hand. thanks in advanced...!
1. got 2 Excel files, say file A and file B.
2. file A is the logbook (spreadsheet format) to keep accumulate records. while file B is an Excel file (form sheet format) which being updated everyday.
3. want to put a Macro inside file A (logbook) and after open file A & activate the macro, it will open file B and retrieve all specified fields data from file B and append to file A in pre-defined columns in file A.
Would anyone got suggestions hows those coding would look like....??
Thank you very much for any helping hands...
BR/
beginner
got a big query and need someone here to give a hand. thanks in advanced...!
1. got 2 Excel files, say file A and file B.
2. file A is the logbook (spreadsheet format) to keep accumulate records. while file B is an Excel file (form sheet format) which being updated everyday.
3. want to put a Macro inside file A (logbook) and after open file A & activate the macro, it will open file B and retrieve all specified fields data from file B and append to file A in pre-defined columns in file A.
Would anyone got suggestions hows those coding would look like....??
Thank you very much for any helping hands...
BR/
beginner