LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Macro to log .xls file names

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro recorded... tabs & file names changed, macro hangs Steve Excel Worksheet Functions 3 October 30th 09 11:41 AM
File Names within a Macro Function John Excel Worksheet Functions 2 December 5th 08 07:11 PM
Macro File Names John Excel Worksheet Functions 2 December 5th 08 06:27 AM
Macro File Names John Excel Worksheet Functions 1 December 5th 08 06:23 AM
Can a Macro use Different File Names? markmidwest Excel Programming 1 August 16th 06 10:04 PM


All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"