Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an existing macro that first allows the user to open an xls
file, then it copies data from the selected file into the one where the macro is located. This info is added to the existing data that's already there. The user will run the macro multiple times (once for each file to be added) ....thus ending with a "master" file composed of data from each file they had selected. That part is done. Now, on a separate sheet in the macro file I'd like to create a log where each row shows the name of each file that had been opened and copied into the master, along with the date when this was done. How would such a macro work? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
File Names within a Macro Function | Excel Worksheet Functions | |||
Macro File Names | Excel Worksheet Functions | |||
Macro File Names | Excel Worksheet Functions | |||
Can a Macro use Different File Names? | Excel Programming |